Zeroqode Toolbox

Introduction

This free plugin is a list of tools for working with bubbles. It enables you to Run JavaScript code as well as Generate JSON objects with relevant data for doing an easy search inside your DataBase.
Imagine you have an app with stores and you'd like to find orders made in them in a radius of 100 km. This plugin helps lightly filter the information you need by keyword and location. Additionally, it helps you to capture errors from the console logs from your app.
INSTRUCTIONS:
The plugin comes with four elements: CustomJS, Search, Error Capture, and Parse XML.
  • Use the Custom JS element and its action "Run js CustomJS" to initialize your custom javascript. 
  • Use the second element- Search and its action "Get Data From a Search" for a search for values by a given key from the database and generate a JSON file. With an extended action filter and you can find any information, you need from the database table. 
  • Use the third element - Error Capture to capture errors from the console in your app. 
  • Use "Parse XML" element to display the XML content into Repeating Group. 

How to setup

The plugin comes with four elements: CustomJS, Search, Error Capture, and Parse XML.

Custom JS element.

This element initializes your custom javascript. 

Actions

Image without caption

Fields

Title
Description
Return a list
If you want to return a list in the states, enable the checkbox
Code js
When you want a state to be returned it is necessary to call the function "zeroQodeExportDateinState function (ValuForState)". 

Events

Event name
Triggered when
Custom JS Completed
This event is triggered when JS has run successfully.
Custom JS Error
This event is triggered when your script returned an error.

Exposed states

State title
State value
Return your value
if you returned a single value, it will be contained here.
Return your list with values 
if you returned a list of values, it will be contained here.

Search element

This element is used for a search for values by a given key from the database on the backend side and generates a JSON file. 
Image without caption
Fileds:
Title
Description
Type of Content
Set here the data type that belongs to the plugin (Bubble search result).

Actions

Get Data from Search - it is an action that will return data from the database according to the constraints that will be set by you.
Image without caption
Image without caption
Title 
Description
Object Type
select the object you want to search
Selected fields
write the name of the fields you want to receive.
Key
This is the name of the field to which the constraint applies. You can also use the reserved key _all for full-text database searches.
Constraint_type 
This is the type of constraint you want to apply. It can be: 1. equals or not equal use to test strict equality, for all field types. 2. is_empty or is_not_empty use to test whether a thing's given field is empty or not, for all field types. 3. text contains or not text contains Use to test whether a text field contains a string, for text fields only. 4. greater than or less than use to compare a thing's field value relative to a string or number, for text, number, and date fields. 5. in or not in use to test whether a thing's field is in a list or not, for all field types. 6. contains or not contains Use to test whether a list field contains an entry or not, for list fields only. 7. empty or not empty use to test whether a list field is empty or not, for list fields only. 8. geographic_search Use to test if the current thing is within a radius from a central address. To use this, the value sent with the constraint must have an address and a range.
Value 
This is the value against which the constraint should be compared. This can be a string, a number, a list, and so on, depending on the type of field defined by the key in the current constraint. If the value type is invalid, Bubble returns a 400, "INVALID_DATA" error. The value must be at least 5 characters.A particular case of a key of type address and a constraint_type set to geographic_search, the value should be an object with the following keys
Origin_address
The central address that defines the center of the search, should be a string address.
Range
The range of the radius, is defined in miles or kilometers, depending on the unit.
Unit
The unit to use for the search. It can be miles (default) or km. Constraints with an undefined value are ignored. Do not use '_id' as a key for a constraint. Instead, use the call that retrieves a thing by ID. You can control how the list is sorted using two parameters:  sort_field and descending
Sort field
Specify the field to use for sorting.
Descending
This parameter can either be true or false (default).
Download JSON
enable checkbox if you want to download the JSON file.
File Name
JSON file name

Eхposes States

State title 
State value
Result
Contains lists of data grouped by user-defined field names. For instance, If you set the Selected fields to be Types, description, geographic_search, number then in the Result Bubble Object state, you'll have access to the aforementioned fields in this fashion: field1 to get Types, field2 for description, and so on ... Each of these fields is a list of values from your Bubble object. So, field1 # 1 is the first name item from your Bubble object, field1 # 2 is the second one, and so on ...

Parse XML

This element will help you to display the XML template in a repeat group.

Actions

Convert Parse XML- this action will help you display an XML in the Repeating Group.
Image without caption
Fields
Title 
Description
XML Content 
enter the XML content.
Selected fields
select the fields you want to get from XML.

Exposes States

State Title
State Value
Result
Contains lists of data grouped by user-defined field names. For instance, If you set the Selected fields to be, then, in the Result Bubble Object state, you'll have access to the aforementioned fields in this fashion: field1 to get name, field2 for price, and so on ... Each of these fields is a list of values from your XML. So, field1 # 1 is the first name item from your XML, field1 # 2 is the second one, and so on ...

Send XML/JSON data to API backend workflows

If you need to save a JSON or XML to the database, create "backend workflows in the API", setting in the action of the URL plug that leads to endpoints created on the backend and the XML / JSON content
Image without caption
Image without caption
After the call has been successfully initialized, delete the word initialize.

Changelogs

Update 19.02.2022 - Version 1.8.0

  • fixed problem with search a big list  

Update 21.03.2022 - Version 1.9.0

  • Minor update

Update 09.05.2022 - Version 1.10.0

  • Fixed the “selected fields” feature

Update 16.05.2022 - Version 1.11.0

  • The possibility to fetch an object’s relations with other object, based on IDs in its fields

Update 23.05.2022 - Version 1.12.0

  • Fixed problem with repeating data

Update 24.05.2022 - Version 1.13.0

  • Fixed problem with repeating data

Update 03.11.2022 - Version 1.14.0

  • Was deprecated error capture element

Update 21.02.2023 - Version 1.15.0

  • Updated description

Update 21.02.2023 - Version 1.16.0

  • Updated description

Update 21.02.2023 - Version 1.17.0

  • Updated description

Update 21.02.2023 - Version 1.18.0

  • Updated description

Update 21.02.2023 - Version 1.19.0

  • Updated description

Update 21.02.2023 - Version 1.20.0

  • Updated description

Update 19.06.2023 - Version 1.21.0

  • Updated description

Update 12.07.2023 - Version 1.23.0

  • Updated description

Update 29.08.2023 - Version 1.24.0

  • Updated description and instructions

Update 12.09.2023 - Version 1.25.0

  • Internal update

Update 12.09.2023 - Version 1.26.0

  • Minor updates

Update 02.11.2023 - Version 1.29.0

  • Minor fixes element 'Custom JS’

Demo to preview the settings