App Logins to two sheets

Spreadsheet Magic ✨
#1

Loving Glide
I am quite OK now with the having the email addresses going from App logins automaticaly (no idea how this works!) to sheet one and creating a new line for each new subscriber. I have an app that now has abour 35 columns and is getting a bit difficult to work with.
Is it possible to have the email address from the App logins go to sheet two as well ?

Thanks

#2

Of course, it is possible with this formula:

= ARRAYFORMULA (‘App: Logins’! B: B)

App: Logins is the sheet where your session login is, select the column where the email addresses are located.

You can also use it with more than two columns to a different spreadsheet, just select the range of columns, for example:

= ARRAYFORMULA (‘App: Logins’! B: Z)

#3

To add to what Mauricio has said, it’s possible to create an array of only columns you want to. It would look like.

=ARRAYFORMULA({'App: Logins'!A:A,'App: Logins'!C:C,'App: Logins'!Z:Z})

You can throw an IF into that formula as well to check if the row is filled with the data.

#4

Hi Mike! The user profiles feature takes care of this for you without array formulas

User Specific Columns + User Profiles Demo

Or

Our Chores v1.0: An app that lets you manage and track your child(ren)'s chores

#5

Many thanks
Mike

#6

Thanks Robert
I’ve watched your video once - I need to watch it again - and then play with it !
Mike