About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How can I have an Interfaces form show data from a specific Tables record?

  • 17 June 2023
  • 4 replies
  • 337 views
Jason Steele

We use an Interface form linked to a Tables table to input data. The form always seems to start empty and adds a new record when submitted.

What I need to do now, is direct someone to this form, with a specific record's data aligned to it, so they can complete the entries for that record, once other required data has been collected.

There should be a way to not just tell the form to connect to a table, but also a specific record in the table if you don't want to always be entering a new record.

Thanks.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Jason Steele 

Good question.

You can prefill Zapier Interface fields using the query string parameters.

Check the Reference section for the internal field ID to use. (Found at the bottom of the field config screen.)

Example: https://page.zapier.app/?email=XXX

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@Jason Steele 

I don’t think there is currently the ability to update an existing Table record using an Interface Form without using a Zap.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Jason Steele

 

Thanks. I'm already aware of the query string option.

That would allow me to prefill a standard form, but wouldn't actually connect it to the required record in the actual Tables data. If we use this method and click "submit", it will end up making a new record, not updating the record that already exists. 

Similar to how an actual DBMS form can make new records or navigate between existing records, so should an Interfaces form.

Troy Tessalone
Userlevel 7
Badge +14

@Jason Steele 

I think right now you’d have to use a Zap to find/update else create a record using Tables and Interface Forms.

 

Perhaps log all form submissions in 1 Table, then have a separate Table that is used as the main with unique deduplicated data that is updated via Zaps.

 

You can submit feedback directly to the Zapier Interfaces Team via this form: https://eap.zapier.app/interfaces

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions