Here's How to Pre-fill Column Data within Workform URL

Platform discussions Special workflows & use cases
1

Hi! :waving_hand:

If you didn’t know how to get prefilled-data into a Workform to save time and prevent potential errors, here’s how you can do it.

For regular form links, at the very end, you’ll add “&[column ID]=[text you need]”
For shortened form links, at the very end, you’ll add “?[column ID]=[text you need]”

You can continuously add “&[column ID]=[text you need]” for each prefilled-data you need thereafter on both link types.

Note: I cannot yet figure out how to get this to work for Date, Timeline, Country, Subitem, and Connect Board columns. This will obviously not work for Files.

If you have an Enterprise account, you can even use field-parameters to create the links based on another board’s information.

USE CASE EXAMPLE - It’s a dummy, so feel free to click and see it in action.
We have an Organizations/Schools board that contains our internal ID we provide for each school. We are sending the school a form link they’ll send to parents in order to sign up for a camp we are hosting.

To ensure no mistakes are made when selecting which school the student attends, we’ll send an email to the school with a link that will automatically place the school’s ID in the form, which will then connect the child to the school after item creation (form submission) via automation/workflow.

Long URL: https://forms.monday.com/forms/e22112b03fcd164ec31b8d0ef7f64fcd?r=euc1&text_mkpd2vsf=123456
Workform’s Shortened URL: https://wkf.ms/4kZ5dWF?text_mkpd2vsf=123456

As you see, both URL options work flawlessly. Now, if I wanted to include, let’s say, another parameter to be prefilled:

Long URL: https://forms.monday.com/forms/e22112b03fcd164ec31b8d0ef7f64fcd?r=euc1&text_mkpd2vsf=123456&text_mkpdw1qn=Sam
Workform’s Shortened URL: https://wkf.ms/4kZ5dWF?text_mkpd2vsf=123456&text_mkpdw1qn=Sam

VERY IMPORTANT NOTE: If you want to include prefilled-data that includes spaces, your link will not work unless you substitute “%20” or “+” for each space. For example:
Workform’s Shortened URL: https://wkf.ms/4kZ5dWF?text_mkpd2vsf=123456&text_mkpdw1qn=Sam+Michael
Workform’s Shortened URL: https://wkf.ms/4kZ5dWF?text_mkpd2vsf=123456&text_mkpdw1qn=Sam%20Michael

If you have an Enterprise plan, you can replace these spaces using either option with Workflows and the Workflows:Formula app. Then, create the final link URL and place it in a link column within the Workflow.

I hope you found this helpful. If you have any questions on this or other workflows, feel free to reach out. :grinning_face:

5 Likes
2

Hi @DavidSchenkler

It seems like at the moment monday only support text when it comes to URL Params.

If you are interested in this feature, our monday app Easyform supports URL Params for all field types, you can check out our post about it here.

If you want help setting this up or have any questions, you can reach us at easyformsupport@easyapphq.com or book a call with us here.

3

This is working nicely for simple use cases.

Be sure to remember that different browser have different max URL lengths for HTTP GET requests:

Browser URL Length
Google Chrome Maximum of 2048 characters for a URL
Mozilla Firefox The address bar no longer shows the URL after 65536 characters
Internet Explorer Maximum length of the URL is 2083 characters
Safari Supports up to 80000 characters for a URL
Opera Can display up to 190000 characters in its address bar

Source.

It’s really a shame that we can’t send large amounts of data into a WorkForm using HTTP POST, but that’s sadly not currently available.

I can see examples of usage where that would be most convenient.

For example, when your AI chatbot cannot answer a question, they could forward the person to a WorkForm pre-populated with the chat history if the POST was available, thereby adding much needed context to a support query.

@Nachliel do you support HTTP POST?

2 Likes
4

Thanks for letting me know. I’m a bit of a Monday purist, so I try to stay away from other apps unless absolutely necessary. However, I’ll check it out!

2 Likes
5

I think the day after I posted this monday.com added pre-fill, which made literally everything so much easier. Haha.

For those with Enterprise, you can pre-fill country by utilizing the CODE, not the name of the country.