Question & Answer > View Question

How to populate multiple records in spreadsheet from previous form

Confluence User - 28 Apr, 2022

Hi all,

My requirement is below.

Select one or more than one record from Manage Form → Selected records should populate into spreadsheet of Other form which is linked/opened by pressing a button in Manage Form.

Manage Form:

Upon pressing above button , an another form will be opened and based on above selection , records should be populated into called FORM spreadsheet.

Can anyone share the workaround?

Thanks.

insert;populate;multiple;records

1

Confluence User •

30 Apr, 2022 •

confluenceUser •

•

confluenceUser •

Hello,

For your custom use case, first you can partially follow this guide to configure a Hyperlink Datalist Action to grab the selected rows, by passing the record ID(s) in hyperlink parameters: Prepopulating Select Box With Multiple Row Selection in Datalist

Then in your form, you can refer to the selected record ID(s) via the Request Param Hash Variable, like → #requestParam.yourParameterNameHere#

Then in your spreadsheet, change the grid's load binder to Bean Shell Load Binder, then follow this bean shell guide and modify accordingly to load the selected row(s) and populate the spreadsheet.
Bean Shell Programming Guide#UseasFormMultiRowLoadBinder

1

CSV | Excel | XML | PDF

Your answer

Print

How to populate multiple records in spreadsheet from previous form

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-49599afc-920b-4227-9756-c8b1320d2030{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-3561eb5d-e58b-4b71-877c-27efc87c0c58{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer