Hi all, I’m building a table to track items availability (musical instruments) for students to sign out and borrow for a limited time.
My base has two tables, one with the instrument catalogue (containing general information on the instrument, brand, etc. Also has a field of whether the instrument is in stock or unavailable). The second table is the home to the form for instrument request, these requests come in as a name, instrument requested, and date needed. The email autopopulates from a student directory and the return date autopopulates with the dateadd formula.
I already automated emails to the students based on these dates and it works fine. What I am not able to do is to automate a change in status of the instrument. I would like for the “Status” field in Table 1 to change to “unavailable” when the next sign out date is “tomorrow” (as automation allows you to set) in table 2.
The problem I’m having is when I’m setting up the configuration for the “update record” step, it asks for a Record ID. The idea is I don’t want to update a specific record, but essentially any record in the field depending on which linked item is being requested in Table 2. Additionally, when I open up the dropdown items for Record ID, it shows fields from Table 2, in essence, not recognizing that I want to update Table 1 even when I selected Table 1 as the table I want updated.
I’d be happy to send screenshots or upload my base for viewing, just not sur ehow to do that on here.
Thanks for all your help! You’ve all been amazing so far on getting me out of the Airtable noob territory!