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
Only the following fields can be added into a subform by Quick Fill: Single Line, Multi Line, Number, Date&Time, Radio, Checkbox, Single Select, and Multi Select.
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.
I have finished reading. 🏆
👉I can't wait to ADD RECORDS TO SUBFORM BY PASTING.
👉I need more HELP in Discord Forum.