I have a problem with a project i am carrying out.
I have a table A. with a X record which is linked to a field Y in table B and field Z in table C.
After I have a table D. This records are linked to a field in table A.
So , records in table D , are linked indirectly to table B and C.
Now i have a table E, which is an input record to control hours.
When I add a record with a field linked to table D, I can add a field with a lookup function, to show the linked field in table A.
My problem is that i need to fill automatically as well, fields Y and Z which are linked to field in table A.
Some idea how to perform this task?
Many thanks in advance
You can do that by getting the Record Id from Table B & C to Table A, then using those record IDs trigger an automation to update those records based on data from Table E
Many thanks for your help, but i can´t do it work with your approach.
I am going to be more explicit in order to receive your help.
I select from . a linked field, lets say HU-3/PRD43-1
Automatically with a lookup i get  and  and 
This field . needs to be “copied” in another linked field i  in the same record
Thats the point… i am trying what you say
but , im stucked.
If you can give me a solution, I will be very grateful
This is very easy actually
You just need to input the correct values in the above fields.
Record ID is the Record ID from the test step and the field you need to update “Prefil comprador” should have a dynamic value of “Pais name”
I made a mistake
 is pais
but then i try this
and then I input  that automatically puts 
but not 
it is still empty…
automation is not working, and i dont know why
The trigger is incorrect. It should be “When Record Matches Condition” and the condition should be 1 is not empty and 5 is empty
The only problem is that changes in . as it is a linked record from other table, is not reflecting in 
it is like  is static after the automation.
You mean that 5 can change? In this case we need to think of another trigger. Maybe when a field is modified and make it watch 1?
It not very usual, so i am going to remain with your solution.
Please mark is as Solution
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.