Thank you! @Robert_Petitto@Christophe_HK I saw that bug as well. It may have something to do with me adding another column to the 'App: Login" sheet? I used the UNIQUE formula as the source for the user profile emails on my user profile sheet.
I ended up filtering to remove the blank placeholder. Looks like that did the trick.
First of all, gorgeous app! I also just want to warn you about using the UNIQUE formula to build a user profile sheet from the app: logins sheet. If any of the data in App: Logins is ever shuffled around or deleted, itās going to break all of your user profiles because the data in that sheet will be reshuffled and not match up with any other user profile columns you have. I would recommend using Glides built in User Profiles to automatically create a user profile record with email in your user profile sheet.
Hi Nico, can you share a screenshot? The chat is designed so that the user you want to chat with has to āacceptā the chat first. Let me know what bug youāre seeing and I can try to figure whatās going on.
Looks lovely. How did you create the about page with those various sub-pages? Also, the private chat seems really interesting, I didnāt see in the help documentation how to create that?
Thank you @Stephanie_Bonnet. I created an āAboutā sheet with one row for each (legal, policy, etc.). I made that tab a ādetailā tab and pulled in the information using an inline list.
For the image, I used the āSingle valueā function and pulled in an image I have saved on a sheet called āUIā for images and such that have one value that I like to use across the entire app (images, links, etc.)
For private chat, my approach was creating a āchatā form. By adding ācommentsā to chats and setting the topic as the āchat Idā , each chat has itās own set of comments.
Users only see the chats they are added to or created using a filter and visibility conditions.
That was me playing around with a formula to create an alert for when thereās a duplicate username. Almost worked, but itās too dependent on Google sheets formula.
Iām looking forward to more advanced Glide formulas so that it can all happen in Glide
For our use case, we are looking to enable private chat for when a user is on a specific listing (detail layout) so that instead of looking up users to instigate a private chat, they would click a button on listing which would put them in direct private contact with the person who owns the listing.
Is this doable?
Also, as chats pile up in the sheet, I presume they count as rows and therefore could at some point exceed the row quotas in Glide?
@Lisa: Love your app, and in particular your solution for the about page!
Yes, this can be done! In stead of using the user information from the user profile, youād Use the user info from the listing to create the chat. Since the chat leverages the comments feature, it doesnāt count against row quota. Only one row per chat is used (to house the info connecting one user to the other).