💾Field types table

The table below contains (1) the keywords you should use in actions that require you to define field types and (2) a description of how they will be interpreted and in which format you should provide data to avoid inconsistencies.

Since all data must be provided as text, the plugin will convert this text into a "type" based on the keywords you use.

We left more than one keyword for each type, in order to help no-codes to choose terms they're more familiar with.

Keywords	Description and how to format the value
boolean bool	Turns "0", "no" and "false" texts into a boolean value of false, and turns any other values into the boolean value of true.
text	Treats the entry as a simple text field.
number	Tries to convert the value into a number. Will result in error if it's not possible and won't store the value.
date timestamp	Tries to convert the value into a datetime value. Best practice is to use ISO Format provided by Bubble's date formatter (2023-12-14T00:00:00.000Z-03:00)
map json array list object json object	Tries to convert the text into a JSON object, that will be stored as a Map or Array type on Firestore. If the conversion fails, it won't store the value. Sample Array: ["text1", "text2", "text3"]. Sample Map: {"prop1": "text1", "prop2": 10, "prop3": "text3"} This only supports texts or number types on the JSON structure. You can also construct Maps by using dot notation, which allows you to define more types. For instance, you can store a "date" on the key "log.date" and it will store a Map {"date": date_value} on the "log" field.
reference	Tries to create a document reference from a path given as text. For instance: users/doc_id will be turned into a reference to the users collection, to the document of ID "doc_id". For subcollection, you only need to provide the full path: users/doc_id/subcollection/sub_doc_id.
reference list	Tries to create an array of references from a list of paths provided as strings. It is important to provide the list as an javascript array. For instance: ["users/doc_id1","users/doc_id2","users/doc_id3"]
add to list add item to list add list list add	Tries to add a value or an array of values to a list field as texts. If the field was not of type array, it will be turned into one. Sample: ["text1"] or text1 will add "text1" to an array.
remove from list remove item from list remove list list remove	Tries to remove a value or an array of values form a list field. Sample: ["text1"] or text1 will remove "text1" to an array.
list add number add number to list add number list add list number	Tries to add a number or an array of number to a list field. If the field was not of type array, it will be turned into one. Sample: [123] or 123 will add the number 123 to an array.
list remove number remove number to list remove number list remove list number	Tries to remove a number or an array of number from a list field. Sample: [123] or 123 will remove the number 123 to an array.
list add date add date to list add date list add list date	Tries to add a date or an array of dates to a list field. If the field was not of type array, it will be turned into one. Sample: ["2024-02-21T00:00:000Z"] or 2024-02-21T00:00:000Z will add this date to an array.
list remove date remove date to list remove date list remove list date	Tries to remove a date or an array of dates from a list field. If the field was not of type array, it will be turned into one. Sample: ["2024-02-21T00:00:000Z"] or 2024-02-21T00:00:000Z will remove this date to an array.
list add map add map to list add map list add list map list add json add json to list add json list add list json	Tries to add a map / json or an array of maps / jsons to a list field. If the field was not of type array, it will be turned into one. Sample: [{"message":"Hello","id":1}] or {"message":"Hello","id":1} will add this json string as a map type to an array field.
list remove map remove map list remove list map list remove json remove json list remove list json	Tries to remove a map / json or an array of maps / jsons from a list field. If the field was not of type array, it will be turned into one. Sample: [{"message":"Hello","id":1}] or {"message":"Hello","id":1} will remove this json string as a map type to an array field.
list add reference add reference to list add reference list add list reference	Tries to convert a list of paths into a list of references to be added to a list field on a document. Sample: ["users/doc_id1", "users/doc_id2"] will be added to the list as 2 references to documents on the users collection.
list remove reference remove reference from list remove reference list remove list reference	Tries to convert a list of paths into a list of references to be removed from a list field on a document. Sample: ["users/doc_id1", "users/doc_id2"] will be removed from the list.
geopoint location geographic location	Tries to convert a latitude and longitude into a GeoPoint reference to be stored on Firestore. Sample: 40.6976312,-74.1444872 (lat,lng) will store a reference to New York on a GeoPoint type field.
delete delete field	Deleted a field from the JSON structure on the document. This tyep does not require any value. If one is given, it will be ignored.
increment	Increments a number field by the specified value. Sample 1: 2 will add 2 units to a numeric field. Sample 2: -1 will subtract 1 unit from a numeric field.