Tracking which form was used to provide info

[Uros_Cadez]

I have multiple forms, one for each type of request, such as “PO request”, “wishlist”. All of these forms are connected to the same table.

Is there some way to figure out which of these forms pushed the information into my table? Such as “PO request” form was used to fill out this row, “wishlist” Form was used to fill out another row.

Many thanks for any info you could provide.

Uros

[joost_mineur]

Hello @Uros_Cadez ,

Yes, that can be done, if you have your users open your form with a hyperlink.

Make sure your table has a column to store the source, something like “source”. A text column is fine, but other column types will work to.

The hyperlink should look something like:
https://coda.io/form/PO-request_fdfdfdfdfdfd?source=PO%20request

Edit your form to hide the source column and set the privacy settings to include hidden columns:

Alter the text in the URL PO%20request to represent the proper source. Spaces are not allowed, but %20 will create a space in the return value.

The link you can get copy when editing the form:

The link above is not an active working link but for illustraition only.

[joost_mineur]

@Christiaan_Huizer just pointed me to a fail-safe method for specifying the URL in your links: EncodeForUrl().

Using that Coda function prevents common mistakes when using spaces (and others characters) which are not allowed in a URL.

The CFL formula then looks something like this:
EncodeForURL(“https://coda.io/form/PO-request_fdfdfdfdfdfd?source=PO request")

[Uros_Cadez]

Wow, awesome @joost_mineur and @Christiaan_Huizer . Your kind help is truly appreciated and comes right on time . Merry Christmas!