Pre-fill multiple form fields using button field


I have a real problem dealing with the button field’s open URL feature & also the formula field.

What I’m trying to do is to pre-fill two form fields by clicking a button.
What I did is I followed your tutorials to create the formula for the button field, but it throws an error that the formula is not right.

My formula is:

I don’t know exactly where is the error is, I tried replacing the (+) sign with “%20” and tried putting “” before and after the URL, and also tried to replace the “&” after the URL to “?”.

I just want to prefill these two fields when I click on the button and leave other fields to be populated manually. How can I do that?


I tried something and it worked out. Thanks anyways.

Here’s the solution if someone has the same problem:

“FORMLINKHERE?prefill_First+Field=” & {Field Name} & “&prefill_Second+Field=” & {Field Name}

and so on, fill as many fields as you need.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.