In TimeTonic, it is possible to pre-fill certain fields in an external form by passing parameters directly in the form URL. This method allows you to personalize forms for each user or context without requiring them to manually fill out the relevant fields.

Step 1️⃣: Prepare and Share a Form

1. Organize the source table:

   • Create a table containing the required information (e.g., a list of events).
   • Add a specific field to identify each record (e.g., "Identifier" or "Event Name"). ℹ️ Ensure that this field is unique to avoid duplicates.

2. Set up the form table:

   • Create a dedicated table to collect data entered through the form.
   • Add columns corresponding to the fields you want to pre-fill (e.g., "Intervention," "Check 1," "Check 2").
   • If needed, link a column to the source table to associate the records (e.g., "Event" linked to the events table).

3. Protect sensitive fields:

   • Configure certain fields as read-only to prevent their modification in the form.

4. Share the form:

   • Access the "Share Form" option in TimeTonic.
   • Copy the generated URL for the form.

Step 2️⃣: Pre-fill Fields via URL

1. Get the form link:

   • Use the link copied in the previous step as a base.

2. Create a dynamic URL with CONCAT_URL:

   • In the source table, add a column of type "Formula."
   • Use the CONCAT_URL function to generate a URL containing the pre-filled parameters.
   • Simple Example for a single field in the URL:
     

     Example Result: When opening the form, my control link automatically inserts into my intervention form ⬇️

     

     3. Add multiple parameters in the URL:

     • If you want to pre-fill multiple fields, concatenate them in the formula as shown below:

     CONCAT_URL("<Target view URL>","&form_column_1=", Field 1, "&form_column_2=", Field 2)

     ➡️ You get a unique URL for each record in your source table, allowing you to open a form with fields already pre-filled.

     This method can be used to automate data entry, personalize forms, and reduce human errors.