Our fields are grouped by Order Number (reflecting the same project) The drop down menu has the status of materials. I’m looking for a way to mark (a new field) when all items matching the order number read Received. (In the example, I threw in the cancel status - because the real world never runs so smooth)
The end result I’m looking to accomplish is once statuses are marked Received the “new field” generates a reminder to send a form. (Hoping to accomplish this with zapier and jotform) Which leads me to believe another field is required to push this process to zapier?
Thank you in advance.
If everything is in on one table, then the Airtable cells really only know about the data in the rest of their row. You might be better off extracting Orders/Projects to their own table, so that you have both granular control over materials, as well as high-level controls over Orders. Then you can link those tables together so information is shared automatically (such as which orders have entirely received materials). See example below.
Name (single line text)
Project (linked record)
Status single select
Order Number (single line text)
Materials (linked record)
material1, material2, material3
Materials Status (lookup)
Order Status (formula)
Not entirely received
This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.