🆕 Glide Tables

[Wiz.Wazeer]

@Mark so far I can say “user profiles” in Glide sheets is working, but still early stages. I have been able to onboard users (see my idiot’s guide) and do a few other things (Lookups/relations/split/joined list/distance/etc)…

But the one thing (I am sure others will have other things to add) Glide sheet per se is not letting me do is create an image or email carousel. For some reason it is not able to read and interpret columns with the same name and sequential numbers as belonging to the same relation group.

I thought I would let you know…

[Mark]

Yes, we know, sorry.

[Jeff_Hager]

I think you should be able to create several columns that hold urls for a carousel, then a template column to join them all with a comma delimiter between each one, then the Split Texts column to create an array.

[Wiz.Wazeer]

Yes, absolutely @Jeff_Hager , I did that and it worked, but its as you can imagine too complex a workaround. You know me, I am always looking for an easy way out :).

Update

Sorry…jeff I have not tried it, I was thinking something else. I will try it even though still very complex for my comrades and me.

[Jeff_Hager]

It would only be 2 extra columns in addition to the sheet array columns we are used to. The worst part is adding all the columns to build out the template.

[Wiz.Wazeer]

Okay let me give it a try when I have some free time in the evening.

[Wiz.Wazeer]

@Jeff_Hager, DONE! worked! check it out !

I created 3 templates to catch the URLS (3 images). Then a 4th comma temp, and then a split text.

Update:

Two ways we can do this:

Long way - creating tmps of each image URL, comma tmp, and split text; or
Short way - creating a comma tmp of all images, and the split

Both demos are available in idiot’s guide

[Jeff_Hager]

Good to know it works!

[Wiz.Wazeer]

Using the same logic I think I have just created a GS chatapp (still at it). I will update when done! Thank you as always!

[Wiz.Wazeer]

@Jeff_Hager

Check it out: Got it working…!

I have two examples:

1. Our classical one - your method
2. User profile sheet & GS method

But there is a proviso - User Profile sheet must always have a username…else admin username will appear everywhere.

Private chat on GS is way better than on Google sheet because next to each username the sheet auto-populates the user photo.

[_eric]

This is great!! @Wiz.Wazeer

[Manu.n]

Hello
Great sharing of a Glide table between several applications.
Too bad the Computed Columns do not follow, but it makes sense.
On the other hand, the RowID could be part of the link.

[AyS_0908]

Thanks @Wiz.Wazeer! A question on private chat.
Let’s say I’ve set-up a sort of forum (‘adapting’ @Robert_Petitto template which was much too smart for me :-)) ; it’s based upon

• a form to create a topic
• inline list to display topics
• inside the inline list item there is a ‘Comments’ component

=> In each item of the inline list, in addition to the ‘Comments’ component (which is visible by anybody using the forum), do you think that we can add a one-to-one ‘chat’? it would enable direct messages between

• either the author of the ‘topic’
• or a user having made a ‘comment’?

(picture of an item of the inline list, with its current ‘comments’ component, where I wonder if a ‘one-to-one chat’ could be added)

Thanks in advance

[Wiz.Wazeer]

Was this for me ?

[Wiz.Wazeer]

Thank you, sorry I don’t really follow the last para. You lost me after private part. What is the public bit ?

You can have private chat within a private chat. It’s possible: I know it works. So like a secret room within a private room.

But I don’t follow the “public comments” bit.

[Manu.n]

Hello @Wiz.Wazeer
Uhmm no, sorry.

[Thibault_Milan]

I think it’s more related to data privacy here. Like is any employee can access the data stored in the tables and eventually access and can extract data from it or are they, somehow, encrypted.

[AyS_0908]

Sorry, I understand it was not clear.
I’ve modified my text and added an image

[Wiz.Wazeer]

Got it. Sorry, I m normally a little slow on the uptake.

Yes, very easily. There is something similar on my find a lawyer. You have the public forum and then private chat forum (also eChat, i think). I might add a demo at a later stage on this one. I would upload the UP sheet as the forum tab and do all my work on that sheet (the example from first right on the dummies tab). The one on the left of it (middle one) would require additional sheets (best on google sheets). Then I would from within that forum create a link to the private chat zone or just use another inline list inside the forums tab. I’ve already done this for someone. Which I use would be dependent on who is engaging who.

BTW, I don’t think we even need split text for chats. I am still exploring things. All I can tell you is there more to this GS than meets the eye.

[Wiz.Wazeer]

You know what I might change name of app from glide sheet to glide tabs…Even I become confused when I meet the abbreviations.