Hey beautiful community, I have a question regarding ArrayFormula in Google sheets. I use it to copy data from one sheet to another (the whole purpose of that formula) but I was wondering if it was possible to do the same within Glde. I have experienced a bug in google sheet today which I manage to resolve but just in case, I would like to know if I can do the same within Glide. Any good tips? Good bless :pray:t4:

how exacly you wanna copy data… becouse arrayformula is not the best tool for that… also what is the purpose of that copy?

Hi The purpose is to extract information from the user sheet to create another sheet as a directory with only some of the user information. I tried “add row” in a custom action but it copies the current user details. The good thing about ArrayFormula iis that if informations in the user sheet are amended, it automatically updates the 2nd sheet. But I expérienced a breech yesterday that wiped everything out. Hopefully it got solved but I need to think of another way to copy my data on 2 separate sheet and especially the row ID

The below might be of interest. [image] How To: Use a Public Users table to keep private user data secure (Glide Tables only) Community Resources Here is a copyable concept App that demonstrates how to keep User Profile data secure through the use of Row Owners, and at the same time share a subset of each users data via a Public Users table, using Glide Tables only Key points: A simple onboarding screen forces new users to complete their basic profile information. When a user completes the onboarding, their Public Profile is created The Users table and Public Users table are kept in sync by using an onSubmit action on the User Profile …

Array formula in Google Sheet

Ask for Help

Darren_Murphy October 11, 2022, 8:55am 4

The below might be of interest.

Topic		Replies	Views
Add new row is clearing my Google Sheet formula Ask for Help	5	833	September 3, 2021
How to retrieve data after duplicating and relation in Google sheets Ask for Help	17	1078	February 24, 2021
Google Sheets Formula Carry Down Ask for Help	13	3704	July 28, 2022
ARRAYFORMULA no longer syncing from Google Sheets Ask for Help	11	795	March 1, 2024
Sum formula Ask for Help	9	1965	July 8, 2020

Array formula in Google Sheet

Related topics