script + automation to async linked fields when a record is created
I have a Purchase Order table and an Expenses table that when records are created and automation pulls the records into the Budgets MASTER LIST using roll up and look up fields. Each Budget is allocated to a department (Autism Liaison, Events, IT & Comms etc etc ) so the Primary field for Budgets MASTER LIST is a forumula using IF to pull in the lookup Budget ID from each entry so I can group the entries by Budget ID. (hope this makes sense so far).
I also have another table that lists all Budget Categories (called Annual Budgets) that contains the annual budget amount and on this table I need to show running balance - remaining budget etc etc (don't worry about that I have already set that up), BUT it relys on having the linked field in the Budgets MASTER LIST to do this.
So, all I need is each time a new record is created in Budgets MASTER LIST, rather than me having to manually select the linked field 'Annual Budets' and select the budget related to it, is there any way I can say that if the primary field in Budget MASTER LIST says 'Autism Liaison' - can I sync it to automatically select/sync it to the linked record 'Autsim Liaison' and populate the field? So 'Events' in the Budget ID would select the 'Events' in the linked field etc etc.
