LINKTOFORM and copying data into "initial value" fields

[Marvin-JR]

I am attempting to make a very simple copy of a row. Some of the data in that row has initial values. I'd like to copy the existing values and not generate new values, specifically for UNIQUEID("PackedUUID"). If I try to have a cell copied with initial data, one of two things happens.

• For plain text, the copy is simply not done and the initial value is inserted.
• For formula data, as soon as I initiate the action the app crashes.

Please help me understand how to work through this.

Here is the setup that works (almost. for some reason [TRACKING] will not copy.)

LINKTOFORM("Add to existing shipment",[CLIENT],[COMPANY],[STATUS],[TRACKING])

 This is the table I'm working in.

The columns that have initial values are:

• client
• company
• date notified
• notified by
• status
• unique id
• order id

Thank you!

[TeeSee1]

https://support.google.com/appsheet/answer/10106538?hl=en

Would this work to change [client] -> "client" and [status] -> "status"?

The app does not check for any errors and having [] notations in these places seems wrong.. (Appsheet sometimes make guesses in the background and may be OK here.)

[Marvin-JR]

I think you know the answer, but I know so little about this that I didn't catch on. The answer that @peterson gave next got things working for me. Thank you for your help.

[peterson]

Anytime.

[peterson · Accepted solution]

Hello my friend, when you work with linktoform always have in mind that the first column will not be represented by [], you'll have to use double quotes instead " " for example

LINKTOFORM("Add to existing shipment","CLIENT",[COMPANY],"STATUS",[TRACKING])

[Marvin-JR]

While I do not understand why this works, it does. All of my difficulties are resolved. Thank you so much!