New user questions

[ScendMedia]

Hi there,

I’m completely new to Glide and have a few questions that are probably very basic:

1. In the detail screen, how do I specify that more than one column of data should be on the same row? (e.g. side-by-side rather than below.)

2. Change I change the format of a date value within Glide? (e.g. change MM/DD/YY to MONTH DAY, YEAR.)

Thanks in advance.

[ScendMedia]

3. How do I specific more than one column for display? In specific, I’m want to show the address and city in a spot like this.

[Robert_Petitto]

1.) you can use a basic table component instead
2.) make sure the date column in the Glide data editor is of a “Date” type. Then, you can set it to “long” date style
3.) combine any number of columns using a template column in the Glide Data editor. Then display that template column in your app.

[Jeff_Hager]

https://docs.glideapps.com/all/reference/components/layout/basic-table

Date & Time Column

Template Column

[ScendMedia]

1.) you can use a basic table component instead

That’s not as nicely formatted as regular text, but it works. How can I do that with two checkboxes?

2.) make sure the date column in the Glide data editor is of a “Date” type. Then, you can set it to “long” date style

Perfect, thanks.

3.) combine any number of columns using a template column in the Glide Data editor. Then display that template column in your app.

Do changes made in the Glide Data editor make a round trip back to Google Sheets? I have to be careful about changes to the Google Sheet or I’ll interfere with a Zapier integration.

Thanks for these answers!

[ScendMedia]

Thank you.

[Jeff_Hager]

1. No you can’t currently align separate components side by side.

2. ‘Glide only’ columns do not sync to the google sheet, so unless you are changing the basic data, computed columns will have no effect on the google sheet. They are still separate, but data is synced between glide and google.

[Uzo]

You can use template column to combine multiple columns text to one

[Daniel_Canup]

Is it possible when adding a new user to force toLower() an email.

[Uzo]

i don’t know what you mean ?

[Daniel_Canup]

So I ran into an issue where I had a user logging in using (email@this.com) but another time used (Email@this.com). Now, where I found the issue was when I match the email address per the user from one table to another. It wasn’t matching up. After digging into it, I discovered it was because of the lowercase e VS the uppercase E.

[ScendMedia]

1. No you can’t currently align separate components side by side.

That’s too bad. Wouldn’t that cause a tablet layout in landscape orientation to have large amounts of unused space?

2. ‘Glide only’ columns do not sync to the google sheet, so unless you are changing the basic data, computed columns will have no effect on the google sheet. They are still separate, but data is synced between glide and google.

That sounds brilliant. I’ll check it out tomorrow.

[ScendMedia]

You can use template column to combine multiple columns text to one

That looks brilliant. I’ll have a look at that, thank you.

[Uzo]

you can use =LOWER(b2:b) formula
but… when users signing in, it should give you all emails lower case… why is not?

[Daniel_Canup]

It seems that iOS likes to capitalize the first letter of a new line sometimes. How do I use this formula?
Like where?

[Uzo]

in App: Logins sheet put this formula in cell D2

=arrayformula( if ($a$2:$a="", , lower($b$2:$b)))

[Daniel_Canup]

Ahhhhh gotcha! Thanks, man!

[Daniel_Canup]

So this will only affect anyone new added, correct?

[Uzo]

this will change all emails in this column
later just refer to column D instead of B
you can do the same think in user profile sheet

[Daniel_Canup]

How? The login column is automatic…