LinkedIn
Twitter
Hi All
Is there a feature in appsheet to hide (just to hide and not filter off the row) and show only the green logo dropdown list? Because in some case if you filter off the rubbsh bin item at certain point of the process there is a disconnection. And I have no way to resolve that.
Solved
1 ACCEPTED SOLUTION
I found a way to workaround this. If the form is only submit once and does not require a second user to edit then all the example in Appsheet 101 is appicable but if the form is filled by user 1 and sign off by user 2, after saved, then that wouldn't be that straight forward. The following method is how I achieve it.
1. Create a slice then filtering basic row. Basic filtering mean data in the row that you completely do not need them or will no reuse or call up them. Example a tool that is scraped you will not need it in the beginning. Scraped means the last process and that the end of that process. The first step slice expression AND([SCRAP]=0,[PM CODE]=0,[ASSIGN CODE]=0,[CAL CODE]=0,[ASSIGN CODE]=0,[ISSUANCE CODE]=0). At the ref drondown select the the above slice call Ticklet List. This will remove all the Rubbish Bin and other logo and leave a clean drop dropdown.
2. Because the form has 2 users the part of the form that need to be signed off cannot be sliced off and required to be remained as visual in the Ticket List slice. So I this create conditions within the form by create sub table outside the form table and create virtual column. Create a coding condition to allow the form to be edited to save the form again when the second user submit. See the dropdown below :
Green logo mean the row which is available to submit to create a new row. A red spanner logo mean the row already exist and the second user will edit by sign off this form and save again
I found a way to workaround this. If the form is only submit once and does not require a second user to edit then all the example in Appsheet 101 is appicable but if the form is filled by user 1 and sign off by user 2, after saved, then that wouldn't be that straight forward. The following method is how I achieve it.
1. Create a slice then filtering basic row. Basic filtering mean data in the row that you completely do not need them or will no reuse or call up them. Example a tool that is scraped you will not need it in the beginning. Scraped means the last process and that the end of that process. The first step slice expression AND([SCRAP]=0,[PM CODE]=0,[ASSIGN CODE]=0,[CAL CODE]=0,[ASSIGN CODE]=0,[ISSUANCE CODE]=0). At the ref drondown select the the above slice call Ticklet List. This will remove all the Rubbish Bin and other logo and leave a clean drop dropdown.
2. Because the form has 2 users the part of the form that need to be signed off cannot be sliced off and required to be remained as visual in the Ticket List slice. So I this create conditions within the form by create sub table outside the form table and create virtual column. Create a coding condition to allow the form to be edited to save the form again when the second user submit. See the dropdown below :
Green logo mean the row which is available to submit to create a new row. A red spanner logo mean the row already exist and the second user will edit by sign off this form and save again
