LinktoForm

AppSheet AppSheet Q&A
1

Hi

Using LinkToForm is it possible to replicate data and add a character to one of the columns results.

With the following Example:

LinkToForm(“FormName”,“Ref”,[JobID],“JobID”,[JobID])

Where the JobID is returned to the new form add a character to the result.

So if the JobID is 12345 I would want the returned result be 123450 which you can see the additional 0 has been added.

Could the above LinkToForm expression be edited to do this?

Cheers

2

LinkToForm(“FormName”, “Ref”, [JobID], “JobID”, [JobID] & “0”)

If you are editing an existing row, you can’t change the value of its key, so “JobID” cannot be the key column.

2 Likes