# Launched: Pre-filled Form Fields **URL:** \ **Category:** News from Superhuman\ **Created:** [January 11, 2021, 6:58pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676 "2021-01-11T18:58:32Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![alexdeneui](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/alexdeneui/32/5728_2.png) [@alexdeneui](https://connect.superhuman.com/u/alexdeneui)\ **Post date:** [January 11, 2021, 6:58pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/1 "2021-01-11T18:58:32Z")
We’ve loved hearing about the incredible ways you’ve been using forms in the few weeks since they’ve launched, and wanted to share an exciting update based on your feedback. Starting today, you can update URLs for forms you publish to pre-fill fields in your forms. To do so: 1. Publish your form 2. Append text to your URLs to specify any fields that should be pre-filled (read on for more) ![Prefilled Forms](https://global.discourse-cdn.com/coda1/original/3X/0/3/03c737199649aa6b66a3259e9a89e59d026eb971.gif) **URL Structure to Pre-Fill Fields** To pre-fill fields, grab your published form URL and add addition text, starting by appending ? to the URL. Then, indicate fields that should be pre-filled using the Column Name (in the underlying results table) and the designated value. For example for the form below, you could pre-fill the name of the “Project” to “Razor Crest” by structuring your URL as [https://coda.io/form/Generic-Form-Name?Project=Razor%20Crest](https://coda.io/form/Generic-Form-Name?Project=Razor%20Crest). ![d29c23ca-6f79-412a-9215-ab86c6dafa89.png](https://global.discourse-cdn.com/coda1/original/3X/e/0/e0b563655e0d882f81ec94fb19545e3cbccb1dc0.png) Then, anyone who access the form from that link will have the project pre-filled for them. If you were on team Galaxy’s Edge and wanted to pre-fill that Project Name for your team when filling out the form, you’d put Galaxy%27s%20Edge as the value for Project in the URL. (Please note the standard URL encoding for apostrophes and spaces, as column names and values need to be URI encoded.) You can pre-fill multiple values (or pre-select multiple choices from a multi-select list) by separating the values with commas in your URLs. **Pre-Filling Hidden Fields** Perhaps you want to add some information by default in your results table, but in columns that are hidden in your form. To do so: 1. Navigate to your form options 2. Select Publish 3. Open the Privacy settings 4. Toggle “Include hidden columns for URL parameters” to on This will allow you to encode your URLs with parameters that are collected in hidden columns that people filling out your form would not see. A common example would be “Source” to structure a URL sent via email to indicate the form was filled out via your email send (vs. via Slack or some other way of sharing). **A note on security & privacy** Please respect your users’ security and privacy when encoding form URLs. Nothing sensitive should be encoded or collected via your URLs, as query parameters are logged all over the Internet. Forms found to be violating this stipulation may be disabled per [Coda’s terms and conditions](https://coda.io/trust/tos). ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [January 11, 2021, 7:07pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/2 "2021-01-11T19:07:11Z")
Thanks for this update! Coda grows more powerful daily! 🚀 > [@alexdeneui](#): > > Nothing sensitive should be encoded or collected via your URLs, as query parameters are logged all over the Internet. Forms found to be violating this stipulation may be disabled per [Coda’s terms and conditions](https://coda.io/trust/tos). Can you explain what you mean here? It’s not apparent what the risk is. Thanks! ---
**Author:** ![Andrew\_Stinger](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andrew_stinger/32/19475_2.png) [@Andrew\_Stinger](https://connect.superhuman.com/u/Andrew_Stinger)\ **Post date:** [January 11, 2021, 7:14pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/3 "2021-01-11T19:14:58Z")
Our lawyers won’t let us provide legal guidance here, but I would pay attention to section 2.4 in our Terms of use, and related stipulations. (The tl;dr is don’t be creepy and collect private information without users’ consent.) > **[Coda | Trust](https://coda.io/trust/tos)** > > We take your privacy seriously, never sell data, and always keep you in control. ---
**Author:** ![Andre\_Nader](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andre_nader/32/5101_2.png) [@Andre\_Nader](https://connect.superhuman.com/u/Andre_Nader)\ **Post date:** [January 11, 2021, 8:36pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/4 "2021-01-11T20:36:12Z")
Really exciting update. Are there any plans to allow for pre-filling and submitting a form via URL? One of my current workflows involves inventory management where I scan item in via NFC. Currently I have the NFC open a url of a pre-filled and submitted Google Form, then use Albert’s javascript code to port Sheets -\> Coda. If the form would auto-submit I could keep everything in Coda! (I know the ideal solution would be using some API webhook, but looking for as no-code as possible) ---
**Author:** ![alexdeneui](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/alexdeneui/32/5728_2.png) [@alexdeneui](https://connect.superhuman.com/u/alexdeneui)\ **Post date:** [January 11, 2021, 9:22pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/5 "2021-01-11T21:22:44Z")
Interesting use case! You’re right in that using the API would be the best bet here (although, having said that, we have not wired in form submission into the API yet). The issue with an auto-submitting form URL that submits when you fetch it is that it can be used to harvest data from users who simply click on a link (in particular, the identity of the clicking user). So we’d have to carefully consider the security implications of enabling this if we were to do it. ---
**Author:** ![joost\_mineur](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joost_mineur/32/30539_2.png) [@joost\_mineur](https://connect.superhuman.com/u/joost_mineur)\ **Post date:** [January 11, 2021, 10:35pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/6 "2021-01-11T22:35:05Z")
Perhaps nice to know (if you didn’t already know) that you can prefill multiple fields by connecting the fieldname/entry pairs with an “&”: `form_url?naam=Joost%20Mineur&email=joost@skygliders.nl` ---
**Author:** ![Andre\_Nader](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andre_nader/32/5101_2.png) [@Andre\_Nader](https://connect.superhuman.com/u/Andre_Nader)\ **Post date:** [January 11, 2021, 10:59pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/7 "2021-01-11T22:59:21Z")
Correct. In actuality I don’t need a form at all, just adding rows so the API is likely the solution i’ll eventually need to get to! ---
**Author:** ![Franck\_Genissel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/franck_genissel/32/6449_2.png) [@Franck\_Genissel](https://connect.superhuman.com/u/Franck_Genissel)\ **Post date:** [January 12, 2021, 10:48am UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/8 "2021-01-12T10:48:08Z")
Very nice, I’m hurrying to test this 👍🏻 👍🏻 ---
**Author:** ![Jake\_Nguyen](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jake_nguyen/32/32176_2.png) [@Jake\_Nguyen](https://connect.superhuman.com/u/Jake_Nguyen)\ **Post date:** [January 14, 2021, 5:44am UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/9 "2021-01-14T05:44:26Z")
[![](https://global.discourse-cdn.com/coda1/original/3X/9/2/92dab785841f50b89ba93483cd055b213e90ff3e.jpeg "My longest yeah boy ever") ](https://www.youtube.com/watch?v=fvtQYsckLxk) ---
**Author:** ![BenDavis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bendavis/32/8288_2.png) [@BenDavis](https://connect.superhuman.com/u/BenDavis)\ **Post date:** [January 14, 2021, 6:39pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/10 "2021-01-14T18:39:58Z")
@Jake_Nguyen thank you for reminding me of the existence of this Youtube gem ---
**Author:** ![Pete\_Wright](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pete_wright/32/19104_2.png) [@Pete\_Wright](https://connect.superhuman.com/u/Pete_Wright)\ **Post date:** [January 28, 2021, 7:04pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/11 "2021-01-28T19:04:22Z")
Forms in Coda have completely upended our workflow in the best way. Thank you so much for this! My question… We run podcasts through Coda and we have a table with guest information… you know, headshot, bio, social links, etc., which is tied to episodes such that we can hop to guest detail directly from an episode we’re working on. Now, we’ve published the form for the guest table so new guests can submit their own information to us saving us the work of copying and pasting to build the form. Naturally, with this great feature comes a new desire. Is there a way, or interest in a way to be able to send a link to a past guest so that they can see the form with their information in it? That way, repeat guests can update their bio, headshot, etc., whenever they need to? That… that would be madness. Thanks all! Pete ---
**Author:** ![BenDavis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bendavis/32/8288_2.png) [@BenDavis](https://connect.superhuman.com/u/BenDavis)\ **Post date:** [January 28, 2021, 7:21pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/12 "2021-01-28T19:21:21Z")
Pete, I think this is easily doable. Here’s how I would approach that problem: 1. Guests fill out info on form the first time, information flows into table A 2. Table A has a formula column that generates a link to a form with the row information pre-filled. The formula would use the Concatenate() formula to generate the link with that row’s information. 3. You can send that link as a form to the guest, which would provide them view of their current information. Guest could update their information as needed and the results from that form would flow into a _new row_ in Table A. 4. Use [duplicate row](https://connect.superhuman.com/t/highlight-duplicates-in-a-column-using-a-conditional-format/176) to highlight duplicates, ideally keyed on email or name. 5. Create a view of Table A that returns all rows that are the earliest version of the duplicate rows. This returns the first, or the ‘wrong’ guest information. 6. Create a button that deletes all rows in that table. 7. Create an automation that runs on some interval and clicks button from Step 6. Voila! Table A always has the latest guest info, and you have a form that you can send to guests which will let them update information on their own terms. ---
**Author:** ![Stefan\_Stoyanov](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/stefan_stoyanov/32/24536_2.png) [@Stefan\_Stoyanov](https://connect.superhuman.com/u/Stefan_Stoyanov)\ **Post date:** [February 2, 2021, 3:02pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/13 "2021-02-02T15:02:44Z")
Thanks for that cool solution, Ben. But ‘easily doable’ is a bit too optimistic 🙂 ---
**Author:** ![BenDavis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bendavis/32/8288_2.png) [@BenDavis](https://connect.superhuman.com/u/BenDavis)\ **Post date:** [February 2, 2021, 3:29pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/14 "2021-02-02T15:29:03Z")
Ha! Fair point @Stefan_Stoyanov🙂 ---
**Author:** ![Joscha\_Filius](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joscha_filius/32/10498_2.png) [@Joscha\_Filius](https://connect.superhuman.com/u/Joscha_Filius)\ **Post date:** [February 5, 2021, 8:24am UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/15 "2021-02-05T08:24:54Z")
Love the feature, it does however seem to be quite slow for me. Takes about 20 seconds before it visually fills the form. ---
**Author:** ![joost\_mineur](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joost_mineur/32/30539_2.png) [@joost\_mineur](https://connect.superhuman.com/u/joost_mineur)\ **Post date:** [February 5, 2021, 9:02am UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/16 "2021-02-05T09:02:51Z")
The processing seems to take a little bit, but for me it takes about 1 second to load the form and about 3 seconds to fill the fields (2 fields). ---
**Author:** ![Kelly\_Claus](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/kelly_claus/32/19662_2.png) [@Kelly\_Claus](https://connect.superhuman.com/u/Kelly_Claus)\ **Post date:** [February 27, 2021, 10:50am UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/17 "2021-02-27T10:50:54Z")
(New to Coda, so forgive me if this is obvious…) I’m wanting a hidden field to be pre-filled, but for a form that’s just **inline on a coda page** (i.e., not “published”). The workaround I’m finding is that I’m editing the URL (as you’ve said above - works fine) and then embedding the form on the page. But that seems like it should be unnecessary, right? ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [March 2, 2021, 1:31pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/18 "2021-03-02T13:31:02Z")
> [@Pete\_Wright](#): > > Naturally, with this great feature comes a new desire. @Pete_Wright I am stealing this line for all future new posts! ---
**Author:** ![Ed\_Liveikis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ed_liveikis/32/21358_2.png) [@Ed\_Liveikis](https://connect.superhuman.com/u/Ed_Liveikis)\ **Post date:** [March 18, 2021, 2:35pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/19 "2021-03-18T14:35:29Z")
> Blockquote > I’m wanting a hidden field to be pre-filled, but for a form that’s just **inline on a coda page** (i.e., not “published”). > Blockquote Any update on this? I’m trying to pre-fill form fields for an unpublished form without luck. The form is defined within the same document that I want to use it in, and when I tried embedding (which doesn’t sound workable anyway), it gives me an error about a recursive document include. ---
**Author:** ![Ed\_Liveikis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ed_liveikis/32/21358_2.png) [@Ed\_Liveikis](https://connect.superhuman.com/u/Ed_Liveikis)\ **Post date:** [July 2, 2021, 4:58pm UTC](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676/20 "2021-07-02T16:58:10Z")
Hm I have a text Column as the first field on the form, but it seems I can’t use the pre-filled parameter with it. If I move that field to be the second field on the form, then it works. [Next page](https://connect.superhuman.com/t/launched-pre-filled-form-fields/20676.md?page=2)