I am designing a module that is only to show information, does genio have any option that allows to hide automatically empty table lists? I know there is the linked sum but for that to work I needed to create a conditional one given that my goal is to show different columns according to the collection/type of the same table.
The goal is that i have multiple tables lists, imagine a form for subjects with multiple table lists to the books, separated by genres in different table lists. But I only want to show the genres / table lista that have books. (so hide the empty table lists)
As Rodrigo said, is not easy to handle dinamic interface. If instead of a table, your genders were arrays then you would have more control over that.
If you still want to do it dinamically you could try a multiform as Rodrigo said.
1) Create a form for Genre with a Table List of books of that Genre
2) Create a multiform over the genre tables. Fore each Genre it will replicate the form created in 1) with the information you want.
No need for SR, extra fields or conditional logic with this solution.
I think you are making things complicated for yourself going with that interface. Forms and tables are much more complex when they need to react dynamically, and the way you are describing you would need a dynamic number of table lists in your form.
You should be using either a tree control of some sort of extended form linked to the GENRE or THEME table list (an inline form that repositions as the user clicks on rows of the table list). Even a multiform, with its limitations, is likely simpler than managing by hand what can possibly grow to dozens of table lists.
You will need to have a count of the number of books in order to do the filtering out of 0 book categories, it should be much simpler than creating sql views.
In this case, the SR (Linked sum) should be in the gender table, and not the book table, due to the gender being inserted dynamically, you can´t attach SR in the book because you can´t tell how many there will be.
By doing this you will have the information on the gender table of how many books there are for that gender. You should also complement the SR with a + (arithmetic) formula which will represent if that gender has or not any book.
This being said, you should have something like this in you gender Table:
Field: NUMBOOKS -> SR formula: [BOOK->1]
Field: HASBOOKS -> + formula: IIF([GENDR->NUMBOOKS]>0,1,0)
In you form, for each table list, apply the show when condition to each table list [GENDR->HASBOOKS]==1
About This Community
|Asked: 3/31/20, 2:58 PM|
|Seen: 321 times|
|Last updated: 4/17/20, 8:21 AM|