What is Quick Fill?
Quick fill refers to that you can efficiently fill out subforms by copying and pasting data from Excel spreadsheets into subforms. Also, you can directly edit existing data within the subform through features including Copy and Paste, Cell Editing, Batch Cell Editing, Dragging down to Fill Cells, and Batch Row/Column Data Processing. This feature streamlines the process of filling out forms, saving time and improving overall data entry accuracy.
Where to Use It?
Event Registration: If there are existing registration records in Excel, you can copy and paste this data directly into the subform for easier data aggregation and analysis.
Order Management: Excel order details can be copied and pasted into the subform, allowing for batch updates to existing data.
Purchase Requests: Quickly fill out the procurement details subform, including batch adding material requests or editing existing requests.
What Does It Look Like?
In the order management form, you can copy and paste the order details from an Excel file to a subform in Jodoo.
Note:
To facilitate data entry, a blank row is pre-inserted in the subform. If it is not needed, you can manually delete it after adding the data. Also, the system will automatically filter out any empty rows during data submission.
How to Set Add Records to Subform by Pasting?
How to Set
When designing a form, select the SubForm field, go to Field Properties > Field Permissions, enable Quick Fill, and tick Add New Records and Edit Existing Records.
Fields Available to Paste
The following field types within a subform support Quick Fill during data entry, editing, or form preview:
Note:
1. Some field types, such as Attachment, are not currently supported by Quick Fill.
2. When using a public form link (i.e., form fill-out URL), Member & Members and Department & Departments fields do not support Quick Fill.
Adding Records by Quick Fill
When filling out or previewing a form, you can use the Add by Paste feature:
1. Click Quick Fill under the subform.
2. On the Quick Fill page, you can choose between the following two filling modes:
Add Records: Data entered on this page will be added to the subform as a new record.
Edit Existing Records: Modify and update existing records within the subform on this page.
Note:
1. When switching filling modes, any unsaved changes made on the current page will not be retained. Ensure that all data is saved before switching modes to avoid losing information.
4. Once the subform reaches the maximum limit of 200 rows, only Edit Existing Records mode will be available.
3. When adding/editing records on the Quick Fill page, only the following operations are supported:
Copy and Paste from Excel
Double-Click to Edit Cells
Batch Edit Cells
Batch Edit Rows/Columns
Drag down to Fill Cells
Keyboard Shortcuts for Quick Fill: ctrl/command + c; ctrl/command + v; ctrl/command + z; arrow keys to navigate between cells
After completing the data filling, click Next.
Notes:
1. Invisible subform fields will not be displayed on the data entry page. In "Add Record" mode, only the editable fields will be shown on the page.
2. If a field affected by display rules is visible in the subform before using the Quick Fill feature, it will remain visible on the filling page. If not visible, the field will not be shown.
3. In "Edit Existing Records" mode, users can only modify existing rows/columns of data. Adding new rows/columns is not allowed.
4. In "Edit Existing Records" mode, read-only fields can be displayed on the data entry page but cannot be edited. When pasting data, any content intended for read-only fields will be automatically skipped and will not be transferred to the next editable column.
5. Only in "Add Record" mode, when the user clicks "Next", the system will automatically validate and remove any blank rows from the data.
4. Review the data just entered. You can modify the corresponding fields at the row header, or choose Don't Paste to not copy this column. Once the review is complete, click OK to proceed.
4. The subform will validate the pasted records when clicking OK. A prompt will be triggered if there is any error in the records. You can click Previous to backfill the form or modify the mistaken records on this page.
5. After correcting the records, you can click Continue. If you do not correct the records, the fields where the mistaken records are filled in will be left empty.
Note:
If the error content is not modified, the corresponding value will be displayed as empty after backfilling the subform.
6. Once the validation process is completed, the entered records will be backfilled into the subform. During the backfill process, the system will recalculate the data based on the field data linkage, formula, and front-end event settings, and then update the subform with the final calculated results. Calculation scope varies based on filling mode:
Add Record: all data and fields will be recalculated.
Edit Existing Records: only the fields that have been modified, along with any fields that are dependent on the modified fields, will be recalculated.
Note:
When the data is backfilled into the subform, the validation of the subform fields will be triggered normally.
Quick Fill Validation
Notes:
1. Quick Fill Validation refers to partial field checks on the Quick Fill page.
2. In Edit Existing Records mode, only fields that have been modified will undergo validation.
Single-select Fields
For the types of single-select fields (Radio and Single Select), when the entered value does not match any of the available options, the validation rule is as follows:
1. If the Other Option is not configured for the field, an error will be triggered.
The user must manually correct the invalid value before submission. If left uncorrected, the field will be submitted as empty once the data is backfilled to the subform.
2. If there is "Other" option, the system will automatically map the value to "Other" and place the entered content in a corresponding text box.
Note:
If Look up is configured for the Single Select field, the system will perform option matching validation during Quick Fill. If Data Linkage is configured, the system will perform validation during data backfill. Any mismatched values will be cleared.
Multi-select Fields
For multi-select fields (Checkbox and Multi Select), the validation rules are as follows.
Without "Allow members to add new options when filling out", an error will be triggered. Users should manually correct the value before submitting. If not, only the matching options will be retained in the field, and the non-matching options will be discarded.
If "Allow members to add new options when filling out" is configured, the non-matching value will be automatically added as a new option and checked.
Notes:
1. When entering data into multi-select fields, options should be separated using an English comma (half-width comma).
2. If Look up is configured for the Multi Select field, the system will perform option matching validation during Quick Fill. If Data Linkage is configured, the system will perform validation during data backfill. Any mismatched values will be cleared.
Date&Time Field
When filling out Date&Time field during Quick Fill, the system will validate the entered values based on the field's "Set Time Range" settings. The available settings include:
Selectable Days of the Week
Earliest Selectable Time
Latest Selectable Time
Note:
If the entered value equals the Earliest Selectable Time and the Latest Selectable Time, range validation will not be triggered.
If the entered value falls outside of the selectable range, a validation error will be triggered, prompting the user to manually correct the value. Otherwise, the subform will display as empty.
Member and Department Fields
When using Quick Fill for member & members or department & departments fields in subforms, the system supports validation based on their configured settings.
For the Member and Department field
The following conditions will trigger validation errors during Quick Fill:
Member: The entered member is not within the selectable range, or there is a name conflict (duplicate name) in the address book.
Department: The entered department is not within the selectable range.
You should manually correct the error. If left uncorrected, the corresponding field will be empty after data is backfilled to the subform.
For the Members and Departments field
The following conditions will trigger validation errors during Quick Fill:
Members: Some members are outside the selectable range or have name conflicts.
Departments: Some departments are outside the selectable range.
If validation fails, only the valid entries will be retained when the data is written back to the subform; invalid values will be discarded.
Notes:
1. When entering multiple values in a multi-select field, separate them using English commas.
2. If the Member & Members field's selectable range is configured as “Dependent on the dept. field,” Quick Fill data will be validated accordingly. Only members within the valid department range will be retained.
3. If the Department & Departments field's selectable range is defined via Data Linkage, Quick Fill will perform validation at the time of data backfill. Only departments that meet linkage criteria will be retained.
I have finished reading. 🏆
👉I can't wait to ADD RECORDS TO SUBFORM BY PASTING.
👉I need more HELP in Discord Forum.