1 answer
- 10-1
Hi Chiek, maybe a combination of below solutions might help you out.
https://jogetdoc.int.joget.cloud/jw/web/userview/jdocs/docs/DX8/spreadsheet-deep-customizations
Populate Value in Form Grid with Parent Form Value
How to populate Advanced Grid using JQuery
https://tarkiman.com/joget-workflow-populate-grid-data-with-javascript
Hope this helps. Thanks- Chiek
Thanks Varnaa but the use case in the suggested links are for populating the spreadsheet with data already available on the form instead of loading the data from a database table using a multirow form binder.
I know I can use the database sql query, database wizard or beanshell load binder but I was hoping to avoid that.
- Varnaa
Hi Chiek, just to clarify you want guidance on how to populate data in spreadsheet using multi row form binder?
- Chiek
Yes, when the form utilised has a subform. If there is no subform the multi row form binder works well.
Add your comment...
My app is tracking assets and has a requirement to store previous locations of the asset. The asset details are being imported with a form that has a subform for the asset location, thus creating a one to many relationships.
To validate the importation, I am using a validation form that has spreadsheet element which is populated using the Multirow Form Binder as the Load Data Binder and the form used for importing the assets. Details of the asset are retrieved except the asset location even though it is stored in the locations table.
What fieldname format can I use to populate the asset location spreadsheet column with data from the asset location subform?
Thanks in advance
w