I am using CrossDoc action AddRow()
to create a row in a table. I am sending an row value back to the table lookup column, which is what a lookup column would expect. But instead of the receiving table getting the lookup value, it is getting a text value.
For example I have a column [Unit]. This has kg, L, cm, ea as values. I use the CrossDoc AddRow()
to send (ea) (parens meaning a the Unit row value) but instead text arrives. This makes things break because the referencing formulas don’t work. Here’s a gif of the text in the lookup column, and then I ‘re-choose’ manually the row ‘ea’ and it works: