Spreadsheet information not appear

Confluence User - 20 Nov, 2024

Based on the form:

forms

4


20 Nov, 2024
confluenceUser
confluenceUser

Hi Natasha, Could you please verify the data store configuration? Specifically, please check if you have properly configured:

  1. The source location from where data should be loaded into the spreadsheet
  2. The destination location where the data should be saved

You can refer Expense Claim from Marketplace which demonstrates the use of spreadsheet and try to replicate the same for your use case. Hope this helps. Feel free to share additional information


20 Nov, 2024
confluenceUser
confluenceUser

Thank you for your response. Is this the data store configuration that I need to verify? Load data the data from?

20 Nov, 2024
confluenceUser
confluenceUser

Yes, you will need to configure this based on your use case. If left empty, the spreadsheet data is stored as a JSON string in the parent form's database table. If a child form is selected, the data is stored as individual records in the child form with the parent form ID as foreign key.

For more specific guidance, please share what you're trying to achieve. 

I suggest you to import the expense claim app into your Joget and refer the configuration. 

Additionally you can also refer these:
1. Spreadsheet

2. Spreadsheet Cascading Drop-Down List

3. Form Grid
4. Load and Store Binder MultipleFormRow

29 Nov, 2024
confluenceUser
confluenceUser

Spreadsheet in the multi form page (Other Relevant Information) still not appear in the Report page.


Multi form page:

Report page:

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print