Hello, I have searched many youtube videos and forum topics but can’t find a specific answer to my question.
One of the apps I am currently developing contains a peer to peer chat function. I have managed to filter the messages that come back into a list viewer that only contain messages from user A to user B in one list. And from user B to user A in another list.
User A is obviously whoever is logged into the app and User B is the person they are attempting to talk to.
At present I am filtering this by all messages going to one spreadsheet, then setting up a rule saying that if the logged in email address matches the “from” column in the spreadsheet, all those messages are put into a new spreadsheet. The app then displays this second spreadsheet.
As you can imagine this is quite slow and this is before anyone else is using it. When the spreadsheets contain hundreds, thousands and hopefully more messages I can imagine it being quite unusable.
I feel there would be a way to do it using cloud variables but I can’t seem to figure it out. So I have 2 questions; 1) am I right in thinking I could do it using cloud variables? 2) Would it be a quicker and smoother process for the end user?