I know this setup isn’t ideal and that I might just have to change how a contractor set up Zapier to pull the data, but I’m wondering if this is possible to do just in Airtable itself. Then create a formula field in the table consisting of the URL minus the record ID on the end. Is it possible to set up an automation that would link records only if the User ID and Course Names both match across the two tables? So an automation that links records just through the Name or User ID fields wouldn’t necessarily work. The problem is that each person might register for and complete multiple courses and would have multiple records in each table. See also Airtable's guide to basic field types. Enter values in the fields you want to update. Alternatively, you can use the Search button to select the Record ID. You can retrieve the ID, for example, using the Search Records or Watch Records module. Creating a manual link each time someone completes a course is possible but would take up a lot of time. Enter (map) the Record ID you want to update. I’m trying to set up an automation that would add link records in the two tables, so that I can see which people who registered for a course actually completed it (by adding a Lookup field in Table 1 that would pull in the “Completion Status” field from Table 2). Table 1 shows a list of registrants for an online class (User ID, Name, Email, Course Name fields), and Table 2 shows a list of users who completed a class (User ID, Name, Email, Course Name, Completion Status fields). Hi! I have two tables with data that’s pulled from another site through Zapier.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |