I’m building a simple auction site with only six items using Softr and Airtable. In Airtable, I have two tables: “Items” and “Bids”, these two tables are mutually linked.
I’ve already set up a button that opens a form to create a new bid record in the “Bids” table, and the record is created successfully. However, I’m struggling with getting the form submission to map to the correct item. Since I have a limited number of items but potentially many bids, I need each bid to link to the relevant item.
Is there a way in Softr to automatically link each new bid to the correct item in Airtable after the form is submitted?
I assume I should be able to pass the specific item information, likely the record ID, to the form page, but I can’t seem to find a way to do this.
I’ve managed to pass the recordId of an item from my homepage (which lists items from the Airtable “Items” table) to the bid form page/modal (linked to the “Bids” table).
I did this by creating a button that generates a URL with the recordId as a query parameter (e.g., https://xxxxx.softr.app/bid?recordId=recxxxxxxxx), concatenated in an Airtable column.
On the bid form page, I set up a hidden field to capture the recordId from the URL parameter. The form submits fine, and the bid record is created, but the problem is that the “Items” field in the “Bids” table isn’t being populated—so the bid isn’t linked to the correct item. Or to any item at all.
Anyone know how to properly map the recordId to the “Items” field on form submission?
Thank you so much! I realized I made a mistake—I was testing the form in testing mode, which is why it couldn’t pull the URL query parameter correctly to fill the field on Airtable.
While I won’t be using your solution this time, I think it could be really helpful for other Softr users.
