Log which user changed a status in Softr/Airtable

Ask the community
1

Hi everybody.

We’re using the old comments block that sends the note to a NOTES table in Airtable. If a logged in user adds a note, we get their name into Airtable - no problems here.

But we have a lot of situations where we want to know who changed a status. I have an automation in AIrtable that creates a note everytime a status change is made, but it can not get the user. We just have to log it as a default System user.

Is there any way to pass the logged in User-ID from SOftr to AIrtable when updates like this are made?

2

Hey! How does one user change the status in AT that you want to track who was the author?

3

Hey @acjnas - sorry, should have been clearer.

Tthe status is changed in Softr by my staff/users which updates the Order status in my ORDERS table in Airtable.

4

If the status change you want to track is made through a Softr form, you can add a hidden field to the form that automatically logs the currently logged-in user performing the update.

To make this work:

  1. Create a new Linked Record field in your Airtable table. (pointing to your user’s table)

  2. Map this field to the hidden field in your Softr form.

Then, whenever an update is submitted, you’ll be able to check the Airtable record’s revision history to see who made each status change

5

Thanks @acjnas, but the status change is just made through an Edit Record action in Softr, not via a form. I presume no way to pass the currently logged-in user in such a scenario?

6

Hey @bopper

Both the Edit Record button in Softr (that opens a modal to change data) and the One-Click Update button support hidden fields.

I think you should be able to log the user who made the change with the approch that acjnas suggested.

7

Actually got the idea, and then @stocki confirmed it below. Thanks very much - this has been a huge pain in the butt.

8

Thanks very much, that works a charm and so easy to implement once I knew what I was doing. ppreciate you chipping in.

1 Like