Binders

This application helps you to organize and share your data.

No account, no subscription, no ads.

Your data privacy is respected.

Support is available 7-days-a-week.

Each binder is a database.

You can create as many binders as you like.

Look at the examples and how they work.

If you don't find a simple solution, contact us.

Backup your binders regularly.

The binders are deleted if the application is uninstalled.

The desktop application is available on the Web site.

A binder can have many form types.

Form types

The forms are configured by their type.

You can modify the form types as you like.

Fields

You can add and modify as many fields as you like.

Each field has type of value or of form.

To contain many values, you can create a subform for each value.

To avoid writing the same value many times, you can create a form which contains this value.

Constant value

Can be used as a default value for a field.

Field from the current form

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from the previous form

The result is the last field of the path from the previous form.

The sort is required to calculate the previous form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Case from a number

The result is the cases from a number.

Requires a single value.

Condition

The result is the first term if the condition is true otherwise the second term.

Alternative value

The result is the first term else the second term and so on.

Number

You can configure a default value with a calculation.

You can configure a maximum value to modify the field size.

You can use a slider bar for integer numbers with minimum and maximum values.

Available functions

Constant value

The result is the value.

Can be used as a default value for a field.

Field from the current form

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from the previous form

The result is the last field of the path from the previous form.

The sort is required to calculate the previous form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Number of forms

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Number of all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Rounded value

The result is the rounded number according to the precision and the mode.

Text value

The result is the numeric value from a text.

Requires a single value.

Date value

The result is the numeric value from a date.

Minutes between two dates

The result is the number of minutes between two dates.

Returns an integer number.

Days between two dates

The result is the number of days between two dates.

Returns an integer number.

Months between two dates

The result is the number of months between two dates.

Returns an integer number.

Years between two dates

The result is the number of years between two dates.

Returns an integer number.

Days of a duration

The result is the number of days of a duration.

Returns a number with decimals.

Hours of a duration

The result is the number of hours of a duration.

Returns a number with decimals.

Latitude

The result is the latitude of a GPS position.

Requires a single value.

Longitude

The result is the longitude of a GPS position.

Requires a single value.

Distance between two GPS positions

The result is the distance between two GPS positions.

Returns a number in meters.

Text length

The result is the length of the text.

Text position

The result is the position of the second term in the first term.

Uppercase letters are ignored.

Returns a number from 0.

Case constant value

The result is the case constant value.

Number of cases

The result is the number of cases.

Form identification code

The result is the form identification code.

Random number

The result is a random number.

The value always changes if the field is not configured to keep it.

Power

The result is the power of a number.

Square root

The result is the square root of a number.

Requires a single value.

Pi

The result is the Pi constant.

Sine

The result is the sine of a number.

Requires a single value.

Cosine

The result is the cosine of a number.

Requires a single value.

Exponential

The result is the Euler's number e raised to the power of a number.

Requires a single value.

Logarithm

The result is the logarithm of a number.

Requires a single value.

Opposite number

The result is the opposite number.

Requires a single value.

Inverse number

The result is the inverse number.

Requires a single value.

Operations

The result is the calculated value.

If a term has many values, they are summed.

You can use some hidden fields for intermediate results.

You can use some next functions for parenthesis.

Addition

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Subtraction

The result is the calculated value.

Requires two values.

You can use some hidden fields for intermediate results.

Multiplication

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Division

The result is the calculated value.

Requires two values.

You can use some hidden fields for intermediate results.

Minimum

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Maximum

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Average

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Increase

The result is the value plus the percentage.

Decrease

The result is the value minus the percentage.

Difference

The result is the percentage between the values.

Weather temperature

The result is a number.

This Google service is deprecated.

Condition

The result is the first term if the condition is true otherwise the second term.

Alternative value

The result is the first term else the second term and so on.

Text

Use a text if no other field is appropriate.

You can configure a default value with a calculation.

Constant value

The result is the value.

Can be used as a default value for a field.

Field from the current form

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from the previous form

The result is the last field of the path from the previous form.

The sort is required to calculate the previous form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Random

The result is a randomly generated password.

Number

The result is a number converted as text.

Date

The result is a date converted as text.

ISO date

The result is the date converted to ISO text.

Week day

The result is the day of the date.

Spelled number

The result is a text.

You can enter dollar, cent, 100.

Text part

The result is the part of a text.

Returns the first character if begin=0 and end=1.

Concatenation

The result is the gathered texts.

Multilingual text

The result is a multilingual text converted as text.

System variable

The result is the system variable value.

Weather conditions

The result is a text.

This Google service is deprecated.

Condition

The result is the first term if the condition is true otherwise the second term.

Alternative value

The result is the first term else the second term and so on.

Shortcut type

You can configure a shortcut type to open an external application.

You can install ZXing to scan all barcodes.

You can use a cloud storage for your documents (PDFs, images) and access them with a shortcut.

On Android, the file path depends on the chosen application (file:///storage/… content:/com.android.providers…).

Android security severely limits access to files.

You can fill some forms from some file paths.

You can use a shared reference to navigate between the forms with the same value.

Constant value

The result is the value.

Can be used as a default value for a field.

Field from the current form

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from the previous form

The result is the last field of the path from the previous form.

The sort is required to calculate the previous form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Condition

The result is the first term if the condition is true otherwise the second term.

Alternative value

The result is the first term else the second term and so on.

Constant value

The result is the value.

Can be used as a default value for a field.

Field from the current form

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from the previous form

The result is the last field of the path from the previous form.

The sort is required to calculate the previous form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Now

The result is the current date.

You can configure the calculation with “calculated and stored”.

Mixed date

The result is the date from some numbers.

The default date is now.

Binder last change

The result is the binder last modification date.

Form last change

The result is the form last modification date.

Form creation

The result is the form creation date.

Addition

The result is the date plus the duration.

Subtraction

The result is the date minus the duration.

Minimum

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Maximum

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Condition

The result is the first term if the condition is true otherwise the second term.

Alternative value

The result is the first term else the second term and so on.

Constant value

The result is the value.

Can be used as a default value for a field.

Field from the current form

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from the previous form

The result is the last field of the path from the previous form.

The sort is required to calculate the previous form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Between two dates

The result is the seconds between two dates.

Always positive.

Addition

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Subtraction

The result is the calculated value.

Requires two values.

You can use some hidden fields for intermediate results.

Multiplication

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Division

The result is the calculated value.

Requires two values.

You can use some hidden fields for intermediate results.

Minimum

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Maximum

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Average

The result is the calculated value.

Requires at least one value.

You can use some hidden fields for intermediate results.

Condition

The result is the first term if the condition is true otherwise the second term.

Alternative value

The result is the first term else the second term and so on.

Picture

The default picture width is 600 pixels.

10 pictures take about 1.0Mb.

You can reduce the storage size.

Constant value

The result is the value.

Can be used as a default value for a field.

Field from the current form

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from the previous form

The result is the last field of the path from the previous form.

The sort is required to calculate the previous form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Condition

The result is the first term if the condition is true otherwise the second term.

Alternative value

The result is the first term else the second term and so on.

GPS position

The precision is 6 decimals (11 cm).

You can export a GPX file from a binder.

Constant value

The result is the value.

Can be used as a default value for a field.

Field from the current form

The result is the last field of the path from the current form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from the previous form

The result is the last field of the path from the previous form.

The sort is required to calculate the previous form.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Field from all forms

The result is the last field of the path from all forms of a given type.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Here

The result is the current location.

You can configure the calculation with “calculated and stored”.

Condition

The result is the first term if the condition is true otherwise the second term.

Available functions

Constant value

The result is the value.

Can be used as a default value for a field.

Empty field

The result is true if the field is empty.

Current form possibility equal

The result is true if both possibilities are the same.

If a field is empty, the calculation is ignored.

The forms can be filtered.

Contains text

The result is true if the terms match.

Strong password

The result is true if the value is a strong password (at least one digit, one sign, one uppercase letter, one lowercase letter).

Week day

The result is true if the date is one of the days.

Date before

The result is true if the first date is before the second date.

Current form equal

The result is true if a form is the same as the calculation.

Current form subtype equal

The result is true according to form subtype.

Not

The result is true if the term is false.

Requires a single value.

And

The result is true if both terms are true.

The result is true if no terms is false.

Or

The result is true if no terms is false.

Number equal

The result is true if the comparison is true.

Requires two values.

Number different

The result is true if the comparison is true.

Requires two values.

Number greater

The result is true if the comparison is true.

Requires two values.

Number greater or equal

The result is true if the comparison is true.

Requires two values.

Number lower

The result is true if the comparison is true.

Requires two values.

Number lower or equal

The result is true if the comparison is true.

Requires two values.

Comparison

The result is true if the comparison is true.

Requires two values.

Date equal

The result is true if the comparison is true.

Requires two values.

Date different

The result is true if the comparison is true.

Requires two values.

Date later

The result is true if the comparison is true.

Requires two values.

Date later or equal

The result is true if the comparison is true.

Requires two values.

Date sooner

The result is true if the comparison is true.

Requires two values.

Date sooner or equal

The result is true if the comparison is true.

Requires two values.

Comparison

The result is true if the comparison is true.

Requires two values.

Duration equal

The result is true if the comparison is true.

Requires two values.

Duration different

The result is true if the comparison is true.

Requires two values.

Duration longer

The result is true if the comparison is true.

Requires two values.

Duration longer or equal

The result is true if the comparison is true.

Requires two values.

Duration shorter

The result is true if the comparison is true.

Requires two values.

Duration shorter or equal

The result is true if the comparison is true.

Requires two values.

Comparison

The result is true if the comparison is true.

Requires two values.

Alternative value

The result is the first term else the second term and so on.

Alternative value

The result is the first term else the second term and so on.

Calculation types

● The field value is entered else calculated: result or default value (Common case).

● The field value is calculated and stored: during the form creation.

● The field value is calculated on demand: recalculation button.

● The field value is calculated else entered: remplacement value (Rare case).

Many values

To contain many pictures, you can add a field with many forms that each contains a picture.

Converted field

You can add a field from a form field.

Some conversions are not reversible.

From a linked form

You can move a field from a linked form.

Sort order

The sort order is used to compare two forms and calculate which one to displayed first.

You can choose the user order to sort the forms manually.

You can choose “no sort” for a faster display.

Editor

You can display a list of forms in its own page.

You can hide a form type from search list.

You can modify a form in the list of forms.

Form subtypes

You can distinguish some forms of same type.

For example, you can create a form with Person type and Man or Woman subtype.

Form parts

You can group some fields in a page.

Validation rules

You can configure some validation rules to check if a form is valid or not.

Organization

You can create and link your forms just as on a diagram.

For instance, an address is linked to a city which is linked to a country.

You can configure forms to belong to others.

The linked forms can then be automatically deleted.

If you hesitate between a possibility field and some form subtypes.

● Use a possibility field to set a form state that can change.

● Use some form subtypes to choose when the form is created.

Relational databases

Unlike a relational database, you don't have here to manage keys and joins.

You can organize your data naturally with multiple links between forms.

It's a design tool which works with real data.

You can also use powerful features as cascade deletion, table inheritance, validation rules, constraints and calculated fields.

Forms

The forms can be linked by some linked forms fields.

Both form types have a linked form field towards the other.

You can configure which forms can be added.

Display

You can enter a category to gather many binders.

A form can have many fields but can hide some of them.

The fields can be hidden in several ways.

● Hidden from the form summary.

● Configured as rarely used.

● Using a form part.

● Using some form subtypes.

Deletion

Your data can be deleted in several ways.

● When you clean a field.

● When you delete a form.

● If a form is configured to be deleted if a field is empty.

You can retrieve some deleted forms.

Validation

The validation helps you to manage missing or incoherent data.

Your data can be validated in several ways.

● A field which warns if empty.

● A field which warns if its numeric value is out of bounds.

● A form type with some validation rules.

Binder size

You can check the binder size on the binder settings.

You can use “Clear history” to reduce the binder size.

Performance

A list of forms is displayed faster with the “no sort” option.

Some calculations can sped up with the “calculated and stored” option.

Import

Your data can be imported in several ways.

● From a CSV file.

● From a XML file.

You can configure the fields to create and fill.

You can configure some fields to match instead of adding forms every import.

You can export the existing forms to import some new ones with the right format.

You can configure a column to link a new form to an existing form.

For example, to import a Customers file and a Assets file, import the Customers with a number field for the Customer code column then import the Assets with a form field for the Asset's Client code column.

Export

Your data can be exported in several ways.

● To a GNBP file (binder).

● To a PDF file.

● To a CSV file.

● To a XML file.

● To a JSON file.

● To a GPX file if there's some GPS positions.

CSV is a limited format which contains less data than the binder.

PDF export

If the columns are not large enough, you can hide or reduce some other columns.

You can configure some column names or some maximums.

Adobe PDF standard files don't support asian fonts.

WordML DOC files require Word.

Calendar export

You can export all forms with a date to a calendar.

The calendar is summarySeparated from the others and read-only.

If the calendar application has issues (Xperia), use another one (Google).

Period

The period is used for searching, filtering and exporting to calendar.

Android Intent

You can add or read form data using an Android Intent.

The field values are similar to the CSV columns.

You can also use a single parameter "line"="key=value key=value ...".

To read the nearest form from a given location.

"command"="exportForm", "binder"="world atlas", "formType"="country", "sortField"="capital coordinates", "sortDirection"="near", "sortLatitude"="48.878431", "sortLongitude"="2.364428".

To add a form.

"command"="importForm", "binder"="world atlas", "formType"="continent", "name"="atlantis".

Command line

You can export a binder to XML file using a command line.

--command="exportBinderXML" --binder="world atlas" --folder="C:\".

Synchronization

It is important to keep backup copies.

Your binders can be synchronized with many folders.

Only the newest version of each binder is stored.

The binders are never deleted during synchronization.

A “Generism” folder is created to store the binders on the Cloud folder.

Each binder is stored in a file named like binder1.gnbp.

Don't rename these files, they are automatically generated.

If you are having problems, check files with your Cloud application.

Between a device and a computer

1 - If there is no cloud folder in the computer file explorer, install the cloud application.

Configure the cloud application if there is no cloud folder in the file explorer.

2 - Add a binder on the device.

3 - Synchronize on the device.

4 - Wait for the cloud update.

5 - Go with the the file explorer in “Generism” cloud subfolder.

6 - Run “Binders.bat”.

7 - Modify the binders on the computer.

8 - Wait for the cloud update.

9 - Synchronize on the device.

Between two devices

1 - Add a binder on the device A.

2 - Synchronize on the device A.

3 - Wait for the cloud update.

4 - Synchronize on the device B.

5 - Modify the binders on the device B.

6 - Synchronize on the device B.

7 - Wait for the cloud update.

8 - Synchronize on the device A.

Copyright © 2013-2019 Generism. All Rights Reserved.