For everyone experiencing the following problem with Coda pre-filled in form:
You use Coda Form with a pre-filled-in field which is a references to another table. But on submit instead of reference to the original table, the new entry in the column is some weird url-like text inside. Respectively no other reference information from the source table is displayed either.
After some testing I found that this has to do with urldecoding on form submission.
Solution
I use a free URL Decode pack (bless you Hugo!). Once a form is submitted an automation runs to update the column if the reference is broken.
A screenshot of my automation rule:
And here is the formula for the update value of the reference column (named “Обект” in my example):
If([Step 1 Result].[your-reference-column].Containstext(“%”),UrlDecode([Step 1 Result].[your-reference-column]),[Step 1 Result].[your-reference-column])
If the reference column contains a text symbol “%” runs the pack formula urldecode(). I wrap it in IF formula because I wanted to avoid running the pack unless necessary.
If you have several pre-filled in fields, just create another Update value with another IF formula.
So far this worked worked 100% of the times for over 300 submissions with multiple reference columns/pre-filledin fields in a single form.