Reference current view of table to use as new row value with form entry

[Andrew_Hanson]

Hello,

I’m attempting to do something I think should be simple, but I haven’t found the correct formula yet.

I have a view of a table as a form on a separate page from the main table and would like to automatically generate a couple of columns in the row. The one I’m having trouble figuring out is a Location column where I want the “Location” cell to generate the text value from the page name from which I’m currently entering info through the form.

Here’s my project so far:

[Pch]

Hi @Andrew_Hanson !

Maybe using the URL of the form to pre-fill that field could potentially help you here ?
(If you publish your forms… As I don’t think this would work otherwise)

Launched: Pre-filled Form Fields

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: Publish your form Append text to your URLs to specify any fields that should be pre-filled (read on for more) [Prefilled Forms] URL Structure to Pre-Fill Fields To pre-fill fields, grab your published form URL and add …

[Andrew_Hanson]

Thanks for the response!

I attempted locating where I would enter the URL parameter I need and I can’t seem to locate it. I am using the free version of Coda. Will I need a subscription to edit URLs?

[Pch]

That was just a thought @Andrew_Hanson …

@Andrew_Hanson

I attempted locating where I would enter the URL parameter I need and I can’t seem to locate it.

Once your form is published (as so far, your forms are not published), pre-filling a field in a form is done by appending ColumnName=DesiredPrefilledValue to the URL of the published form…

After that, to display and use your form in your page, you would just need to embed the published form using the modified URL .
(See sample below, it might be more helpful than what I just wrote ) .

@Andrew_Hanson

Will I need a subscription to edit URLs?

From the Pricing Page, I’d say no . It seems like it’s included in the Free tier

I hope this helps
(Sorry, I have my hands a bit full at the moment )

[Andrew_Hanson]

I appreciate all the info!

I’m attempting to locate where I can append that to the URL. Directly in the browser address bar?

I viewed a walkthrough and it appears it’s that simple. I’m including screenshots because, from what I can tell, my form is published and appending the value I want, following directions from this walkthrough, is not working.

[Andrew_Hanson]

I just published all my forms, finding the list on them main form. So now they’re published, but I must be missing something. I don’t see how to append like they’re instructing in the tutorial I shared previously.