Display List

AppSheet AppSheet Q&A
1

Anyone having their list record appearing and disappearing this past day? I didn’t change any configuration and see this happening. I doubt that the appsheet team is pushing updates this weekend but just wonder

3X_b_e_be2564612e495e3d7431c5fa6ac1b64689f0c8e7.jpeg
3X_b_e_be2564612e495e3d7431c5fa6ac1b64689f0c8e7.jpeg331×461 37.2 KB

This list would appear once, then disappearing when I resync the emulator or mobile app 3 times in a row, then reappear… I can’t figure out what could cause that.

Here’s the list expression:

3X_e_b_ebe4f17bf11874bb96ef228516dee6c550f6fc64.jpeg
3X_e_b_ebe4f17bf11874bb96ef228516dee6c550f6fc64.jpeg636×759 51.5 KB

2

The problem might be caused by the progress bard from quickchart.io that do not have enough time to load completely and prevent the rest of the html to load correctly…
What do you think @tsuji_koichi?

3

teambelair:

The problem might be caused by

your formula having a select inside a select inside a select

2 Likes
4

@MultiTech_Visions Beautiful isn’t? lol

Table definition:

  • Stats contains student’s points. Ex: John has a total of 42 points this week.
  • Class_Logs contains completed class logs that are created whenever a student complete a class. Ex: John completed class X on 1/4/21 and collected 3 points.
  • User_Profiles contains student’s profiles.

As you see I simply want to show the list of students from a specific gym that trained this week and order them by points collected (see screenshot). Basically dynamically show a scoreboard.

Is there a simpler way to do? I can’t see an alternative without having the ability to create a join table (Join of Class Logs and User Profiles).

1 Like
5

3X_0_5_05c1e8f86a90d6516c99b992d4a97234606c65c8.png
3X_0_5_05c1e8f86a90d6516c99b992d4a97234606c65c8.png354×261 33.9 KB

  • I would take this part and make it a slice:

and(> WEEKNUM([End Day]) = WEEKNUM(TODAY()),> [Sharing] = “Public”> )

Then use that slice in a Ref_Row() formula for the gym;

  • this will give you the related class logs records where
    • they belong to the specific gym
    • they’re for THIS week (the current week)
    • they’re public

You can then take this list and use that inside your SELECT(), instead of your double-dipped version. (^_^)

You could go a step further and include the part about their points not equaling zero (in the slice), this would then give you only the class logs with progress, for that week, for that gym, that are public.

2 Likes
6

interesting. I would need to add the gym column in the class logs table to add the ref_row. So basically adding a slice, list field with ref row, duplicate the gym field into 2 tables to get rid of 2 selects in a field expression. Is this considered a better design or coming up with workaround to make it work with Appsheet?

I spend quite some time doing similar workarounds and wonder if it is worth it. It makes the app more complex to maintain since I often asked myself why I have this or that slice, field or action in the app.

UPDATE
I added the gym column on the Class_Logs table, created the slice but didn’t created the ref row field. Working well so far! Thank you @MultiTech_Visions

2 Likes
7

teambelair:

Is this considered a better design or coming up with workaround to make it work with Appsheet?

This is the preferred design - at least IMHO.