![]() That second requirement– immutability–is as important as the first. But you probably–almost certainly–don’t have to, even if you think you do, so don’t.Ī key value in a relational database should always be If you absolutely have to, then you have to. I strongly urge you not to use email addresses as key values. Make sure when you export Projects (sticking with example above) you export the Record_ID column and when you export Tasks, be sure to export both Record_ID and Project_Record_ID. When you save that, you’ll see that every row in the Tasks table has a distinct value in the table’s own Record_ID column, but if you filter the tasks on a single project, you’ll see they all have the same value in Project_Record_ID:įinally, if you need to take your data outside Airtable, into another relational database management system (like, say, FileMaker or AppSheet), just export each table to CSV. This should be a lookup column that gets the value of the Record_ID column over in the Projects table. Finally, go back to Tasks and create a new column that could be called “Project_Record_ID”. ![]() Go over to Projects and do the very same thing: Create a formula-type field named Record_ID using the RECORD_ID() formula.Be sure to leave the space between the parentheses blank. Make it a formula field and use the formula I mentioned above: RECORD_ID(). In Tasks, create a field/column named Record_ID.Relationship between them is one-to-many (one Project can have many tasks, but a task can be linked to only one project). So, say you have two tables: Projects and Tasks. So all you need to do is reveal them, using the function I mentioned above. Remember, under the hood in Airtable, the key values are there. How to get and use Airtable’s hidden key values in related tablesīut sometimes, some of us do need to see those values, because we need to take our relational data outside of Airtable and for that, we need those primary and foreign key values, so we can relate records properly in another system. ![]() Of course the key values are there but you don’t have to see them. In Airtable, if you want to link line items for the Acme account to the Acme record in the Accounts table, you just click on the linked record field in the LineItems table and select “Acme”. Now one of Airtable’s special features is that it makes it unnecessary for users to worry about primary and foreign keys. ![]() If you would like different type of unique value, let me know and I can suggest other formulas that should do the trick but will require a little more work. Try using the RECORD_ID() function as the formula for a Formula field. If you’re just trying to come up with a unique ID value for every record in a table, that’s not too hard. But if I’m understanding you correctly, this ought to do the trick for you. I think I understand what you’re trying to do, but I’m not sure. Thanks in advance for any suggestion on how to use the Welcome to the Airtable community. so I can link a form with the adapted crm and then generate an invoice on each new registered client.
0 Comments
Leave a Reply. |