⭠ all tutorials

Changing data on a live site

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

Often your users need/want to change the information in their 'profile'. But as we build no-code applications, often there is no 'real' log-in or 'real' profile for them to get on and update.

Airtable and Zapier make it super simple to alter this information.

The Set Up

Of course, the products database of user information should be on Airtable for this instance. I recommend assigning a user ID to each of them and notify them of their number... e.g. In my example below I'll be giving myself the User ID 123456. Not only does this help protect other people changing your information by using your name or email but it helps Zapier in looking up the information automatically.

Building the workflow.

First I set up an Airtable base, table and view. Ideally this is what you will use for your database. Make sure there are a few records in the database, if not, add some examples.

Duplicate the table with the records

Create a form on your duplicated table as the form users need to use to update their information. Remember that whatever data is in your original table, must go into your duplicated table. If you get new users added then you must update the duplicated table with that information.

I made USER ID a required field (as we need that!) but everything else optional, which means a user can update any of those fields or leave them for it to remain the same.

Now let's set up our Zapier integration.

First we need to set up a trigger when a new record is entered on the form above (of our duplicated records)

Then we need to search our original table for the data entered.

Depending on what information you are looking to search by, the fields below need to match. So I'm using a unique User ID assigned to each user. Which means I'm looking to search the User ID entered into the form in the User ID field of the original table. You need to select 'Search Value' to be the User ID too - in this example, the User ID of the sample is 987654.

Finally once the User has been found in the table, we want to update the record.

You'll need to select "Use a Custom Value" in the 'Record' field.

Then select the ID from your 'Find Record' step.

You can now go through your form and map the corresponding data fields with your fields in Step 1 (New Record in View).

Now, when you fill in the form with your User ID your profile info will be changed in the Airtable! (It may take a few minutes to update)

From this...
To this...

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

Often your users need/want to change the information in their 'profile'. But as we build no-code applications, often there is no 'real' log-in or 'real' profile for them to get on and update.

Airtable and Zapier make it super simple to alter this information.

The Set Up

Of course, the products database of user information should be on Airtable for this instance. I recommend assigning a user ID to each of them and notify them of their number... e.g. In my example below I'll be giving myself the User ID 123456. Not only does this help protect other people changing your information by using your name or email but it helps Zapier in looking up the information automatically.

Building the workflow.

First I set up an Airtable base, table and view. Ideally this is what you will use for your database. Make sure there are a few records in the database, if not, add some examples.

Duplicate the table with the records

Create a form on your duplicated table as the form users need to use to update their information. Remember that whatever data is in your original table, must go into your duplicated table. If you get new users added then you must update the duplicated table with that information.

I made USER ID a required field (as we need that!) but everything else optional, which means a user can update any of those fields or leave them for it to remain the same.

Now let's set up our Zapier integration.

First we need to set up a trigger when a new record is entered on the form above (of our duplicated records)

Then we need to search our original table for the data entered.

Depending on what information you are looking to search by, the fields below need to match. So I'm using a unique User ID assigned to each user. Which means I'm looking to search the User ID entered into the form in the User ID field of the original table. You need to select 'Search Value' to be the User ID too - in this example, the User ID of the sample is 987654.

Finally once the User has been found in the table, we want to update the record.

You'll need to select "Use a Custom Value" in the 'Record' field.

Then select the ID from your 'Find Record' step.

You can now go through your form and map the corresponding data fields with your fields in Step 1 (New Record in View).

Now, when you fill in the form with your User ID your profile info will be changed in the Airtable! (It may take a few minutes to update)

From this...
To this...

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

Often your users need/want to change the information in their 'profile'. But as we build no-code applications, often there is no 'real' log-in or 'real' profile for them to get on and update.

Airtable and Zapier make it super simple to alter this information.

The Set Up

Of course, the products database of user information should be on Airtable for this instance. I recommend assigning a user ID to each of them and notify them of their number... e.g. In my example below I'll be giving myself the User ID 123456. Not only does this help protect other people changing your information by using your name or email but it helps Zapier in looking up the information automatically.

Building the workflow.

First I set up an Airtable base, table and view. Ideally this is what you will use for your database. Make sure there are a few records in the database, if not, add some examples.

Duplicate the table with the records

Create a form on your duplicated table as the form users need to use to update their information. Remember that whatever data is in your original table, must go into your duplicated table. If you get new users added then you must update the duplicated table with that information.

I made USER ID a required field (as we need that!) but everything else optional, which means a user can update any of those fields or leave them for it to remain the same.

Now let's set up our Zapier integration.

First we need to set up a trigger when a new record is entered on the form above (of our duplicated records)

Then we need to search our original table for the data entered.

Depending on what information you are looking to search by, the fields below need to match. So I'm using a unique User ID assigned to each user. Which means I'm looking to search the User ID entered into the form in the User ID field of the original table. You need to select 'Search Value' to be the User ID too - in this example, the User ID of the sample is 987654.

Finally once the User has been found in the table, we want to update the record.

You'll need to select "Use a Custom Value" in the 'Record' field.

Then select the ID from your 'Find Record' step.

You can now go through your form and map the corresponding data fields with your fields in Step 1 (New Record in View).

Now, when you fill in the form with your User ID your profile info will be changed in the Airtable! (It may take a few minutes to update)

From this...
To this...

Often your users need/want to change the information in their 'profile'. But as we build no-code applications, often there is no 'real' log-in or 'real' profile for them to get on and update.

Airtable and Zapier make it super simple to alter this information.

The Set Up

Of course, the products database of user information should be on Airtable for this instance. I recommend assigning a user ID to each of them and notify them of their number... e.g. In my example below I'll be giving myself the User ID 123456. Not only does this help protect other people changing your information by using your name or email but it helps Zapier in looking up the information automatically.

Building the workflow.

First I set up an Airtable base, table and view. Ideally this is what you will use for your database. Make sure there are a few records in the database, if not, add some examples.

Duplicate the table with the records

Create a form on your duplicated table as the form users need to use to update their information. Remember that whatever data is in your original table, must go into your duplicated table. If you get new users added then you must update the duplicated table with that information.

I made USER ID a required field (as we need that!) but everything else optional, which means a user can update any of those fields or leave them for it to remain the same.

Now let's set up our Zapier integration.

First we need to set up a trigger when a new record is entered on the form above (of our duplicated records)

Then we need to search our original table for the data entered.

Depending on what information you are looking to search by, the fields below need to match. So I'm using a unique User ID assigned to each user. Which means I'm looking to search the User ID entered into the form in the User ID field of the original table. You need to select 'Search Value' to be the User ID too - in this example, the User ID of the sample is 987654.

Finally once the User has been found in the table, we want to update the record.

You'll need to select "Use a Custom Value" in the 'Record' field.

Then select the ID from your 'Find Record' step.

You can now go through your form and map the corresponding data fields with your fields in Step 1 (New Record in View).

Now, when you fill in the form with your User ID your profile info will be changed in the Airtable! (It may take a few minutes to update)

From this...
To this...

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

Often your users need/want to change the information in their 'profile'. But as we build no-code applications, often there is no 'real' log-in or 'real' profile for them to get on and update.

Airtable and Zapier make it super simple to alter this information.

The Set Up

Of course, the products database of user information should be on Airtable for this instance. I recommend assigning a user ID to each of them and notify them of their number... e.g. In my example below I'll be giving myself the User ID 123456. Not only does this help protect other people changing your information by using your name or email but it helps Zapier in looking up the information automatically.

Building the workflow.

First I set up an Airtable base, table and view. Ideally this is what you will use for your database. Make sure there are a few records in the database, if not, add some examples.

Duplicate the table with the records

Create a form on your duplicated table as the form users need to use to update their information. Remember that whatever data is in your original table, must go into your duplicated table. If you get new users added then you must update the duplicated table with that information.

I made USER ID a required field (as we need that!) but everything else optional, which means a user can update any of those fields or leave them for it to remain the same.

Now let's set up our Zapier integration.

First we need to set up a trigger when a new record is entered on the form above (of our duplicated records)

Then we need to search our original table for the data entered.

Depending on what information you are looking to search by, the fields below need to match. So I'm using a unique User ID assigned to each user. Which means I'm looking to search the User ID entered into the form in the User ID field of the original table. You need to select 'Search Value' to be the User ID too - in this example, the User ID of the sample is 987654.

Finally once the User has been found in the table, we want to update the record.

You'll need to select "Use a Custom Value" in the 'Record' field.

Then select the ID from your 'Find Record' step.

You can now go through your form and map the corresponding data fields with your fields in Step 1 (New Record in View).

Now, when you fill in the form with your User ID your profile info will be changed in the Airtable! (It may take a few minutes to update)

From this...
To this...

Often your users need/want to change the information in their 'profile'. But as we build no-code applications, often there is no 'real' log-in or 'real' profile for them to get on and update.

Airtable and Zapier make it super simple to alter this information.

The Set Up

Of course, the products database of user information should be on Airtable for this instance. I recommend assigning a user ID to each of them and notify them of their number... e.g. In my example below I'll be giving myself the User ID 123456. Not only does this help protect other people changing your information by using your name or email but it helps Zapier in looking up the information automatically.

Building the workflow.

First I set up an Airtable base, table and view. Ideally this is what you will use for your database. Make sure there are a few records in the database, if not, add some examples.

Duplicate the table with the records

Create a form on your duplicated table as the form users need to use to update their information. Remember that whatever data is in your original table, must go into your duplicated table. If you get new users added then you must update the duplicated table with that information.

I made USER ID a required field (as we need that!) but everything else optional, which means a user can update any of those fields or leave them for it to remain the same.

Now let's set up our Zapier integration.

First we need to set up a trigger when a new record is entered on the form above (of our duplicated records)

Then we need to search our original table for the data entered.

Depending on what information you are looking to search by, the fields below need to match. So I'm using a unique User ID assigned to each user. Which means I'm looking to search the User ID entered into the form in the User ID field of the original table. You need to select 'Search Value' to be the User ID too - in this example, the User ID of the sample is 987654.

Finally once the User has been found in the table, we want to update the record.

You'll need to select "Use a Custom Value" in the 'Record' field.

Then select the ID from your 'Find Record' step.

You can now go through your form and map the corresponding data fields with your fields in Step 1 (New Record in View).

Now, when you fill in the form with your User ID your profile info will be changed in the Airtable! (It may take a few minutes to update)

From this...
To this...

Get help and discuss

Open community forum

More lessons

Fetch data via API using Data Fetcher and Airtable
How to Add Stripe Billing to a Bubble App
How to Build a Customer Portal with No-code using Bubble and Stripe
Setting up user profiles and authentication on Webflow with 8base
Creating a Wikipedia Clone with Bubble
Develop a custom CRM using Retool and 8base
Generating serverless functions in the CLI - 8base
Connecting to a workspace GraphQL API - 8base
Authorization basics with roles and permissions - 8base
Working with GraphQL queries in the API Explorer - 8base
Slack App That Scrapes Websites for Data
How to Easily Scrape Websites for Data using Autocode
Greet new members privately in Slack with Autocode + Block Kit Builder
Working with APIs - integrate Slack with Typeform using Autocode on Standard Library
Generate QR Codes from Links
Linktree Clone with Adalo
Build an Airtable powered mobile app with Adalo
Fitness planner + tracker with Airtable and Twilio on Standard Library
Dating app with WordPress and CometChat Go
How to batch process Webflow item IDs using Integromat
Instagram clone with Bubble
A Meetup clone built in Adalo
A Vegan meal planner with Bubble
Get data from an API with Parabola + Google Sheets
Cameo clone in Glide - book video shoutouts from celebrities
Send SMS Surveys with Twilio + Airtable on Standard Library
Custom Status Page with Standard Library & Airtable
Build a Twilio SMS Hub with Standard Library
Instagram clone using Glide and a Google Sheet
Sending a SMS Message from a website
Build a Slack / Airtable / Stripe CRM
Meditation mini-app and tracking progress
Browse all →

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.