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.
Regards,
Tom.