Excel Template for Prefill Form (so users can edit their record)

Topic Labels: Formulas
903 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi all,

Just wondering if anyone has an excel template (or Airtable?) that has some embedded formulas to prefill a form and would be so kind to share it with me?

I’m trying to create one myself but I’m only intermediate at excel, and the form I’m using has about 20 prefilled fields (plus the record ID at the top hooked in with a Zap to update the record). Issues I’m struggling with is using the TEXTJOIN and CONCAT formulas, especially given that the fields are sometimes long text with multiple spaces.

Happy to collaborate with my current work too.


0 Replies 0