Hi,
I'm following along with the steps to show the top dog in the Making the App You Want learning tutorial. When applying the filter to the 'blank' list box, no rows are returned in the app screen. I tried pasting the same filter text in a new Summary_Who column, and it returns the expected result. The List Properties 'Visibility' flag is set to TRUE.
Would anyone be able to provide a tip to help determine why the list displays empty in the app?
Hi Alyssa,
Screenshot of the filter in the app builder is attached. Also attached is the filter in the underlying summary table definition just to show it seems syntactically correct.
The source text is :
=FILTER(Summary_Who,"Summary_Who[Number of Treats]=MAX(Summary_Who[Number of Treats])")
The selected list object does not include the fields to display the contents of the list items (the Who and Number of Treats fields are outside of the list object box).
First, you can simply try moving those existing fields into the list object (as they may be set up correctly to point to the correct columns).
If that doesn't work, I'd recommend creating a new list object. For the table, select the Summary_Who table and select the two desired columns (Who and Number of treats). Then add your formula to the source of the new list.
Hi Alyssa,
Thanks again for the great help! I added 2 data cells to the blank list object and set their shared source to Who and Number of Treats. This allowed the data values to be displayed in the app.
It might be helpful to include that step in the learning article. As I am learning about Honeycode, I did not fully understand how to setup a blank list.