Access a subform field in a spreadsheet element

Confluence User - 14 May, 2025

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

spreadsheet;subform;multirow_form_binder

4


15 May, 2025
confluenceUser
confluenceUser

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.

15 May, 2025
confluenceUser
confluenceUser

Hi Chiek, just to clarify you want guidance on how to populate data in spreadsheet using multi row form binder? 

16 May, 2025
confluenceUser
confluenceUser

Yes, when the form utilised has a subform. If there is no subform the multi row form binder works well.  

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print