Syncing users with a data source
Sync your user database with a data source.
You can manage your users entirely in Softr or sync users with an external data source. By connecting to a data source, you get to use additional custom fields to create User Groups and application logic (e.g. List Conditional Filters).
2-way sync availability per source
Source | Availability |
Airtable | ✅ |
Google Sheets | ✅ |
SmartSuite | ✅ |
SQL sources | ✅ |
monday.com | ✅ |
HubSpot | Coming soon.
For now, upon connecting Users to HubSpot, only user fields of email-matching users coming from HubSpot are synced (not users). This way you can already use HubSpot fields to create user groups and application logic. |
BigQuery | N/A |
Setup
To start the setup, you need to hit the Connect to data source button as shown below.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F50a112cc-0148-41a7-a7f6-b7fb50f24ff5%2Fconnect-data-source.png?table=block&id=b16d7e4d-24ae-41e1-b20b-0f715c554db5&cache=v2)
Next, you need to select the data source you want to map to.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F3b3a859d-7c31-4d92-92a7-4d53c69d0eac%2Fselecting-data-source.png?table=block&id=8ca4b1d3-5362-42fc-82fc-d33679c0ce25&cache=v2)
![Mapping data source](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F9999acba-394a-4b12-84f9-a1457df75261%2FUntitled.png?table=block&id=60998c40-acad-4746-8aec-750675ff52a1&cache=v2)
In the next step, you need to map Softr user fields to fields in your data source:
![Notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fae8197f2-b57f-4949-a512-b12a2a4a0f32%2FUntitled.png?table=block&id=48cee854-ff60-42ef-8433-6b4f0eda96ce&cache=v2)
- Email * — this is the unique user identifier and how we are able to connect user records. Please do not edit email from the source.
- Name (optional)
- Magic link (optional)
- Avatar (optional) — instructions on setting up avatar can be found here
- Created date (optional) the date when the user was created
- Last seen date (optional) — the date when the user last used the application.
After mapping all the fields you want, hit Save – now the syncing will start!
How does 2-way syncing work?
- Adding user: Any user created via Softr will get added to your connected source, and vice versa.
- Deleting user: Any user deleted via Softr will also get deleted from the source. However, deleting a user from source will not delete user in Softr, and the user will be added back in the next sync (we do this to prevent unrecoverable mistakes).
- Changing user data: Fields such as
Last seen date
andMagic link
only make sense to be managed via Softr. If you edit the value from the source, it will be overridden on the next sync.
Email
from the source. Softr will not be able to identify that user. When does syncing happen?
If your app’s user table syncs with Airtable or SmartSuite, any new user added to your source table will get synced to Softr immediately.
We’ve also defined many syncing triggers inside of Softr to ensure your app always gets the latest user data when it actually needs it. A few examples:
- When a user logs into an app.
- When you publish new app changes.
- When you visit the User tab.
etc…
If you run into any cases where the data isn’t getting synced, and it’s affecting how your app works, please let us know!
Syncing issues
If there’s an issue with syncing with a data source (e.g. you have a duplicate user in your data source), you’ll be notified about that as shown below.
![Sync issue notification](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F69c9980c-c81a-4c6c-8fac-a628fd1cb39c%2Fsync-issue.png?table=block&id=2d5fccd6-2a07-4dfc-9464-21c368a0fd0a&cache=v2)
Click on See details to learn more and address the issues. After successfully fixing the issue, hit Validate fix to trigger a sync.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fd1beb4d2-835d-4da5-bfb0-dd2162e5892a%2FUntitled.png?table=block&id=a96e516e-68c5-4808-a40c-632711955f60&cache=v2)
Enabling 2-way sync on older apps
User syncing between Softr and data source used to be 1-way (from application to data source only). If you have an app created before the introduction of 2-way sync in June, 2023, you’ll have to manually enable 2-way sync by going to the Users tab.
![Enabling 2-way sync](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F57ad2c87-1e86-49e9-94cf-888b06789c89%2FSCR-20230620-mda.png?table=block&id=20088cf0-1988-4416-9ce2-0e125d7bb684&cache=v2)
Last updated on July 15, 2024