Sync and Update user groups via the connected airtable data source

Ask the community
1

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 ?

2

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!

3

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!

Screenshot 2024-08-05 at 18.07.23
Screenshot 2024-08-05 at 18.07.232240×672 115 KB

4

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

5

Thank you!

6

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

7

@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
8

@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?

9

@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.

10

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

11

I experienced this recently

12

@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…