Send data from an app
If you want to save data collected by your app, you must send it to a database. You can send all manner of data from an app to a database, including documents and analytics information (data regarding how often people use your app).
In this lesson:
How to send data
Sending data from your app is a relatively simple two-step process:
Step 1. Add a Send Data function to a Page Block
You send data from a Page Block using the 'Send Data' function:
When you add a 'Send Data' function, you must select where you want to send the data to. When you select 'Workbase', you'll be prompted to select which Workbase (you can have multiple) and which table within that Workbase.
Step 2. Specify what data you want to send
You decide exactly what data is sent to your database. When you click "+ Add", you can specify what column in your database you want to populate and what data you want to populate it with:
When you select what data you want to populate in the database column, you can either select a variable or type a value in directly.
Sending key values
Remember, the left-most column in your database is the "key column." The value stored in this column must be unique for each row.
By default, when you send data from your app you are automatically assigning a random but unique value (a 32 character string):
You can choose anything to be your key column, just make sure that it's unique per user.
How to update existing rows
Whether your 'Send Data' function creates a new row or updates an existing row depends entirely on the value sent to the key column.
If you send data to a database and the key column value you send is equal to an existing key column value, the app will not create a new database record but instead will update that pre-existing record.
Sending data from a Loop Section
Send variables to matching columns
If your app's variables have the exact same name as a columns in your database, then the variables are "matching" and you can use this feature.
These variables match the database columns: