I’m building an inventory database with an associated request form. I have two separate tables - one for full inventory and one for the request. In the request table, I’ve allowed people to link records from the Inventory to a requestor record. What I want to happen is that when an item is added to that requestor record, I want the associated item in the Inventory table to update its status to “Checked Out”.
Can anyone help me logic this one out?
Thank you!
Page 1 / 1
Hi @MadzOB could you please explain a little bit more? You mention 2 tables but then you mentioned a requestor, is that another table? In any case you can do that with an automation. Trigger then a record matches condition being the condition that the item link in the requestor table is not empty (assuming there is one item per requestor)
Then you update the record that belongs to that item with the update record module.
Happy to jump on a quick call to help you out if needed, just book a time HERE
Hi @MadzOB could you please explain a little bit more? You mention 2 tables but then you mentioned a requestor, is that another table? In any case you can do that with an automation. Trigger then a record matches condition being the condition that the item link in the requestor table is not empty (assuming there is one item per requestor)
Then you update the record that belongs to that item with the update record module.
Happy to jump on a quick call to help you out if needed, just book a time HERE
I worked out the first set of automations, so the workflow is now the following:
Requestor submits form and new record is created in Request Table
There are linked records in this record that refer to an Inventory Table. So Requestor selects “White T-Shirt” in their request to check-out. There will be multiple items associated to a particular request.
Automation runs and auto-changes the status of that record to “New”
What I now want to happen is: when the request record is approved, I want an admin to change the status to “Approved”. Then I want to figure out an automation that finds all the item records that were linked in that particular request and change their status in the Inventory Table to “Checked Out”.
Please let me know if that makes sense!
Try creating an automation that triggers when the Status is ‘Approved’, and in it add a Repeating Group that’ll update each of the linked item’s statuses to ‘Checked Out’?
And this is how the automation looks and I’ve set it up here for you to check out
Ok well then the trigger would be,
When a record matches a condition, condition being Approved,
You set up a repeating grout, being the record in the repeating group the ones that are the linked items.
Then you update all records that are related to that approved Request and update then.
It should be something like this.
But keep it mind it would only work if there is only one request per item. If an item is has two requests. it would update even tough the other request is nor approved
Try creating an automation that triggers when the Status is ‘Approved’, and in it add a Repeating Group that’ll update each of the linked item’s statuses to ‘Checked Out’?
That’s what I concluded with further testing! I’m working on trying to find the records first before using a repeated action. I’ll see if the repeating group works. Thank you!
Try creating an automation that triggers when the Status is ‘Approved’, and in it add a Repeating Group that’ll update each of the linked item’s statuses to ‘Checked Out’?
That’s what I concluded with further testing! I’m working on trying to find the records first before using a repeated action. I’ll see if the repeating group works. Thank you!
You don’t need to find the records, as they are already found within the linked field, you just need to set up the repeating group and use that field as input.
Try creating an automation that triggers when the Status is ‘Approved’, and in it add a Repeating Group that’ll update each of the linked item’s statuses to ‘Checked Out’?
That’s what I concluded with further testing! I’m working on trying to find the records first before using a repeated action. I’ll see if the repeating group works. Thank you!
You don’t need to find the records, as they are already found within the linked field, you just need to set up the repeating group and use that field as input.
Copy that! And this will work with multiple linked items as well?
Try creating an automation that triggers when the Status is ‘Approved’, and in it add a Repeating Group that’ll update each of the linked item’s statuses to ‘Checked Out’?
That’s what I concluded with further testing! I’m working on trying to find the records first before using a repeated action. I’ll see if the repeating group works. Thank you!
You don’t need to find the records, as they are already found within the linked field, you just need to set up the repeating group and use that field as input.
Copy that! And this will work with multiple linked items as well?
Yes, as you are applying a repeating group. See the screenshot above.