Please is there a way to do one on one chat with anot her user instead of a global chat

Still getting used to Loom :grin: Hope this helps!

[image] ThinhDinh: arrayformula Nice idea ! The sheets solution works yell, but how do I add it automatically when a new row is added? [Capture]

That’s why I mentioned the arrayformula so it automatically calculates when a new row (of topic) is added. I have written about the use of it here: [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 1/ Definition Arrayformula is defined as “a range, mathematical expression using one cell range … If you need help with creating the arrayformula, feel free to tell me.

Hello ThinhDinh, I tried some formula, but I think this is way above my excel knowledge ! :frowning: I try to get the content from column F, if the ID in B column is the latest one found by a LOOKUP [Capture] Any Idea? Thank you for your time !

I think you have the “Topics” sheet already right, and this is the Comments sheet. A combination of VLOOKUP and SORT would do it. Assuming you store the topic/topic ID in column A of the “Topics” sheet, and in the Comments sheet the matching topic/topic ID is in column B. =ARRAYFORMULA(IF(A2:A<>"",VLOOKUP(SORT('App: Comments'!B2:F,4,FALSE),5,FALSE),"")) Explanation: I sort the App: Comments sheet by column 4, which is the timestamp, in descending order. Then the VLOOKUP will return its first match, by design, so it will have the latest message back to your Topics sheet.

[image] ThinhDinh: ARRAYFORMULA Thanks a lot ! I used this formula, it works well : =SI(A2<>"",SIERREUR(RECHERCHEV(A2, SORT('App: Comments'!B:F,5,VRAI),5,FAUX),"Nouvelle Discussion"),"") I’m not sure what ARRAYFORMULA would bring more ?

It will automatically calculate for new rows. I wrote about it here. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 1/ Definition Arrayformula is defined as “a range, mathematical expression using one cell range …

Perfect, seems to be working perfectly !

First day here. Thanks for the good work you are doing. This topic is closed but if someone can help me I would appreciate it. Do I need to do any relations for a chat app-private?

Yes between user 1 and 2 @Kairu watch the video it will help a lot

Need help on creating private chat

Ask for Help

ThinhDinh June 30, 2020, 11:24am 64

It will automatically calculate for new rows. I wrote about it here.

Topic		Replies	Views
In-app chat Feature Requests	54	8428	October 7, 2020
Creating a 1:1 chat Ask for Help	26	2273	December 5, 2022
Make chat option private Feature Requests	20	2877	March 11, 2021
Glide's Community Built Messenger Project Showcase	101	5177	April 11, 2021
Per-User-Data Chat/Messaging Features Feature Requests	31	1831	August 21, 2020

Need help on creating private chat

Related topics