You’re offline. This is a read only version of the page.
Announcements
Hey there
I have a form, i would like to add content to an Excel sheet with information from the responses and in a special column i would like to add a value from another Excel sheet with a cell that creates random isbn fx=UNIQUE(RANDBETWEEN(9788723527370120, 9788723527370990)))
What is the best way to do it?
Hi @Ohayonson
Couple of questions:
1. You mentioned add a value from another Excel sheet with a cell that creates random isbn. Do you have more than one isbn values in this excel sheet. If you have multiple rows and going to match then you need to use the filter query for the list rows. Store the isbn in a variable.
2. Once you have the isbn then in your second excel sheet for adding the rows you need the Add rows action step where you can map your forms response values and the isbn variable.
Thanks
Share
Report
All responses (
Answers (
32,865
