Insert Table into a Form view

[Gustavo_Eduardo]

Hi all. I have seen on one site how a user inserted a table view into a form. This allowed him to select with a check, a series of priced items, from a large list. Which at the end are added to give a value.

For example:

In a form there are the following data:

YES/NO column (Price with VAT)

YES/NO column (Shipping price)

And below all this appeared the table that can be displayed in the form, whose elements can be marked. If they are marked they add if not. This is the case, for example, bananas yes, pears yes, apples no.

In the end, taking into account the previous parameters of VAT and shipping, the price is modified and can be seen below.

The question is how do I put this table inside a form? and how do I put the check so that it adds or not, is this through behavior?

Thanks greetings to all

[WillowMobileSys · Accepted solution]

---

@Gustavo_Eduardo wrote:

The question is how do I put this table inside a form? and how do I put the check so that it adds or not, is this through behavior?

---

In short...

• The INLINE table is produced from a virtual column defined as List but with a base type of Ref.  A special view is automatically generated to show this column data.  It defaults to table but there are other view types.
• The check marks used to control the rows are called "Inline Actions".  Inline is an option on each action you create and allows it to be attached and shown in a column. 

The Long part...

Column

There are two ways to create the proper column to show data in an Inline table

• Manually create a virtual column, define it as List type, set the Base type as Ref, set the datasource to table or slice and then insert your expression to select the rows.  Done!  AppSheet will create the system view necessary to show the table.
• Even easier is to establish a Parent/Child relationship between two tables, IF APPROPRIATE, and Appsheet will automatically generate the lists and views for you.  All you have to do is show the column on your Form.  Example of Parent/Child relationships might be Order -> Order Details,  Manager -> Employees,  and you can go multiple levels such as Building -> Floors -> Rooms 

In both of the options above, Appsheet will create a special system view named something like "Your Datasource_Inline" where "your datasource" is the table or slice the data is based on.  Table is only one type of Inline view, there are others.

Action

When you create an action, you can set an option as "Inline".  Doing so opens another property to allow you to attach the action to a table column.  In the Inline view, mentioned above, the column data is REPLACED by the action.  Sometimes this is just fine.  Other times, we want to see that column data and still be able to see the action.  To make this happen, a dedicated inline action column needs to be inserted.  I normally create a virtual column of type Color, setting its App Formula to "" and even add Red as a color option (to prevent warning messages).  I attache my inline action to this dedicated virtual column and show or hide it as necessary.

I know this is just a quick explanation.  Please ask if you have more questions.

[WillowMobileSys · Accepted solution]

---

@Gustavo_Eduardo wrote:

The question is how do I put this table inside a form? and how do I put the check so that it adds or not, is this through behavior?

---

In short...

• The INLINE table is produced from a virtual column defined as List but with a base type of Ref.  A special view is automatically generated to show this column data.  It defaults to table but there are other view types.
• The check marks used to control the rows are called "Inline Actions".  Inline is an option on each action you create and allows it to be attached and shown in a column. 

The Long part...

Column

There are two ways to create the proper column to show data in an Inline table

• Manually create a virtual column, define it as List type, set the Base type as Ref, set the datasource to table or slice and then insert your expression to select the rows.  Done!  AppSheet will create the system view necessary to show the table.
• Even easier is to establish a Parent/Child relationship between two tables, IF APPROPRIATE, and Appsheet will automatically generate the lists and views for you.  All you have to do is show the column on your Form.  Example of Parent/Child relationships might be Order -> Order Details,  Manager -> Employees,  and you can go multiple levels such as Building -> Floors -> Rooms 

In both of the options above, Appsheet will create a special system view named something like "Your Datasource_Inline" where "your datasource" is the table or slice the data is based on.  Table is only one type of Inline view, there are others.

Action

When you create an action, you can set an option as "Inline".  Doing so opens another property to allow you to attach the action to a table column.  In the Inline view, mentioned above, the column data is REPLACED by the action.  Sometimes this is just fine.  Other times, we want to see that column data and still be able to see the action.  To make this happen, a dedicated inline action column needs to be inserted.  I normally create a virtual column of type Color, setting its App Formula to "" and even add Red as a color option (to prevent warning messages).  I attache my inline action to this dedicated virtual column and show or hide it as necessary.

I know this is just a quick explanation.  Please ask if you have more questions.

[Gustavo_Eduardo]

First try answer: I didn't know how to set the base type, now I know. It can! It's what I wanted. Now I go for the second answer.

[Gustavo_Eduardo]

I go for the second answer. I am not understanding correctly how to set as inline.

Where exactly does this option appear?

[Gustavo_Eduardo]

It's fine, but where is this option to create inline action?

[WillowMobileSys · Accepted solution]

To set an action as "Inline", You need to expand and view the Appearance section.  See image below.

[Gustavo_Eduardo]

Thanks a lot!. If I have any other questions, I'll ask.

[Gustavo_Eduardo]

WOW!!!! Impressive. How to thank you for this answer. I wish you a great day!!!! I am going to try everything and as doubts arise I will ask them!! Thank you very much again, I'll get to work!