1
0
-1

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

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1
      1. 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.

      2. Varnaa

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

      3. Chiek

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

      CommentAdd your comment...