I also like what he did with the cards layouts. Looks very funky
@kyleheney Thereās still an issue in the advanced version with an action getting triggered on the list when adding a row (only for the user adding the row), but I think I fixed the logic issue I had between two devices. Initially if I had selected all items and another user added a new row, the newest item would get marked as selected. Now it will be added as an unselected item and the Select All checkbox will become unselected. This is with additional logic to track when a row is added, and compare it to when the Select All box was checked. Again, itās a lot of overhead, but I think it works better now. At this point, the only downside might be issues with timezone differences since Iām using and comparing dates quite a bit.
2 Likes
Hey @Jeff_Hager ! Iām adding in your checklist feature and I think Iāve pretty much got it in my app except the set column action doesnāt seem to work to select/deselect list items so it wont go true/false or change the icon in the list. Iām not sure how to figure out what Iām missing, it seems like my action map matches properly and all my columns have the correct configuration in the data sheets. Are there any screenshots that I could share to help figure this out? Thanks in advance for your help!
Edit: in re-reading your original post, it seems like my issue might be that itās on an edit screen. I was hoping to have the checklist in the edit screen and only show the join list on the details page. Any advice on how to achieve this? Trying to avoid the clunky look of having all unselected items listed but I also see a potential issue of non-signed in users being able to change the list if itās on a public profile screenā¦?
So this is amazing. And the first app Iāve looked at from another person. Iām really new at this, so Iām having to figure out the login, but I think I see what is happeningā¦ The āeventā thing / screen is brand new. Wow. Mind blown. Iāll be fiddling with this for a while. Thanks you!
2 Likes
Feel free to ask us questions if you need help!
1 Like
Hey, @Jeff_Hager love this work!
My question is this, how do I make the parentID change for unique users? Since you are using a Single Value First table type.
It will always be a unique experience for each user because the ParentID on the first sheet is a user specific column.
So how would I set that for something like an onboarding experience? Like how would I target the first row like that?
Itās the same reason I have the Tap to Start button. That sets the ParentID initially. After that, the clear button resets it to a different value. You would have to have an action somewhere in your onboarding process to set that value initially. Once itās setā¦especially if you require sign itā¦then it will always be populated with a unique ID.
Usually if the sheet only contains one row, you can create a Single Value column that points to that sheet, but select whole row. This could be done in your user profile sheet since you are doing an onboarding process. Then somewhere in your process you can perform a Set Column action that sets the ParentID through the Single Value Row. A similar method is to create a Key column, so something like a template column with the word KEY in it. Create a similar template column in the sheet that contains the Parent ID. Then create a single Relation column to link both KEY templates together. Then you can Set the Column value the same way I mentioned for the Single Value Row column.
2 Likes
Hi Jeff! Thx for your post. This is what exactly I was looking for.
Iām not an expert yet to I checked and unchecked thousand of times in order to undersand. I got it! dont laugh 
In my case it a little but different.
For instance, I have:
Total Donation Record USD 100
- 1 of 2 quota USD 50
- 2 of 2 quota USD 50
Total Donation Record USD 200
- 1 of 4 quota USD 50
- 2 of 4 quota USD 50
ā¦
User can select 2 quotas of different Donation Record (Iām setting columns SELECTED), so I guess, I cant use Unique Identifier since I will working in two records of Donations Records.
How do u suggest to Reset these rows?
I hope u understand me.
Thx so much in advanced
I have a solution for this in my expense management application.
Branch heads can approve multiple expenses using one button provided that they are not already rejected previously or later.
Check out the video here:
Link https://www.loom.com/share/28a43580cc9140daa1dccc9e68adf11a
10 Likes
Great 
1 Like
Thanks @Manan_Mehta. Is that adaptable to be able to be done per user? That is, how could I open up a filtered list that shows a specific userās expenses, then only approve that userās expenses? Iāve tried doing this using a template column to pull in the date and email address of the row, but since tis a template column, itās no longer a date that can be before/after the current date. Curious if youāve used similar logic to allow this sort of process. Thanks!
The video I sent is specifically for individual users. The approval date and time value is written in the userās row only.
I am writing data on the user profile sheet so I donāt need to pull in the userās email address. Let me know if you are confused.
Ahh sorry I understand now! Thanks! Iām going to find some time to play with this. Appreciate the quick reply!
1 Like
Hi @Jeff_Hager, thank you for this workaround. To workaround its possible limitations with Edit/Form/Add, what I did is:
- Create a form with 1 field (ex. Title) just to initiate the new row
- In the detail screen, I have all the other fields and combine āentryā and ādisplayā fields, with visibility conditions (according to the user, ie. creator or visitor)
At the end of the day, just to get a āmulti select choicesā capability, usable in various types of screens (formsā¦), implies a lot of complexity and columns. Hopefully, a native Component (which is quite a basic) will soon appear as a fantastic surprise ! @Mark @JackVaughan ā¦
3 Likes
Thank you so much @Jeff_Hager ! I was able to use your awesome method successfully in creativitae.glideapp.io. What a pleasure it is to see the toggle between red and green emojis and to clear all selections at once.
1 Like
Hi Lucas, can you explain in spanish how to do a select_all an reset? I dont understand the Jeff explanation
Thanks
1 Like
Hi @Manan_Mehta Manan,
Thanks for the video!
Iām a beginner and Iām looking for something similar to your movie. I want to use a button to approve a column value in multiple rows. I just donāt understand how to control the button you use. Do you have a picture of that (how to act)?
If you have time could you show a little more settings for each column, please?
1 Like
Hello Sabiene! Apologies I havenāt seen this message for all this while. Are you still looking for a solution to this?
1 Like