Hey Gliders, is there a way to export emails logged within the App:Logins tab to another Google Sheet via the IMPORTRANGE function. I can’t seem to get it to work, and I think it’s because there’s that colon in the name of the tab.
For anyone who wants a unique list of emails from their App:Logins tab, just plug in this nifty code into another Google Sheet. Be sure to replace the sheet URL with your unique url for your sheet.
I am trying to copy the info from the App: Sales (the one generated by Stripe) tab to another tab within the same file, so glide can see it. Do you know about any formulas that I could use?
Do you know how I could accomplish this with IMPORTRANGE? I’m needing to bring this into an entirely separate Google Sheet file. What I have above works right now, but can’t figure out how to add in the part you gave to filter out blank ones.
Just wondering if you would be able to have one line for each user and then increment the login count by 1 every time the user logs in therefore the new sheet would be
Duplicate the App: Logins tab, make a relation matching the email column to itself, return multiple matches, then use rollup columns to get the count (login count) and latest (last date logged in).
Use an incremental arrayformula for the login count and an arrayformula combined with sort for the last date logged in.
I imagine the first one would be way easier but if you guys need the second one let me know.