# Need help on creating private chat **URL:** \ **Category:** Ask for Help\ **Created:** [June 11, 2020, 7:27pm UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686 "2020-06-11T19:27:18Z")\ **Posts on this page:** 20\ **Page:** 4
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 30, 2020, 11:24am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/64 "2020-06-30T11:24:55Z")
It will automatically calculate for new rows. I wrote about it here. > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > 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 … ---
**Author:** ![Paquerette](https://avatars.discourse-cdn.com/v4/letter/p/a8b319/32.png) [@Paquerette](https://community.glideapps.com/u/Paquerette)\ **Post date:** [June 30, 2020, 11:32am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/65 "2020-06-30T11:32:00Z")
Perfect, seems to be working perfectly ! ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 5, 2020, 9:28pm UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/66 "2020-07-05T21:28:10Z")
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? ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 5, 2020, 9:30pm UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/67 "2020-07-05T21:30:10Z")
Yes between user 1 and 2 @Kairu watch the video it will help a lot ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 5, 2020, 9:51pm UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/68 "2020-07-05T21:51:19Z")
Thanks Did you share any link ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 5, 2020, 9:55pm UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/69 "2020-07-05T21:55:28Z")
Actually, I should mention I am a complete newbie with glide, with intermediate excel knowledge ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 5, 2020, 9:58pm UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/70 "2020-07-05T21:58:57Z")
Welcome to the community > [@Kairu](#): > > Actually, I should mention I am a complete newbie with glide, This is it > [@Need help on creating private chat](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/24): > > Still getting used to Loom grin Hope this helps! ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 5, 2020, 10:07pm UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/71 "2020-07-05T22:07:18Z")
Thanks, I will watch this again and again ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 6, 2020, 6:42am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/72 "2020-07-06T06:42:54Z")
Not sure of the argument here I have set a form where you can request to chat with a user, I have linked it to a ChatSheet as per @Lisa video, somehow the form does not update my ChatSheet, of course I have not done the relation if that affect I have no idea how to set the message screen, like the one for Lisa, I see it is a detail screen. 1st 2 components are action text, what actions are they doing? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4bae92abb7aabfa14ba18fd0ec7a576f49b0865f.jpeg) You may wonder, why I want to build an app where I seem to have no clue, well, this someone else project but he hired me to do the chat functionality But I have grown-fond of what glide can do I will definitely try my own project once I manage this ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 6, 2020, 6:52am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/73 "2020-07-06T06:52:46Z")
This is my chat request screen, I couldn’t attach it above, I am limited to one pic per message ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7240ea55a10fe9d109ffafdf34ff09443a53999e.png) Apologies to members for spamming ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 6, 2020, 7:44am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/74 "2020-07-06T07:44:47Z")
No worries Moses, we are all here to help. Can you verify that when you submit the form it does not update your ChatSheet (It’s “Msg” in your sheet file right?). Does it not update any rows in the sheet at all, can you scroll down the sheet to check if it’s added at row 501 or 1001, and go in the Data Editor to check for them as well? ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 6, 2020, 7:54am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/75 "2020-07-06T07:54:31Z")
@ThinhDinh Thank you It really did to some random rows I think ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/06a0cf3511c3a7dd60aa835bec9691735964d2b1.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 6, 2020, 7:55am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/76 "2020-07-06T07:55:34Z")
Remove all empty rows in the sheet and try adding another chat to see if the problem persists. ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 6, 2020, 8:00am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/77 "2020-07-06T08:00:39Z")
Thanks, it is now updating accordingly FYI @ThinhDinh mentioned I needed to do some relation between user1 and user2, I am yet to do this ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 6, 2020, 8:04am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/78 "2020-07-06T08:04:03Z")
Have you set up a new tab to show chats for each user? In my app, I name the 2 email columns “Email 1” and “Email 2”. It will then be shown in the data editor as an “Email” array column. I set row owner on that column, so only chats of each user will be showed to them. ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 6, 2020, 8:06am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/79 "2020-07-06T08:06:24Z")
You mean this? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/ba39d4f4de0abbd1ec12cd184518a4de5ea9eaa8.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 6, 2020, 8:08am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/80 "2020-07-06T08:08:14Z")
Yes, but has it shown the correct chats to each user? I don’t know if you have set up the row owner option or not. ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 6, 2020, 8:08am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/81 "2020-07-06T08:08:40Z")
No I haven’t @ThinhDinh I have exhausted my messages as a new user, I hope to catch up with you in 13hrs, if not possible maybe tomorrow same time? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 6, 2020, 8:09am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/82 "2020-07-06T08:09:31Z")
Yeah, so structure that the way I recommended and set row owner for that array column. It will then show the chats to the right user. ---
**Author:** ![Kairu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kairu/32/227_2.png) [@Kairu](https://community.glideapps.com/u/Kairu)\ **Post date:** [July 7, 2020, 8:13am UTC](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686/83 "2020-07-07T08:13:06Z")
Unfortunately I couldn’t deliver on the chat functionality, therefore the project was taken away ☹ I will try to build my own (1 on 1 chat functionality) project on a free plan (probably I will be limited?) to enhance my skills. It feels bad not to deliver Hope you will still be available. Also, does glide has an audit trail on changes made to an App? Is it possible to restore an App to a certain date? [Previous page](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686.md?page=3) [Next page](https://community.glideapps.com/t/need-help-on-creating-private-chat/10686.md?page=5)