How to use table row binding?

In this tutorial you will learn how to use table row binding.

 

1.List

Let's start with creating a new list. It will be a list of products regularly bought by some company. If you do not want to create your own list you can copy the one from the table below.

paper towel 6 for kitchen use
case of milk 10 food
pack of water 5 food
sugar 1 kg 3 food
pen 4 office supplies
pencil 2 office supplies
marker- 3 colors 9 office supplies
washing-up liquid 8 for kitchen use
printer cartridge 30 other
pack of batteries 11 other
liquid soap 7 for kitchen use

Screen_Shot_09-21-18_at_04.49_PM.PNG

 

2.Binding with the list

2.a

Create a new app. Add a table widget and bind it and its columns with the list.

Screen_Shot_09-21-18_at_04.51_PM.PNG

2.b

We would want to be able to add number and calculate price for that number of products. Add two columns with type: number and currency. The 'number' column set as editable.

2.c

Change headers to: product name, price, category, number (x) and price for x products. In the last column put a formula that will calculate the price for a chosen amount of products:

Screen_Shot_09-21-18_at_04.57_PM.PNG

Now see what our app does by clicking 'preview'.

Screen_Shot_09-21-18_at_04.59_PM.PNG

The table shows all products from the list. Of course we could view products of only certain category or price by using the lookup formula in 'Filter' field. 

But what if we wanted to view different products that don't have anything in common?

It is possible if we use row binding.

 

3.Zmiany

3.a

To co należy zrobić to usunąć powiązanie sekcji tabela z listą. Oznacza to usunięcie formuły lookup z rubryki 'Filtr'.

 

3.Changes 

3.a 

What you need to do is to undo the table- list binding. It means deleting the lookup formula from 'filter' field. 

Screen_Shot_09-24-18_at_09.44_AM.PNG

3.b

Next you need to drag the 'name' list field to the first table column. This way all rows in this column will have a dropdown with product names. 

3.c

 

Now we want for to price and category to appear automatically after choosing a product from the dropdown.

Then choose option 'allow add rows' and in 'new row formula' put this formula:

=lookup(products, name=A)

Screen_Shot_09-24-18_at_09.53_AM.PNG

 

4.Test

Now add yourself as the app creator and run it or check how it works using the 'preview' button.

Screen_Shot_09-24-18_at_09.58_AM.PNG

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk