<aside> 💡

Use this guide to get the most out of Squarid

</aside>

<aside> ⚠️

Squarid is in Preview. Features may be limited, unstable, or unavailable, and service outages may occur. The product is provided as is, without warranties. Nevertheless, contact Support 🛟 to make some exceptions if needed.

</aside>

Introduction 🎉

Build apps with AI. Squarid help you build apps instantly considering the pillars of your needs.

Build apps tailored to your needs instantly: Create powerful table-based applications that provide instant solutions to repetitive business and personal challenges. Empower yourself to streamline processes, boost productivity, and tackle everyday problems with ease, all while enhancing efficiency and saving time.
Configure fine-grained roles and permissions: Set highly granular roles and permissions with row-level and column-level control across create, read, update, and delete actions. Unlike traditional spreadsheets that are accessible to anyone, this service ensures secure, tailored access for every user, enhancing data privacy and control.
Set up powerful logic and workflows with code and no-code: Create powerful workflows using JavaScript functions, or leverage generative AI to build them without any coding. Easily filter rows, validate the table, trigger actions, and more, streamlining processes and enhancing automation for users of all skill levels.
Data in the cloud for quick access and reliable storage: Store your data securely in the cloud for seamless scalability, with easy options to import and export previous data. Powered by AWS technology, the platform guarantees top-notch resiliency, availability, reliability, and robust security to protect your data and ensure optimal performance.

Access to App

Squarid

Presentation

Video
Deck

www.dev.squarid.com

Feature Highlights

Squarid is not just any other table-based SaaS. Find its highlights below:

Capability	Other SaaS	Squarid
Core focus	❎ Data management	✅ App building
AI usage	❎ Assistive (formulas, text)	✅ Generative (apps, logic)
App creation	❎ Manual	✅ AI-driven, Template or Manual
Permissions	❎ Column-level	✅ Row- and Column-level
Permission-aware logic	❎ Not in all contexts, usually no test mode	✅ In UI and API, with Test Mode
Roles	❎ Limited	✅ With filtering
Programming language support	❎ Proprietary languages	✅ Standardized language: JavaScript
AI-generated / no-code workflows	❎ Limited	✅ From text to code for further tuning
Scope for workflows	❎ Usually row only data	✅ All table data
Change history	❎ Limited, usually not enough information	✅ Cell-level and configuration tracking

Support 🛟

Use the folllowing channels to get support:

Support Case 📋 · Fill out a quick Form
Support Meeting 📆 · Book a 30-minute slot
Contact Email ✉️ · support@squarid.com

What is a Table? 🧑‍💻

When you create a table in Squarid you have the foundation blocks to build your application. A table is composed of:

Columns 📊 : They are the fields made available to all users to record all the data.
Roles 👤 : They allow you to distinguish between users and grant them different permissions.
Views 👁️ : Bring attention to what matters with customized table-based views.
Actions 🎬 : Forget about repetitive procedures and automate table-based actions with one-click action which also support custom inputs.
Notifications 🔔 : Get custom alerts based on specific contentions with row-based and time-based events.

Columns 📊

Data types

The following table describes the different data types for columns available:

<aside> ✍️ Up to 20 different columns can be configured at the moment. Use AI to start with an initial proposal of columns.

</aside>

Type	Description
string	Any text entered. It can be short or long text (up to 512 characters instead of 128 characters)
number	Any number entered. The number of decimals shown can be selected.
boolean	Either ‘true’ or ‘false’, shown as ‘Yes’ or ‘No’.
datetime	Local datetime. It can be date or date+time. Date will be shown as if it were local (no time zone is saved).
formula	JavaScript function named `calculate()` which makes calculations based on other row values and the value returned is shown - see ‣.
link	URL link with display name.
dropdown	Set of options of which one can be selected.

Column type changes

When changing a column from one type to another:

FROM ⬇️ / TO ➡️	string	number	boolean	datetime	formula	link	dropdown
string	-	Values which cannot be converted into number will be null	Only “true” will be true	The date will be shown as “Invalid date” if the format is not recognized with the Date() constructor	OK	If the format is not “<DISPLAY NAME>	<URL ADDRESS>”, then only the display name is taken as the string and no link is set
number	OK	-	Always false	As recognized with Date() constructor	OK	If the format is not “<DISPLAY NAME>	<URL ADDRESS>”, then only the display name is taken as the string and no link is set
boolean	As “true” or “false”	Null	-	Shown as “Invalid Date”	OK	If the format is not “<DISPLAY NAME>	<URL ADDRESS>”, then only the display name is taken as the string and no link is set
datetime	As “AAAA-MM-DDTHH:MM”		Always false	-	OK	If the format is not “<DISPLAY NAME>	<URL ADDRESS>”, then only the display name is taken as the string and no link is set
formula	Null	Null	Null	Null	-	Null	Null
link	As “<DISPLAY NAME>	<URL ADDRESS>”	Null	Always false	Shown as “Invalid Date”	OK	-
dropdown	OK	Values which cannot be converted into number will be null	Only “true” will be true	The date will be shown as “Invalid date” if the format is not recognized with the Date() constructor	OK	If the format is not “<DISPLAY NAME>	<URL ADDRESS>”, then only the display name is taken as the string and no link is set

Roles 👤

<aside> ✍️ Up to 20 different roles can be configured at the moment. Use AI to start with an initial proposal of roles.

</aside>

Default roles

By default, there are two roles available which cannot be deleted:

Owner: All permissions (the one automatically assigned to the user who creates the new table). Settings for the table are allowed to be edited.
Anonymous: No permissions (by default, but can be changed). This role will be automatically assigned to the users which do not belong to any other role.

<aside> ✍️ Only the tables created or starred by the user are shown in the dashboard, even when the user is added as an owner of the table.

</aside>

Users

You need to explicitly add the user emails to the roles. Note:

Users need to authenticate themselves using their email, which must match the one configured if so desired.
Only one role can be assigned at a time. Consider creating additional roles when intersection of permissions are needed.
The Anonymous role is automatically assigned to users which do not belong to any other role.

Permissions

For each role, the following permissions can be configured:

Create: column-level (uncheck all rows to block new rows)
Read: column-level (uncheck all rows to hide the entire row)
Update: column-level (uncheck all rows to prevent any modifications)
Delete: row-level (applies globally)
Filter: row-level (via JavaScript function named filter(), only applies to the read operation) - see Function filter() in Roles

<aside> ✍️ Although the filter only applies to the read operation, you can limit the user’s ability to create, update and delete rows in the validate() function of the table - see Function validate() in Table.

</aside>

Views 👁️

<aside> ✍️ Up to 10 different views can be configured at the moment.

</aside>

View

Title of the view being configured.

Description

Brief description of the view being configured.

Filter (row-level)

Filter the rows which need to be shown in the view - see Function filter() in Views.

Filter (column-level)

Select the columns which will be shown in the view and its ordering.

The open eye indicates the column will be visible while the closed eye indicates the column will be invisible.
Drag an drop the visible columns to reorder them (drag a column name and drop it on another column name to change their order).
Note this filter is applied after the filter configured for the role assigned to the user.

<aside> ✍️ Note that role filtering is applied before view filtering: (1) by row - role [filter()], (2) by row - view [filter()], (3) by column - role [permissions → read], (4) by column - view [fields].

</aside>

Actions 🎬

<aside> ✍️ Up to 10 different actions can be configured at the moment.

</aside>

Action

Title of the action being configured.

Introduction 🎉

Access to App

Presentation

Feature Highlights

Support 🛟

What is a Table? 🧑‍💻

Columns 📊

Data types

Column type changes

Roles 👤

Default roles

Users

Permissions

Views 👁️

View

Description

Filter (row-level)

Filter (column-level)

Actions 🎬

Action

Notifications 🔔

Function `filter()` in Roles

Function `filter()` in Views

Function `validate()` in Table

Introduction 🎉

Access to App

Presentation

Feature Highlights

Support 🛟

What is a Table? 🧑‍💻

Columns 📊

Data types

Column type changes

Roles 👤

Default roles

Users

Permissions

Views 👁️

View

Description

Filter (row-level)

Filter (column-level)

Actions 🎬

Action

Notifications 🔔

Function filter() in Roles

Function filter() in Views

Function validate() in Table

Function `filter()` in Roles

Function `filter()` in Views

Function `validate()` in Table