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?