LINKTOROW & LINKTOFORM combined functionality

[Marc_Dillon]

I’d like to be able to forward the user to an edit form for a particular record (LINKTOROW), and also with some fields prefilled (LINKTOFORM)

Basically the same request as this post, but in a more general sense.

Upsert (Update when exists, Insert when new) Feature Requests

When I look up a key (in this case, a scanned barcode), it may be that the record already exists. It would be nice if there was an option on key fields to look up the key when entered and go to the record vs. just fill in the key and wait for the rest of the fields if the key did not exist. The current behavior is to LINKTOFORM with the data filled in, but then get a “key already exists” error; or LINKTOROW but the key doesn’t exist and get a “missing key” error. Kind of like LINKTOROW and LINK…

Thank you

[jazz59]

Hi! Are there any developments concerning this subject? I’m trying to combine both formulas so that columns from a certain row become populated with data from a form.