Data (things)
Things are unique records in your database that can be created, edited and deleted with actions.
This core reference entry is suited for beginner-level builders.
Create a new thing...
This action creates a new entry in the application database, which we refer to as a Thing.
For the "Type" in this action's property editor, select an existing data type from the dropdown or define a new one by selecting 'Create a new type…' in this menu.
For example, you might select 'Event' from your list of data types. Once you do, and this action runs, a new 'Event' thing will be created into your application database.
When you click "Set another field," you can either choose from an existing field on that data type or create a new one. For example, if we already created a field for "Event name" in our Data Types tab, we can select this option and set it equal to an input's value. If we want to create a new field for "Start time," we can do so by selecting "Create a New Field" directly from the bottom of this dropdown.
Once you run this action, you can also see the matching changes in your Data tab, under Data Types and App Data.
Type
Choose the type of thing to create. Define a new type by selecting 'Create a new type...' in this dropdown menu.
Initial values
Click 'Add another field' to add a new field and specify a different value for that field. Select the field to modify, the operation, and the new value.
Make changes to thing...
This action modifies an existing entry in the application database. For example, if a user updates their first name, use 'Make change action' to the 'Current user's first name.'
Thing to change
Select which thing to modify.
Create if the thing doesn't exist
By default, this action does nothing if the thing you are trying to change does not already exist. Click this box to change this behavior. In this case, the action will be equivalent to 'Create a new thing' and will use the changes as initial values. Important: If the thing being changed, e.g., the 'Current user's thing,' does not exist, the thing will be created, but it will not be associated with the current user. Warning: This option has been deprecated on Jul 18, 2017. Applications created after this date will not be able to access it (but it will still be applied in run mode). Instead, users can use a condition on the action and create the thing if it does not exist in an action prior to the Change Thing action. We recommend users using this option to follow the same pattern as they upgrade their apps.
Changes
Add the modifications to apply to the thing currently being modified. Select the field to modify, the operation, and the new value. In addition to a simple action that assigns a value, other options are available, depending on the field type. If it is a list, choose from:
Add
Adds an item to the existing list. The type of thing should be of the same type as the field. If the item is already in the list, it will not be added.
Remove
Remove an item from the existing list. The type of thing should be of the same type as the field. If the item is not in the original list, nothing will happen.
Set list
Replace the current list with the new list. The value should be a list of things of the same type.
Add list
Add all the entries of the list defined to the existing list. If some items are already in the list, they will not be added.
Remove list
Removes all the entries of the list defined from the existing list. If some items are not in the list, they will not be removed.
Clear list
Deletes the content of the field and replaces it with an empty list.
Make changes to a list of things...
This action is equivalent to 'Make changes to a thing' but modifies more than one entry. Define a list of things to change, and each entry will be modified as described in the list of changes.
Type of things
Select the type of thing to modify. This is needed to test the type consistency with the actual list.
List to change
Define the list to modify. It can either be the result of a search or the content of a field that is a list of things. If the type is inconsistent, the expression will be red, and the action will not complete.
Changes
List the modifications to apply to the things currently being modified. Select the field to modify, the operation, and the new value.
We are aware that some users employ the "Make changes to a list of things" action to pre-load lists for later workflow reference. Note that this action immediately triggers the query and consumes workload, regardless of whether the results are used in a later step or if only part of the results are used. Because of the potential workload implications, we advise treating this as an advanced feature and using it cautiously. We are working on implementing the concept of a ‘workflow local variable’ to address this use case.
Delete thing...
Deletes a thing from the database.
To delete
Select which thing to delete.
Delete a list of things...
This action is similar to 'Delete thing' but deletes more than one entry.
Type of things
Select the type of thing to delete. This is needed to test the type consistency with the actual list.
List to delete
Define the list to delete. It can either be the result of a search or the content of a field that is a list of things. If the type is inconsistent, the expression will be red, and the action will not complete.
Copy a list of things...
This action duplicates a list of things.
Important: For performance and security reasons, the number of things in the initial list is limited to 100 entries. If the length of the list exceeds this, the action will do nothing.
Type of things
Select the type of thing to copy. This is needed to test the type consistency with the list.
List to copy
Define the list to copy. It can either be the result of a search or the content of a field that is a list of things. If the type is inconsistent, the expression will be red, and the action will not complete.
Set a Thing's slug...
This action modifies an existing thing's slug value.
Thing to change
Select the thing to modify.
Slug [Beta]
Specify the new slug value you want the thing to take.
Download data as CSV
This action enables users to download data as CSV. Use this to build your own admin page. End users are prompted to choose a destination for the file. This feature is available to users with a paid Bubble plan.
Type of data
Choose the type of data to export.
Data source
Define the list to export. It can either be the result of a search or the content of a field which is a list of things. If the type is inconsistent, the expression will be red, and the action will not complete.
File name
Enter a file name.
Date formatting
Select the date style to use. Choose from Excel friendly, Full (with time zone), and Custom.
Custom date format
Enter the custom date style to use.
Separator
Select the separator to use in the CSV file.
Include labels in first row
When this box is checked, the first row of the CSV file will include labels for the data.
Use field captions instead of IDs
By default, field IDs, which cannot be changed, are used as the column headers. Change this by checking this box. In this case, the captions defined in the Data Types section in the Data Tab will be used instead.
Note: 'Include labels in first row' must be selected to include the labels in the CSV file.
Wrap values in double quotes
When this box is checked, quotes are put around the data values.
Hidden columns
Select which fields should not be included in the CSV file.
Upload data as CSV
This action enables users to upload a CSV file and add the items in the application database. Each column should match a field of the selected type. The fields should be of type text, number, date, address, yes/no, or the unique id of thing in your database (type will be the data type of that thing). Uploading lists of things into one field must be uploaded as a JSON array. Currently, this action does not support uploading an array of things of another data type into one field (i.e. array of unique ids).
Important: This feature is available to users with a paid Bubble plan. This action is limited to uploading a maximum number of items at a time depending on your plan.
Type of data
Select the type of data to upload.
CSV file
Define the expression that points to the file to upload. Typically, it will use a file uploader element.
Separator
Select the separator to use in the CSV file.
Delete an uploaded file
This action deletes an uploaded file in your application storage. Only files uploaded by your application will be deleted. If the file is not found, the action will not do anything. Note that similarly to deleting files from the application editor, deleting a file does not modify things that refer to this file to wipe the URL at the thing level. If you wish to do this, you should do this first in your workflow.
Warning: Use this feature with caution as it permanently deletes your file. You will not be able to recover the deleted files.
File URL
URL of the file to delete. It should look like https://s3.amazonaws.com/appforest_uf//... or https://domain.com/fileupload/... for private files. Note that if the current user does not have permission to read the file, he will not be able to delete it.
Other ways to learn
Last updated