How to set value for linked record column into Table Record

Support, Troubleshooting, & Help
,
1

I have Tools table. Every tool have ToolTypeId (which is in code list table (eg. ToolTypes) with different tool types). I created ToolTypeId colimn in Tools table which is linked record to ID from ToolTypes table with many to one link type.

When I create new record in Tools table I also want to fill ToolTypeId column. I have ID from ToolTypes stored in variable.

Apart from every other column I can not set value of ToolTypeId in table record of Tools table. I know how to save record in table. Iā€™m only stuck at saving linked record column with variable from ToolTypes table.

Please if someone can help me with this situation.
Ermin

2

hello @ermingut, great question!!

are you familiar with the Table Records > Link Record Trigger Action?? this will allow you to create a Link between the Tools and ToolType Tables:

Screen Shot 9
Screen Shot 93104Ɨ1910 362 KB

let me know if I understood the question correctly!!

3

I will give your proposed solution a try and let you know.

Thanks.

1 Like