Unique Form Links

Mherring

Im trying to create unique form links for an internal survey im running - i know there are better survey tools out there. Im just trying to make this work for my short term purpose.

I keep getting an #UNPARSEABLE error with my formula. Can someone check my logic out and let me know where im going wrong?

Formula:
=CONCATENATE("https://app.smartsheet.com/b/form/205c69ae71284a3ebf9d36531112783f", "?unique=", [Unique ID]@row, "-", NOW())

My understanding is this should provide a semi-unique link to the main form Then i plan to run the response on each through a webhook using javascript to grab the timestamp

Paul Newcome

Smartsheet does not have a CONCATENATE function or a NOW function. To concatenate in Smartsheet, you "add" each piece together

="https://………………" + "?unique=" + [Unique ID]@row

Mherring

hmmm without the NOW command im wondering is there a function i can use to generate a unique link?

Paul Newcome

Wouldn't it be unique simply by using the [Unique ID]@row in the link?

Mherring

You are right it did work - however the unique links are not filling out their individual row.

="https://URL REDACTED" + "?unique=" + [Account Number]@row

Paul Newcome

The unique links are still to a form, and form entries will always create a new row. Are you trying to update a row that already has data in it?