APPSHEET MANUAL

REGISTRY
Go to www.appsheet.com and log in with your google account.

CREATE THE DATA IN GOOGLE SPREADSHEET

- We enter Drive, create a folder, open it and inside it, click on new and click on
Google Spreadsheet. In the upper left corner click on "Untitled Spreadsheet" and
type in a name that will be the name of our Database.

- in the first row we write the headers of the columns to be used for the app.

CREATE A FOLDER IN DRIVE WHERE ALL THE CONTENT OF THE APP

WILL BE SAVED

We create a folder in Drive where all the content of the App will be stored.

PREPARE THE APPSHEET GOOGLE SPREADSHEET.

- We enter Drive, create a folder, open it and inside it, click on new and click on
Google Spreadsheet. In the upper left corner click on "Untitled Spreadsheet" and
type in a name that will be the name of our Database.

- in the first row we write the headers of the columns to be used for the app.

CREATE THE FIRST APP

We entered, to www.appsheet.com we began session, Click in Login, we selected Google
and we entered our mail and password with which we registered.

Click on "Make a New app" then select the option "Start with your own data".

Enter a name for the app "New App" and in category choose one, or choose "other" and
click on "choose your data".

- We search in Drive, our excel file that we created as "Google Spreadsheet".

ADJUST APP PROPERTIES

1. Click on Info, then click on Properties and display App Propperties.

2. In Short Name, we give a name to the APP
3. we can enter a description if we want. in Short Description
4. in Default app folder, we type the name of the folder that was previously created in
Drive and where the Google spreadsheet is located.

ADJUST THE APP IMAGE AND ICON

 1. Go to the UX user interface , then click on the Brand tab.
2. We can select a theme, a color
3. In App Logo, we place a logo, the dimension of the logo is (512*512)
4. In Style we can choose the style of the theme for the upper or lower part of the App.
5. WE ACTIVATE THE SHOW LOGO IN HEADER OPTION , so that the logo is shown.

ADJUST THE SYNCHRONIZATION MODES

Keep in mind that the database is in the cloud and so is the application and these must be
synchronized.
1. Click on Behavior, click on Offline/Sync.
2. We activate the option Sync on start (it allows that every time that the application is
started it will be synchronized, which assures us that the data that the application will
have are updated, very important when the app is in several users, so that they are
synchronized with the App.
3. Note that all three options must be active: Sync on start, Delayed sync and
Automatic updates.
4. Note, the option The app can start when offline, must be enabled when the Sync on
startoption is disabled, but if we enable the Sync on start option then the option The
app can start when offline must be disabled.

ADJUSTING THE EDITOR VIEW

It allows us to display the different lists, to save more time.
1. On the left side of the window, click on Menaje and in the Author tab, click on the
bottom part where it says Editor Settings, where the following is displayed:

We check the first option Expand all views?, and uncheck the second option that says Show
system actions?, click on Done, and the result will be as follows:
SET SECURITY (LOGIN)

It determines the behavior of our application,

1. To the left of the screen we click on Security, and in the tab Require Sign-In,
(it is so that the user enters to the application and it asks him to log in with its account
of mail) then we activate it in the case of not being activated.
2. Note. If the Allow all signed-in users option is enabled, then it will allow all
signed-in users to log in to the application with their email address.
Note, if we want to create a list of users that can open the application, then we
disable Allow all signed-in users, and in Users, in the User emails option, we can
add manually, the users' emails, and these will be the ones that will have access to the
application.

CONFIGURE TABLE SETTINGS

1. We go to Data and in the Tablet tab we add the tables.

2. We choose the options to update, edit, delete or read only. in the read-only option it
will not allow to add data and the view will be blank.

COPY THE APP LINKS

1. Click on Users and click on the Link tab

2. In Install Link you will find the link to install the APP in the cell phone.
3. In Browser Link you will find the link to view the App in any browser.

DATA OPTION
 TABLES
It is recommended that the tables or sheets of a ledger should always have a field in the first
column that contains the ID or main key of the table, this field should be unique and should
not allow duplicates. There must not be columns with the same name in the same table.

-By clicking on "Data" (left side of the window) we add the tables (excel sheets), which will
be shown in the App. and we observe to our right how our App is looking like, seen from the
cell phone. For example, if our spreadsheet had two sheets, one called "Students" and one
called "Payments", it would look like this:
- by clicking on one of the tables, for example on the "Student" table, we can select
whether this table can be (updated, added, deleted or read-only), usually Updates,
Adds and Deletes are active.

NOTE: if we want the plus "+" button to disappear in the application, it is because we
do not want to add data and this is achieved by deactivating the "Adds" option.

STORAGE

It is called storage, in it, we can see:

Source Path : the name of the book

Table Name: Which sheet we have selected

Worksheet Name/Qualifier: Which is the worksheet we have selected, where

our data comes from, which in this case is from Google,

Source ID: the route ID

Store for image and file: Images are being stored by default.

SECURITY

You see different options that restrict the information based on criteria, which we
specify by means of a condition. this condition would be written qui

for example if I wanted to see only the inspections that have been done today. Then we would have to say
that the date is equal to today.
 Scale

These are advanced options for part of payment plans

Localization

Shows which language or locale you have determined the table is in.
This is important, because our devices and the location of the application
must match so that there is no inconsistency in number and data
formats.

Documentation

Apsheet does not enable it, so that we can write any annotation, which is important if we work in a team, to
explain any decision we have taken and configured, so that the other people in the team understand what we
have done and why we have done it.

COLUMNS
Displays the fields of the table you select (the fields are the same column headings of a
given sheet). Here we can change the data type of the field and assign different properties.
by clicking on the pencil in the "Name" column we can make further modifications and enter
codes to the column's data type.
NAME

Corresponds to the column header name of our datasheet. but if we want the column to be
displayed with another name in the application view, then we can rename it but in the
"Display Name" option

TYPE

The type of column, for example some of the most used we have:

Some Examples of Column Types

Address for home addresses or residences. this address could be opened in Google
Map, by clicking on it.

Date For dates

Date Time for date and time

Text a single line of text. is also used for ID columns and for names

Long Text One or more lines of text

Number A whole number

Decimal real or decimal number

Percent: Percentage

Price monetary value or amount

Duration A period of time expressed in hours, minutes and seconds.

Change counter Shows how many times an entry has been edited
 Change Location It will be automatically populated with the current GPS location. sample
where the change was made

Change Timestamp shows when an entry was last edited.

Name For names of persons or things

Email Allows to write an Email and also allows to validate if it is correct.

Enum It allows you to create a list of options, for example if you want them to
choose a career from several offered. Here we can make the different
careers appear for the user to choose one. may appear in the form of a
button to be clicked.

Yes/No Question type fields, with a question mark at the end of the question.

Signature For signatures, or when it is necessary to draw strokes

Ref reference type field, refers to data from another table. Gives the relational
property to a column.

Enum Allows you to set several options to choose from. for example to choose
between the options Yes, No, I don 't know.

Enum List To choose multiple options

Enum field type to choose several options

DATE FIELD PROPERTIES

Once in "Columns" and after selecting the "Date" field, click on the pencil that appears
before the field name, and a window opens. click on "Auto Compute" then on "Initial
Value" click on the box where the sign (=) is shown, make sure that the "Time" tab is
selected and we can proceed to make the following changes:
 Display the current date: Insert Today()

Show the current time: Insert Time Now()

Display the date and time: Insert Now()

FIELD OPERATION REF

For example if we have two tables, one called Students and the other called Programs.

The main table will be the "Students" table but the first table to be filled in will be the
"Programs" table.

When we open the form that contains the table "Student" , and taking into account that the
ID is filled in automatically and that it is not displayed, then we type the names of the
student. table, and taking into account that the ID is filled in automatically and is not
displayed, then we write the names of the student, and for the program simply by clicking on
the program box the 4 programs will be displayed, which are in the "Programs" table where
we must choose one.

Table Students

Student ID Names Program Date of Birth

a01 Diego campos

a02 Luis Duque

a03 Maria Prieto

a04 Pedro Coral

Table Programs

Program ID Program Name Modality

p01 Systems On-site

p02 Pedagogy On-site

p03 English Virtual

p04 Accounting Virtual

In the "Students" table and in the "Program" field under "Type" we select "Ref" for this type
of field. click on the pencil (on the left side) and observe that in "Column Name" you select
the name of the column from which you want to select the program; in this case it is the
"Program" column of the "Students" table and in "Source Table" you select the table that
contains the column where you want to select the program; in this case it is the "Programs"
table or sheet.

FORMULA

Here we define which values will be displayed from the respective field, i.e. we can make
some kind of filter. for example, if we want the program column to show only the students of
the systems program.

SHOW

They determine which fields are displayed on the form.

INITIAL VALUE

Here, we can condition for a field to take a default initial value.

MAKE AN ID FIELD AUTOFILL IN THE FORM

In "Initial Value" of the ID field, we click and in the new window that appears we write
"UNIQUEID()" We must take into account that this field must be of type Text, so that this
field is not shown in the form, we deactivate the option "Show".

EDITABLE

If we deactivate this option, this field in the form cannot be edited.

REQUIRE

If enabled, it forces this field to be filled in the form.

DISPLAY NAME

Here, we can change the name of the field, if we want this name to be displayed in the form.

DESCRIPTION

WE CAN DESCRIBE, WHAT PROPERTIES WE ARE GIVING TO THIS COLUMN AND

WHY.

SEARCH

Allows you to search for a certain field if it is activated.

SCAN

Used to detect barcodes and QR codes

NFC

Technology that allows us to have the data when we bring the cell phone close to us.

IIP

It is used for sensitive data, which requires maximum protection.

 SLICES

It is used to create filters or snippets from a table.

CREATE A FILTER SHOWING PAYMENTS FOR THE CURRENT DATE

1. Click on Data and click on the Slices tab,

2. Click on New Slice, in Slice Name, enter a name for the filter and in Source Table
select the table to be filtered.
3. In Row filter condition, we write the expression or code of the filter, in our case we
write: = [Date] = TODAY()
4. In Slices Columns, we choose which columns we want to see
5. in Slice Actions, we can choose whether we want to delete or edit the slice; otherwise we
leave it Auto
6. In Update Mode, we can restrict the application to only update, update, delete, view or read-
only.
7. Now we click on the user interface which is the UX option, and in the View tab, we click on
New View, in View Name, we give it a name, which will be the one shown in the application
at the bottom.
8. In For This Data, we select the name of the filter that was previously created.
9. In view type we choose the example appearance Desk
10. In position we choose a position for the new view name
 UX OPTION
Allows you to modify the appearance or views of the App

TAB VIEWS

There are several types of menus:

Primary Views: we find the views that are displayed at the bottom of our application.
Menu Views: we find the views that we will find in the hamburger menu of the aPP.

PRIMARY VIEWS

Vews Type

The first 5 buttons at the bottom(left most- left - center and right most) correspond to the
App menus at the bottom. the menu button allows the selected menu of the APP (the ones
at the bottom of the APP) to be moved to the hamburger menu by clicking on the menu
button. The Ref button allows, if one of the menus at the bottom of the App is selected, to
hide it.

VIEW TYPES IN THE APP

Note: depending on the selected view, all the properties that can be modified to the
selected view will immediately appear at the bottom of the views.

We must clarify that we have three options, which are also shown at the bottom but
will be common to all views, such as: Display - Behavior and Documentation

deck : Allows to add images, and up to a second title in the APP and allows us, to
see the shortcut buttons such as edit, delete.

table: Displays the form arranged in table.

gallery: Show the images much larger with a title

detail : displays only one image and can be navigated from left to right

map : shows us a map depending on the location and address in the form.

chart : displays a chart of the chosen column. once you have clicked on chart,
several options are displayed and we choose the option Chart Columns and select
the column, so that the App displays the chart

dashboard : Very important. because it allows to see details of almost all the
tables, by means of modules, this option is viewing the App from the browser, not
from the cell phone. adding the options in View entries

GROUPING OR CATEGORIZING DATA

1. In the "DESK " view, in the Group By option, click on Add and choose
the field you want to group by.

SHOW SOME ACTION BUTTONS

2. Being in the "DESK " view in the Show Action Bar option, we activate it,
then in Actions we can select the action buttons we want to show. for
example, such as delete edit and others.

COUNTING GROUPED DATA

1. 1In the "DESK " view, in the Group aggregate option choose COUNT

CHOOSE THE FIELD NAMES TO BE DISPLAYED

1. In the "DESK " view, in the Primaryheader option and in the

Secondary header option, choose the fields to be displayed.

APPLY EVENT WHEN SWIPING TO THE RIGHT OR LEFT OF THE CELL

PHONE SCREEN

1. Being in the "DESK " view in the Behavior option, then in Event
Actions and in Row Swiped Left (beta) and Row Swiped Right (beta) we
choose what we want to happen when this event happens, for example
to make a call or to edit a data.

CHANGE THE IMAGE OR LOGO TO A MENU OF THE APP

3. Select the APP menu

4. Select the view
5. in the Display property and in Icon , we choose the image.

RENAME THE APP MENU

 6. Select the APP menu
7. Select the view
8. Select the Display property
9. In Display Name we write the new name between quotation marks

BEHAVIOR SECTION

Allows to choose a behavior of our view.

UX OPTION DETAIL VIEWS

EXAMPLE OF CHANGES IN THE DETAIL VIEW

1. InUX and in the View tab, copy or create a new view. In View Name we assign a
name for the view. and in For this data, select the table from which the view will
be created.
2. In View Type we choose the Detail view type, and in Positión we click on Ref,
so that this view is opened from another view.
3. in View Option under Main Image, select the image or photo from the table.
4. In Header Column, we can choose the name to be displayed over the image.
5. In Sort By we can choose the order in which the records will be moved to the sides.
for example we can place Name and Ascending
6. in Column order, we can choose which columns we want to display and in which
order. Here we simply add them
7. In Display mode we can choose a mode: automatic, normal, centered, without header
or side by side. We usually show it Centered, centered.
8. In Image style, allows you to change the style how the image looks like.
9. To activate or deactivate the scrolling of the image from right to left or vice versa we
modify Slideshow mode, usuallywe leave it active.
10. In Icon, we can apply an icon for the view, but if Ref is enabled, it does not justify placing an
icon as this view will not be visible.
11. In Display Name we can place a name or a formula that makes a change to it
12. In Show if, we can use a condition to make this view be shown or not shown.
13. The Quick edit columns option allows us, if there is a field that allows us to choose between
several options, for example an enum field. will not allow to show the options to be able to edit or choose
another option.
NOTE: This Detail View, as selected in Ref, is not displayed in the bottom menu, it is only
displayed when opening the main view which is in the Desk view type and contains the same table as
the Detail view. and by clicking on one of the students, you can then see this view in the App.

DECK VIEWS OF THE UX OPTION

Group by: allows the use of groupers, for example in the case of students we can group them
according to the program or course they are taking.

Group aggregate: Selecting Count allows us to count the students for each of the programs in
which they were grouped.

Main image: allows you to choose the main image to be displayed in this view, in our case it is
the student's photo.

Primary header: Allows you to choose a first field to display, in our case it will be the student's
name, it will be displayed after the photo on the right side.

Secondary header: Allows to choose a second field to display, in our case it will be the
student's document. to be displayed below the student's name

Summary column: Allows you to choose a third field to display, in our case it will be the cell
phone that will be displayed on the right side of the App.

Nested table column: is an additional table that allows us to display other data.

Image shape: Change the shape of the displayed image, it can be square, round, or large.

Show action bar: allows us to choose which buttons we want to show inside the App.

Actions: Here we add only the buttons to be displayed.

In Display in Icon: we add an icon for the App.

Display name: we can change the name under a formula or condition

Show if: to show or hide this view under a condition

Behavior / Event Actions: Here we find three events for the view which are:

Row Selected: When we click on the student's photo, it opens the Detail view, where we can see the fields
that were configured in that view.

Row Swiped Left (beta): When we slide to the left of the cell phone screen, we can give an action to
make a call, for example.
 Row Swiped Right (beta): That when we swipe to the right of the cell phone screen, we can give an action
example that we can edit the fields.

BRAND TAB
Here we find information related to the parameterization, the launch image logo, how our
bottom and top bar should look like.

Theme: change the background of the App to white background or black background

Primary Color: change the color of the text and image in the App menu at the bottom.

App Logo : change the application logo

Launch Image: allows you to set a background image to be displayed at startup or when
opening or synchronizing the APP.

Header and Footer :

Show view name in header: (shows the name of the table at the top ).

Show logo in header: (shows the logo in the header of the APP)

Hide menu and search buttons: (hides the search button, which is displayed at the
top of the APP).

Style: allows you to set a background color for the header area and the area where
the app menus are displayed at the bottom.
 FORMAT RULES TAB
Formatting rule, for example, if we want the column where the students are displayed not to
be represented in a special color.

OPTIONS TAB
Allows you to set a number of display options

LOCALIZE TAB
if we have our application for different countries in "Share" we can define which
name the Application will adopt depending on the country it is in

OPTION BEHAVIOR
Automation and behaviors. Here we define how our application behaves. There are buttons
that are automatically created in the application, such as the delete button, edit, send
message and others.

ACTIONS TAB

Show System Actions

If we click on " Show System Actions " it shows us a list of the actions that have been
automatically created in the APP, with virtual intelligence for each of the tables.

CHANGE THE APPEARANCE OF SOME ACTION BUTTONS

-Selectthe menu corresponding to the table at the bottom of the APP.

-In the central area click on the table to be modified.

-Click on the action button(Delete, Edit, messages).

- clicking on Appearance, the options to choose from are displayed.

Hide Action Button

Click on "Do not display".

Show automatically generated Action Buttons

Click on "Display prominently".

Change Action Button Behavior with Formula

-Click on Behavior

-Click on "Only if this condition is true" and after the equal sign (=) with a
click type the formula.

That the APP requests confirmation, in an Action Button.

We activate the option "Needs confirmation?"

Change the message displayed when a cli is born on the action

button
In Confirmation Message we write the text that we want to appear when the action
button is clicked.

Generate or Create a New Action

Example Action button, which allows you to change the data

value of a row in a certain column.

If from the Programs table, we want two action buttons, one called "With
discount" and the other called "Discount Denied".

When the "With discount" action button is clicked then once confirmed; the
Discount column of the Programs table will change to the value "Approved".

But if we click on the action button "Discount Denied" then once confirmed;
the Discount column of the Programs table, will change the value to
"Denied".

Steps: to create the action button "With

discount".
- 1. Click on the "New Action" button.
- 2. A new window is displayed,
- 3. In "Action Name", we write the name for the action button "
- 4. In the option "For a record of this table" we choose the table
- 5. In the "Do this " option we define what action we want it to perform. There
are 3 groups here:

The APP group allows you to create behaviors within the APP. that when
touching a button takes us to another part of the APP.

The DATA group allows you to make modifications to the data we currently
have.

The EXTERNAL group leads to parts that are outside the application.
 GROUPED, in this one we can chain several actions.

An example, if from the Programs table, we want two action buttons, one
called "With discount" and the other called "Discount Denied".

When the "With discount" action button is clicked then once confirmed; the
Discount column of the Programs table will change to the value "Approved".

But if we click on the action button "Discount Denied" then once confirmed;
the Discount column of the Programs table, will change the value to
"Denied".

- 6. In "Set these columns " we choose the row to which we want to change
the values and at the front we write = "True".
- 7. In Appearance, we write a name for the action button
- 8. In Action icon we select an icon for the action button
- 9. In Behavior in Needs confirmation we choose if it needs confirmation,
we activate and in Confirmation Message, we write a message for the
confirmation.
Steps: to create the action button "Discount
denied".
-1. Since an action button has already been created, similar to the same table
and the same column, then we make a copy of the action button "with
discount" and make some minimal changes like this:
 WORK FLOW TAB
Workflow, allows you to add different rules that trigger types of actions.
Example we are going to create a Work Flow, which allows that when a new record is
added in the Students table, and the Electricity program is chosen, the notification of this
student of the electricity program will be sent to an email of our choice.

STEPS FOR WORK FLOW MAIL NOTIFICATION

1. On the left side of the screen, click on Behavior and click on the Work Flow column.
2. click on New Workflow Rule
3. in Rule name we enter a name for the rule
4. click on When this happens... and in Target Data we choose the table
5. In Update event choose Update event choose ADDS-ONLY (means only when new
records are added)

6. Click on If this is true... and in Condition enter the formula (click, then click
on Columns, look for the column that in this case is programs and in front in
Inser click and complete the formula like this: [Program]="Electricity " ) and
click on save.
7. In Run these tasks... click on "New notification".
8. Make sure the Send an email button is checked and in the To option type
your email address
USERS OPTION
Users
User emails
Here we can send an invitation so that a friend or a user or a co-worker can install
the application we have created on their cell phone, or view it from the browser. You
will receive an email, through which you will click on a button, which will take you
from your cell phone to install APPSHEET, and then install the application or if it is
from the browser enter the application view in the browser.

LINK
Allows you to share a link by email or whatsapp, note if the link is sent, but we have
not registered the user can not enter

Install Link
Allows mobile device users to install the application on their device.

Browser Link
this link allows you to run the application directly from the browser.

Not Deployed
When our application is completely finished. enter here, and fill in the necessary information.
warnings appear, and the error that appears is that we do not have a payment plan, but still
 Apsheet allows. To launch the application click on the button "Move app to deployed state
despite errors".

PUBLISH THE APP IN THE PLAYSTORE

You must create an account in the publisher of android or IOS, and follow the normal procedure
to publish applications, in the case of publishing in the Playstore would have to activate the option
White label this app

zero to expert course

Zero to Expert Course

www.Tailorsheet.com/de-cero-a-experto

CONVERT THE TEXTS SHOWN IN ENGLISH TO SPANISH

 1. Once the application is open, click on the UX user interface , then click on the last
Localize tab.
2. Here we can customize the texts of our App. we can also use a formula, to change
the language, when the user requires it. But in this case we simply write the words in
Spanish and that's it. Note. Please note that there are some words reserved for
Appsheet. example "View".

https://www.facebook.com/HLApps.info/

Create a Speedometer/Gauge Dashboard

CREATING A COVER PAGE OR HOME TABLE
https://www.youtube.com/watch?v=cG_K3-1CcKY

1. In the Google spreadsheet, we create a new sheet, in my example I will call Home.
We create two columns, one ID and the other one Name. In the ID column we
write 1 and in the Name columnwe write the welcome text that will be shown
on the cover page. for example "Politècnico Tolimense".
2. in the App, we add the new table, by clicking on Data, Table tab and click on New
Table.we add it and leave it in Read-Only mode.
3. then in Column we make sure that Name is text.
4. We create a new view by clicking on UX and in the Views tab we add the view for
the Home table.
5. In Vew Name, we write a name for the view, in For This Data we select the start
table.
6. In View Type, select Detail and in Position select Center.
7. in Header Column we select the Name field, and in ColumnOrder wealso
choose the Name field.
8. Being in the UX user interface, and in the Options tab and Starting View
we select the Start table.

USE A VIRTUAL COLUMN TO CREATE A FILTER FOR

COUNTING RECORDS

1. Click on Data then on Column and choose the table, in our case we choose the
Home table.
 2. Click on Add virtual Column, in Column Name type Total Students,
then click on App Formula and enter the following formula:

to count all Records: COUNT(Alumnos[ID Alumno])

Where Alumnos is the name of the table where the students are located.
Where Student ID is the key or Id of the table Students

To count only students in systems: COUNT(FILTER(Students,

[Program]="bbc4d89a"))
Where Alumnos is the name of the table where the students are located.
Where Program is the column of the students table that contains the
programs.
Where bbc4d89a is the reference of the English programs, because in
this table a reference was used to call the programs from another table.

Note. If we want to show the two virtual columns that we have created
we do the following: we go to UX and in View we choose the Home
table and in the Column order option we add the two virtual columns,
so that they are displayed in the app.

ADD A GRAPHIC TO THE COVER PAGE OR HOME

TABLE
For this we use the url of a site such as https://quickchart.io/ which has a
variety of graphics to use.

The graph we will take as an example. en Radial Gauge / "Meter" Charts

therefore in the code that is shown in the web corresponding to this

graphic, we copy the code where the url starts.

- We create a new virtual column in our Home table, we name it

indicators and in App Formula, we paste the line of code from
the url that was copied.

"https://quickchart.io/chart?c={type:'radialGauge',data:{datasets:
[{data:[70],backgroundColor:'green'}]}}"
We modify the formula and replace [70] with [70 ].

in our application it will look like this

 Now click on Data, Column tab, choose the Home table

We observe that the virtual column indicators this text, then we change the text type
to Image and the result is that the graphic will be displayed in our App. so:

FORMULAS IN APPSHEET

To add up the different payments SUM(SELECT(Payments[Value],

made by a student: [Name]=[_THISROW].[Name]))

In the payments table we create a new Translation: Add, as long as you select from the
virtual column and in the formula box Payments table, in the Value column, and in the Name
we write: column, all payments that are equal or correspond to
this same name.
 Payments: Corresponds to the Payments table.

Value: corresponds to the Value column or field of the

payments table (where the payments made are
located).

Name: corresponds to the column or field Name of the

Payments table (here are the names of the students
who made the payments:
SELECT(Payments[Date],
Cascade search or apply multiple AND(
filters in one view.
OR(ISBLANK( [_THISROW].[Name]),[Name]=[_THISROW].[Name]),
https://www.youtube.com/watch?
OR(ISBLANK( [_THISROW].[Receipt]),[Receipt]=[_THISROW].[Receipt]),
v=qjfojNflIWU
OR(ISBLANK( [_THISROW].[Value]),[Value]=[_THISROW].[Value])
Allows you to perform several
searches for a specific record or )

student, selecting the fields you want )

to see.
Previously you had to create a sheet called, for
Dependent Dropdwn filters. example, Filter, in the Google sheet. And in the filto
sheet you create the columns you want to filter. It is
necessary a field that makes reference to the table
Payments in our example to that field we will call it Key
(that is where we want to filter) Being in our APP, in
Tables we create a new Table for the search or filter. In
Source Id we choose the name of the Google Sheet,
and in Worksheet Name/Qualifier we choose the Filter
column .

We edit the column to filter and in the Data Validity

optionand in Valid If we validate if a condition is met
andwrite the formula.

Note: We write this same formula in each of the columns to

be filtered. We only change the display name of the filtered
column

Formula for Administration of user

accounts.

Allows restrictions to be placed on

non-administrator users to manage the
App.

We must go to Users and in User emails,

we add the emails of the users, who will But if we have a lot of users, it would be annoying to do
manage our App. You will receive the link to it user by user, it would be better to do it taking into
our App in your email. But first we must place
the restrictions, for each user.
account their role. Thus:

In the lower part of the user window,

the user's role is created.
These are the values you can set and
their effects:

" READ_ONLY" Read only

"UPDATES_ONLY" Update only not create
"ADDS_ONLY" Add only, do not modify
"ADDS_AND_UPDATES " Add and update,
do not delete Data/Tables we choose and in Are updates
"DELETES_ONLY" Delete only
allowed? Click on the formula symbol and type the formula
"UPDATES_AND_DELETES" Update and
delete, do not add To restrict we go to data and depending on the table we
choose we can create the restriction. We can restrict
"ADDS_AND_DELETES" Add and delete, not what we want from the APP. For each user
update independently
"ALL_CHANGES" All changes As
USERROLE() only has two possibilities by
default (I think it can be extended) normally
you would give "Admin" all changes
"ALL_CHANGES" and "User" the one you
think is most appropriate.

FORMULA THAT MULTIPLIES THE VALUE OF A FIELD BY THE VALUE

OF ANOTHER FIELD IN THE SAME TABLE. AND THE RESULT IS
DISPLAYED IN THE VIEW.

Let's imagine the following tables: Products and Sales

Note that the Product column of the Sales table is a reference to the Products table. That is
to say that once we have entered the data in the Products table, we can make that from the
sales table, in the Product field of this table, the data of the Product table is called.

The Total Price column is required to be automatically calculated.

Then in Data/Columns of the sales table, we edit the Total Price and in the Auto
Compute / App formula option, we write the following formula:

[Quantity]*[Product][Price].

When we register a sale and enter the quantity and price, it automatically shows us the total
value, which cannot be edited.

When we add the quantity, which in this case is

Here we would add a new sale and note that the
1, the total value is automatically displayed
total price is zero.
which is 10
 READ INFORMATION FROM ANOTHER TABLE THROUGH A REF FIELD

SHOW THE DETAIL OF A COLUMN IN THE APP

IF, we want to show the detail of a product (its price and unit), at the moment of making the sale. We
do.

1. In Data/Column we choose the table Sales, and add a virtual column

2. In Column Name we write, Product Detail and in App Formula we write the following
formula:

"price: $" & [Product].[Price] & "per " & [product].[Unit].

Note: [product] is the ref type field of the Sales table.

When adding a sale, let's observe that

at the end the information of the virtual
column is shown

To move the product detail information,

just after the product. We do:

We go to the views, at the bottom of the App, an auto generated view is shown,
"sales_Form", we click on it, these are system views that are hidden and to see them, in
UX/Views in the lower part we click on Hide system Views, clicking on the table
Sales_Form we proceed to make a copy; we change the name to the view
and in the option Column Order we change the order of the columns.

FORMULAS VIDEOS

AppSheet Database Lesson 6: Micra Stationery part

4 WhatsApp Message
https://www.youtube.com/watch?v=ihWEdu8Cd28

youtube video
AppSheet Tutorial 2021 - 05. Relationships between tables

https://translate.google.es/translate?hl=es&sl=en&tl=es&u=https%3A%2F
%2Fhelp.appsheet.com%2Fen%2Farticles%2F1013271-column-types-diving-
deeper&prev=search