Prepopulate SubForm or Data Grid
I am new to this so bare with me...
Whether using a Subform or a Data Grid is there a way to pre-populate the records based on the records entered on the previous day. We are playing with both, but not certain if this can be done.
When this form is brought up in the workflow we would want it to autopopulate from the last day's records so the user doesn't have to key them in again.
The source would be a SQL query from a SQL table.
Any feedback would be appreciated and if one component type is better than the other (subform vs data grid) feel free to explain why.
Thanks in advance.
Greg
-
For subforms just make sure to configure it as repeating (no add, no delete...). The lookup (outside of the subform is a query that maps to the elements in the subform. Then bind the lookup to the subform (repeating field) in the configuration of the lookup.
Use the same query on the grid when you configure it although formatting the cell widths require css..
-
This can be done using an auto-lookup on the form, and triggering the lookup during form load. This gets the data from the database, and it can be bound to either a subform or data grid control.
Subforms are more advanced in comparison to the grid, and using subforms, you can hide/display fields and set rules, whereas in the data grid these options are not available.
Relevant Links:
Subform:
https://documentation.agilepoint.com/00/appbuilder/cloudformSubFormControl.html
Data Grid:
https://documentation.agilepoint.com/00/appbuilder/cloudformDataGridControlAdvanced.html
-
We are currently doing both Data Grid and Subform as Lucas suggested. We use Auto Lookups and the sources are SQL and Sharepoint. SQL Tends to be much faster to respond making the user experience better.
It would be interesting to see how to do the same thing in v7 with Data Entities as the source.
サインインしてコメントを残してください。
コメント
3件のコメント