Hi there, I’m hoping this is an easy one but I’m struggling to find the answer anywhere #noob
I have linked my Softr app and Airtable. The Airtable has two tables, Users & Data.
Each user has several linked Data records. Each Data record has 1 associated user.
When that user logs in to the Softr app, they should be able to see the data linked to their UserID.
The user should be able to use Soft to input new data… I want to use a Hidden field in the Softr form to update the Airtable Data record with their UserID (so that when they view their data list, it’s all there for them). It feels simple only I can’t seem to get it to work.
I’ve troubleshooted with other field types, so I can use the form to update an ‘email’ field on the Data table but then the Home screen in the Softr app doesn’t display the correct Data…
Please help 
Welcome!
Softr.io forms can create new records but they can’t update existing records.
Extra steps or alternative forms are required to update existing records.
To update an existing record, why not use a list block or a list details block and an action button?
1 Like
Thanks, I am looking to create a new record in Data.
On form submission, a new record should be created in the Data table with the UserID from the hidden field. That UserID in the Data table is a linked record to the User table and does not seem to be sending anything to it… (the new record is created but the UserID field is blank)
Got you … okay …
Is the UserID the same value as Airtable’s RecordID for your user(s)?
Yes…
I tested it by: Creating a new text field in the Data table and a new Hidden field that sends the UserID to the text field and it sent the correct value (the UserID and the number in the new text field matched)
I need it to link the items in the Data table to the User table so that only Users with that Data can see those items in the list - but it doesn’t seem to like it being a linked field?
Great … good approach to test with a different field type … I’m puzzled why it doesn’t work for you when you set the hidden field to a linked field …
I set up a test scenario to double-check that it should/does work as I would expect … it does! Please see the screen shots to check against for your tables/form.
Set the hidden field to Logged-in user, then select Record ID
I successfully added Item 2 using the Softr.io form when logged-in as User ‘Person’
(Ignore that the email field and Magic Link are blank, I redacted that data)
