How to pre-fill a field in a blank form by setting its URL.
Automatically pre-filling fields in a blank form by setting the URL is a simplified method of input, allowing you to tailor the form to a user or a context.
Let's take an example.
I have a blank form associated with each piece of equipment in which I can declare an incident.
And we want the name and equipment category to be pre-filled automatically in the form fields.
First the prerequisites.
To achieve this,
we link two tables,
an equipment list table and a form table.
Let's go to the form table.
This form table has a column link set to selection and unique link.
and it also has other columns allowing the user to add elements in the field,
and we will pass two elements in URL parameters.
The element of the equipment name and the equipment family element.
Let's take advantage of memorizing the field codes as we will need them later in the field which are these two elements here,
in equipment and in family,
since they are going to...
We are going to need them for...
for the URL setting.
Then,
we create a view in which we are going to set a restriction on the visibility of our columns in read,
write or invisible.
And I will put my link column in read only and my familiar text column in read only so that it is not modified by the user.
Then,
I will share my form,
edit it first to customize it.
I will copy the form URL,
and I go to the equipment table.
In this table of equipment,
insert...
I will insert a formula column.
in which we will use the concaturl function,
I open the quotation marks,
I paste the url of the blank form,
I close the quotation marks,
I put a comma,
Then,
I insert the values to add in pre-fill in the setting of this URL.
this element here corresponds to the name of the field code of the linked table column available in my form table.
And this one too.
these elements here are the dynamic elements available in my equipment table.
on the blank form URL in Timetonic.
To add additional parameters,
we only use the and to separate them and the equal to assign a value to each key.
this one.
I could very well only have one or have more.
procedure,
it would suffice to duplicate the procedure.
of equipment.
I insert.
the URL and if I look at the end of this URL,
I will find all the information I want to get.
I will,
for aesthetics,
make the URL in button form.
I will click on my URL My form opens and it does have the pre-fill of my values available in the table.
I only have to fill in the elements of my form and then validate it.
Once I have validated the blank form,
I return to my form table and I discover the line of the form created with the elements that have pre-filled automatically and the rest of the information filled in by the user.
In conclusion,
thanks to this trick,
automate and customize your blank forms in Timetonic.
