Help

Automation - add to inventory

Solved
Jump to Solution
4636 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Waldemar
5 - Automation Enthusiast
5 - Automation Enthusiast

I have two tables I want to update when adding a new product

Table A - Inventory 
Table B - Received ( Products received )
Table C - New Item Table : Junction Table 

I have created a junction table so I can multiple "New" products quickly and that do not exist in Inventory.

So in the automation I am doing the following 
1. Trigger - If Done Checkbox is True
1. Create new record : Inventory - Add all parts of information needed here.
2. Copy New Inventory ID ( Run Script)- Paste onto : New Item Table : Field : Inventory ID ( Because of permissions I create an extra field also - New ID) - Took a while but working 
3. Create new record : Received Table : Add quanity received / cost etc.. 

I tried to directly update Inventory ID field ( Linked relationship Field ) Linking Inventory & Received Tables - However worked only 50% of time then stopped altogether : Feel it was a time lag in the software 

So I created a new second Automation - Update Record 
1. Trigger - When a record is created 
2. Update : Inventory ID field : from New ID Field 

Not working : The number in results has a line through it 

This Automation makes no sense to me as been working then not working then working sometimes - I am the creator of this base and added Automations as Creator access so no idea why not working. Does anyone know how to Fix? 
I can copy paste into the Inventory ID Field So do not understand the issue every other field is working 
I have been trying to resolve for a day and a half as I will need to create similar automation for consignments etc..

Any help 



10 Replies 10

Any idea on this issue https://community.airtable.com/t5/automations/dynamic-field-in-automations/td-p/193951

Trying to automate tasks for each stage of my process