1. Pre-fills automatically using data from a connected source (CRM, spreadsheet, or form).
   
2. Displays as a subform table - meaning it repeats rows for related records (like line items, dependents, team members, or assets).
   
3. Remains interactive in the final document - allowing users (like clients, vendors, or staff) to review, edit, or add more entries directly within the document before signing or finalising it. 

Steps

How to generate an interactive pre-filled form

1. Create a new Merge Template.
   
2. Go to Automate tab and connect the template to a data source if you want to pre-fill some fields using the field values from the data source.
   
3. To insert non-editable pre-filled data (read-only fields)
   
1. Insert the required merge fields for pre-filled data (such as Name, ID, Department, Service Type, etc.) and ensure they are correctly mapped.
   
2. Choose the appropriate field type (text, dropdown, checkbox, date, number, etc.) based on the data you want the user to input.
   
3. These values are automatically populated during merge and remain non-editable in the final document.
   
4. To insert interactive pre-filled fillable field
   
1. Use this for fields that should be auto-populated but still editable by the recipient.
   
2. Insert fillable fields and map them to merge fields so they are automatically pre-filled during merge and remain interactive in the merged fillable form.
   
5. To Insert pre-filled subform table (interactive subform)
   
1. Use this for repeating data groups, such as line items, dependents, or asset lists. Go to Insert > Fields > Fillable Fields > Subform table.
   
    
   
   
   
2. Choose how to create it:
   
1. Option 1: Insert pre-filled subform table - Use this if you want the subform to display multiple records like a list of services from a data source and choose the fields that need to be pre-filled. The subform fields will automatically populate from the source’s related list.
   Note: Please note that to use this, the data source shall not be a CSV file.
2. Option 2: Empty fillable subform table - Use this if you want form fillers to manually add entries by filling in the fields (e.g., additional overtime tasks).
   
1. Choose Create Empty Subform Table.
   
2. Define the columns (e.g., Task Name, Hours Worked, Overtime Rate). Users will be able to add or remove rows when filling out the form. 

Additional Note

How to add formula for real-time calculations   in your form 

1. Formula fields let you automate calculations directly within the document.
   
2. Place the cursor where you want to add the formula field. (e.g., beside a “Total” label).
   
3. Go to Insert tab > Fields > Fillable Fields > Formula under Advanced fields. You can also choose formula from the visual cue on the left side of the table.
   
4. Use conditional formulas like SUMIF and SUMPRODUCT within the subform table.
   
   
   
   
   
   
5. Define the formula expression. You can reference fillable fields by their field names.
   
   
   
   
   
   
   Example: Total Wage = (End Time - Start Time) * Hourly Rate
   
   For a subform: Total OT Pay = SUM(Subform.OT_Hours * Subform.OT_Rate)
6. When users enter data or modify a value in a fillable field, the formula updates automatically. Click here for more info on formula in Writer.