Sync and Update user groups via the connected airtable data source

I have 2 tables for keeping users data:

  1. User groups - the log in information including their magic link
  2. User Profile - additional data user fill in their profile.

I’m trying to understand how to connect between a logged in user profile and another table that holds all the information the user update on his profile (other data related to his public profile)

are there unique identifier beyond email that can be used to connect the records ?

I created a lookup field in airtable that allow to connect between the 2, so when a user log into his profile , he can see all that personal info, but i’m not sure how to automatically connect the two (does this require Make or could be somehow done via the airtable automation

Is it possible to sync user groups into the Airtable database and managed the logic through thre or user groups logic must be managed through the softr dashboard ?

Hi @Lior

Is there a reason why you didn’t create a field on the user table for the user groups (multi-select)? That’s how this is normally handled to simplify things.

Let me know when you get a chance!

Hi @Jjenglert, jumping in here - how do you add a field in the user table? I can’t see any way to do so. Is this only available on certain plans?
Here is a screenshot of what I see, there is no “plus mark” or button to add a field.

Thanks in advance!

Hi! You cannot do this in Softr. You need to do this in your connected airtable.

Thank you!

how do I sync the softr user group field with the airtable field?

@Mygrate do you mean the manual user group name that you created in Softr ?

If you need that perhaps you can do other way around set the roles/groups in AT ad Single/Multiselect field and then define dynamic user group based on that field

1 Like

@artur At the moment the user group is updated by Stripe (free or premium plan). However, when the user group changes in Softr after an upgrade, it does not sync with AT.
Is there a way to make it happen?

@artur and @Mygrate, I also am in need of this solution. I need to run an automation when Stripe changes the user group, so syncing the User Groups value changes in Softr with my “User Groups” field in Airtable would be paramount.

Please @artur how often or at what frequency does softr update its user group from airtable, cos I have encountered multiple occasions where I make changes to airtable and trigger a refresh (hoping the user group would change ) but unfortunately is doesn’t. I think it would be nice for softr to provide a means to trigger data resync and consequently, user-group update

I experienced this recently

@L360 we do have a cache for about 2 mins this helps a lot with performance… if you want you can disable user cache from the app settings but that will slow down a bit…

@JoshuaSchellenberger @Mygrate Update: I think this has been solved since the update with the condition based user groups right?

  1. Now you can set the user group in Airtable with an automation (Stripe e.g.).
  2. Then in Softr make a user group based on a condition and within this condition make a reference to the user group in Airtable.
  3. Publish and it syncs immediately. :+1:

@artur, then does disabling Softr’s cache setting mean Softr’s User Table updates in real time with Airtable users (i.e. real time sync)? My understanding is that Softr’s user table only updates when a builder goes to the user’s table in the Softr studio, the sync setting in Softr’s user table is triggered, or a Softr app is published (ex. the ‘publish’ button is triggered). Other than that, at what intervals is the Softr User table updated to correspond with users in Airtable?

@Ben there are few scenarios…

  • Individual user using an app - in this case this particular user’s changes in airtable (assuming it got changed in Airtable directly) will be applied in 3-10 seconds.
  • Sync the entire user set - this is happening when one is in the users tab in studio or in automatically in certain intervals like up to 30 mins based on system load. This one is subject to change/improve in coming weeks

As of today 2 mins user cache is a bit of legacy and plays less role… I think in 1-2 months we will remove that flag.