Hi!
I have created a form and placed one block using Google Sheets as the source and another block using Softr Database and Table. The use case is that I want to capture photos related to the item I have in Google Sheets (Sheets does not hold files).
Can I pass a variable from Google Sheets to Softr Table which I can use to write to a field in the Softr table?
I am not an expert at this (read novice), but I feel that workflow may be the key (if there is any), but thought I would ask her first.
Thanks in advance!
Michael
Hi @MichaelV,
Thank you for the details. Could you please clarify how you’re storing the files?
If you are storing the file URLs in a field in Google Sheets and using an Item Details block to display the record details from Google Sheets, you can capture those file URLs through hidden fields in a form placed on the same page.
In this setup, the image or file URLs are saved in Google Sheets.
An Item Details block displays the details of a specific record from Google Sheets, and users are redirected to this page after clicking on an item or button in a List block.
You can then place a Form block on that same page and connect it to Softr Database. The form can include hidden fields that capture the details page record’s parameters, including the file URLs, during submission.
In this context, “Details page record" refers to the record being displayed by the Item Details block at that specific time.
Please review the attached screenshots and articles for more details on how to configure this setup, and let me know if anything is unclear.
https://docs.softr.io/building-blocks/list-block#list-block
https://docs.softr.io/building-blocks/item-details-block-#item-details-block
