Thu, 24 Sep 2026
Login

Form Grid load and save data

Confluence User - 11 Aug, 2020

I have a Form 'person' that have fields :name ,age and fk_processId to link the persons in this form table to the main request.

Grid:

so I load the data using bean shell from this from and insert the records into the form grid(person) and the user can update this grid values so I store records using multirecord binder


But if I use multirecord binder the grid will not saved in the main form when submitted

So how can I store using Multirecord binder and store the in main form field

Or how can I load records from table and save updates and save form grid json

Or for the first time load from Person table and second read person_grid Json value


forms;beanshell;datalists;database

2

Confluence User •
13 Aug, 2020 •
confluenceUser •
•
confluenceUser •

Hi, if you are using the Multirow Form Binder then the data will be stored in a separate table, which is the expected behavior. I am afraid your question is not clear and I have difficulty understanding what you are trying to achieve.

Confluence User •
13 Aug, 2020 •
confluenceUser •
•
confluenceUser •

1-I am retrieving data using the JSON tool and insert into Form Table A.

2-Load this data into a grid using BeanShell or Multirow Form Binder.

3-User can update the data in this grid so I must save these changes. There are 2 options to save:

 a- Use Multirow Form binder so the grid will not be saved as JSON in the Form containing it (Form B). Usually saved as JSON and I need this JSON later.

b- Don't use any storing method (BeanShell, multirow, JDBC) and this will use the default save (JSON in Form Table that contains the grid B) but when the grid will be loaded again it will not contain the updated data since I am loading from Form Table A

so what I need is to load grid, save updates and get grid JSON later.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
How can I set dedicated datasource for each app ?
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Plugin for PDF Editor
Retrieve image upload from form into PDF
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print