Part II : Build the foundation in Softr.io It will help you build your own secure Airtable database. Here is the link to the demo Airtable base : In addition, if you make some change in the table “Private User Database”, thanks to the look-up all updates would be handled automatically by Airtable in the “Public User Database”.Consequently, when a new record is created in your private table, a new record is created in the public table. ![]() The following action, based on this condition set up previously, would create a new record in Public User Database.The condition has to be triggered from the “Private User Database”. There, you have to define a trigger, regarding our case we have to use the following trigger : “When record created”.In order to do this, go to the Automation section. First, you need to create an automation within Airtable.Step 4: Add automatically a new line in the private user database and duplicate it to the public table ? Therefore, just select the database and then select the table with non-sensitive user data in this case “Public User Database” and set up all the fields required. Once done, you can add a block “list” to your application. In this example, we will make lookups on the “Last Name” and “First Name” fields, which are considered as non-sensitive data.We are going to look-up information from our database table ”Private User Database” to the new table “Public User Database”. Create a first lookup based on the “Link to another record” field created before.Create a “Link to another record” field.Delete all the columns created by default by Airtable.We will call this table “Public User Database”. Create a second table in the same user database.This table will be connected to Softr.io, as there is no sensitive data, this is why we are calling it “Public User Database” and creating a “Link to another record” field. To continue, building a second table is required before creating the Softr.io application. Step 2: Build the table “Public User Database” “Address”, Field Used: Single line text.“First name”, Field Used: Single line text.“Last Name”, Field Used: Single line text. ![]() Let’s start by adding some user information.Transform the first column from the field “single line text” to an “Autonumber” field.Delete all the columns created by default by Airtable.Inside of this database create a private user database table called “Private User Database”. ![]() This table will never be directly linked to Softr.io.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |