Virtual columns(list) with table view

[Aplicaciones_Hu]

Hello appsheet friends, this time I am working with virtual columns, using them to generate checklists within a tour. I am faced with the need that the employees that make the checklists, can only load a single entry. That is to say, when pressing the “add” button, they can only do it once.

I wanted to know if there was any way from ux–>system views to configure this.

Any help is welcome.

[Marc_Dillon]

https://community.appsheet.com/search?expanded=true&q=limit%20one%20child%20%23ask

[Aplicaciones_Hu]

tysm marc i follow some post and guides and i get this:

Limit the number of child entries Questions

Then you would need to add a slice (read_only) and create the second Ref_Rows virtual list for that slice. Hide the original virtual list column when COUNT([Related child records]=1 and show this additional virtual list column. It will hide that “New” button.

i follow the steps, the slice works good but i cant hide the original virtual list column with the “Show_IF” function

but seems like its wrong or something.

any idea whats wrong with this expression in Show_IF section?

and i use others expression like:

COUNT(SELECT(2inspeccion aib[ID],[ID]=[_THISROW].[ID])) = 0

when that count is equal to 0 you can show the ADD button,

but didnt work too…the original virtual column still visible.

[Marc_Dillon · Accepted solution]

Why do you use SELECT() instead of just:

COUNT( [Related...] )

?

[Aplicaciones_Hu]

because i need to count the number of child entries per parent entry, instead the raw number of total entries from a table.

if i use only “COUNT” when COUNT(SELECT(2inspeccion aib[ID],[ID]=[_THISROW].[ID])) = 0 the “add” button never shows because the child table always had more than 1 entry.

Thats why i need to select only the child entries referred by [id] to the parent table to count.

Did “select” generates an error in the expression?

[Marc_Dillon]

Aplicaciones_Huinoil:

because i need to count the number of child entries per parent entry, instead the raw number of total entries from a table.

Yah, that’s exactly what the [Related…] column is.