Skip to main content
All CollectionsBasics
Updating User Signup Fields into Custom Users Table
Updating User Signup Fields into Custom Users Table
Justin Yan avatar
Written by Justin Yan
Updated over 2 weeks ago

In situations where you would want to update the values in your user spreadsheet in-app, this will not happen automatically. Below is an overview of the areas your app will likely encounter this and how it can be proactively set up.


User Sign Up

Newly signed up users of your app and their details will not automatically update into your user spreadsheet. To make this happen, you need to configure a User Signup Action located in the 'Login & Signup Settings' tab.

From here select the 'Data Source Request' action and inside that action, pick your spreadsheet and make sure you're selecting the 'Create' action type. Fill the necessary user fields you wish to add to your users table with the {{ user.Field }} variable, where 'Field' is the name of the name of the field you've enabled for sign up.​

Important Note: For a field to appear in the user signup flow, you will also need to add this field as a Custom User Field with the 'Include in Signup' checkbox enabled. ​

​Click here to learn more about the Custom User Field

Another Important Note: In order for new fields to appear in the user signup flow, they'll need to be added as a Custom User Field with the 'Include in Signup' checkbox clicked.

Click here to learn more about the Custom User Fields.


Update Active User Field

Parts of your app flow may exist where you'll have to update a value from one of your user fields. This is essentially an equivalent function to the 'Update Active User' action for the user spreadsheet.

To achieve this, simply set up a 'Data Source Request' action with the 'Action Type' field set to Edit. The easiest way to set it up from there is to set your 'Row ID' value to {{ user.email }} and the 'Row Column' value to 'email' as well.

Under 'Request Fields', you can decide the custom value will be for the user being edited. Depending on how you plan to trigger this update, it can be a static value or a dynamic variable.

In the example below, the user's 'Role' can be updated after submitting the selection of the 'Update Role' dropdown when paired with the 'Edit Data Source Request' action.


Edit Profile

The edit profile is the one area of your active app that will automatically sync any updated values into your user spreadsheet. From the 'Edit Profile' tab, just ensure that you've defined the fields of your users table that you want to make editable by your users.

Did this answer your question?