Mixing Data Sources

Ask the community
1

This is probably a daft question, but..

I have all of my data in Airtable currently. There are some things that Softr Databases don’t do yet (such as CSV import/export as well as Airtable) and some integrations from Airtable I need.

But one bit of data I need to store is not allowed on US servers and I don’t fancy paying for Airtable’s Enterprise plan just to get EU hosting.

So could I create a table in Softr databases to hold just the bit of data I want on EU servers and then create a linked record to read between Airtable and Softr - or if that’s not possible, do it in Softr somehow with a conditional view?

2

Hi, you can absolutely do that. If the data stored in your Softr database needs to be related to data coming from Airtable, you can apply conditional filters to the block displaying the Softr app data. This requires that, in addition to storing that specific piece of information, you assign a unique identifier to it, such as email, ID, or name, that exactly matches a unique identifier in Airtable. You can then use these identifiers to display the correct corresponding records. Please also check this article for more details on how to set up conditional filters on blocks.

1 Like