Mass Create

If you don't see the following features on the sheets, it may be related to your access rights for this sheet. Please contact your SYSAdmin to check the access rights configurations.

Mass Create can quickly generate a batch of records according to specified rules. For instance, creating a whole year of records for Shift Schedule, adding a month of records for Attendance Sheet, or generating a record for each member in the project to report their status, etc.

You can create a record for every number, day, week, month, year, user, option, or based on another sheet's field. In the next step, assign the field you would like to fill with a certain value.

For example, you may have a "Business English" course every Saturday for one whole year. We use this feature to generate Attendance Sheet records for the whole year at once and also assign values to the "Course Number", "Course Name", and "Lecturer" fields.

After completing the settings and executing mass create, you will easily create lots of records without manually entering them one by one or importing data from Excel.

Create Records for Every Number

When creating records for every number, first enter the number range. Then, select a field where the system will sequentially fill these numbers (1, 2, 3,…) into the created records.

Example: Creating products with the same name and model but different serial numbers.

Note: You cannot select an Auto Generate field to fill with serial numbers, as this will prevent automatic generation. If you want the serial numbers to follow a specific format, you can use Formulas.

Example: To display the serial number in the format "Model-Number", you can add a formula in another field, such as "Model Number", allowing the system to show it in the desired format.

Create a Record for Every Record on Other Sheets

You can create records based on the field values on the other sheet.

For instance, if you want to create records for each account in the "Sales Order", and the account information is in another sheet, "Account". You can also apply filters if there are saved filters in the other sheet, such as filtering the records that meet the "Technology Industry" criteria.