# Get data from user specific column

**URL:** <https://community.glideapps.com/t/get-data-from-user-specific-column/10543>\
**Category:** Ask for Help\
**Created:** [June 8, 2020, 7:26pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543 "2020-06-08T19:26:02Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![AlfredoZGC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfredozgc/32/4958_2.png) [@AlfredoZGC](https://community.glideapps.com/u/AlfredoZGC)\
**Post date:** [June 8, 2020, 7:26pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/1 "2020-06-08T19:26:02Z")

</div>

Hello, I was wondering if someone know how to do this. I have some user specific columns, also some math columns and lookup columns (this kind of columns appear only in the data editor but not in the spreedsheet)

Is it possible to copy this data to real columns in the spreedsheet?

Thank you

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [June 8, 2020, 10:24pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/2 "2020-06-08T22:24:25Z")

</div>

Seguro que si @AlfredoZGC!

but you must use a Form to get it. Add columns of your sheet as new components and set them up to receive values from your user specific columns.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/051302d017bea7c3da1eeb1d2b7032d8aee0d13f.png)

Saludos

---

<div class="post-metadata">

**Author:** ![AlfredoZGC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfredozgc/32/4958_2.png) [@AlfredoZGC](https://community.glideapps.com/u/AlfredoZGC)\
**Post date:** [June 9, 2020, 12:37am UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/3 "2020-06-09T00:37:25Z")

</div>

I was afraid of it, Thank you my friend!

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [June 9, 2020, 12:48am UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/4 "2020-06-09T00:48:00Z")

</div>

No way!  
No fear, no pain… no mercy!

Te cuidas.

---

<div class="post-metadata">

**Author:** ![AlfredoZGC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfredozgc/32/4958_2.png) [@AlfredoZGC](https://community.glideapps.com/u/AlfredoZGC)\
**Post date:** [June 9, 2020, 12:18pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/5 "2020-06-09T12:18:16Z")

</div>

Hahahahaha no mercy!!

Gracias, cuidate tambien

---

<div class="post-metadata">

**Author:** ![Jorge\_Herrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_herrera/32/10119_2.png) [@Jorge\_Herrera](https://community.glideapps.com/u/Jorge_Herrera)\
**Post date:** [July 3, 2020, 8:20pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/6 "2020-07-03T20:20:53Z")

</div>

Hola sabes no logro pasar un valor de columna en sheet hoja1 por ejemplo a otra hoja donde estoy completando una forma sheet hoja 2 sabes como se puede? tu mencionas que hay que hacer el set up para que reciba valores ?

---

<div class="post-metadata">

**Author:** ![AlfredoZGC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfredozgc/32/4958_2.png) [@AlfredoZGC](https://community.glideapps.com/u/AlfredoZGC)\
**Post date:** [July 3, 2020, 9:13pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/7 "2020-07-03T21:13:36Z")

</div>

Hola Jorge, bienvenido a la comunidad!

Para pasar valores debes tener un TAB que apunte al sheet hoja1, en ese TAB ingresas el valor, después desde ese TAB utilizas un Botón que llame a un Form, este Form debe de apuntar al sheet hoja2, ahí es donde te saldrá como componente el valor que llenaste en hoja1

Saludos

---

<div class="post-metadata">

**Author:** ![Jorge\_Herrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_herrera/32/10119_2.png) [@Jorge\_Herrera](https://community.glideapps.com/u/Jorge_Herrera)\
**Post date:** [July 3, 2020, 9:16pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/8 "2020-07-03T21:16:26Z")

</div>

Muchas gracias si es que en la form al llenar otras columnas entre ellas una opción checkbox quiero que desde allí me pase el dato a la sheet hoja 2 y no lo logro si checkbox es seleccionado

---

<div class="post-metadata">

**Author:** ![AlfredoZGC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfredozgc/32/4958_2.png) [@AlfredoZGC](https://community.glideapps.com/u/AlfredoZGC)\
**Post date:** [July 3, 2020, 9:18pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/9 "2020-07-03T21:18:41Z")

</div>

El Checkbox debe de estar en el TAB, y una ves que llames al form este aparecerá como un componente

---

<div class="post-metadata">

**Author:** ![Jorge\_Herrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_herrera/32/10119_2.png) [@Jorge\_Herrera](https://community.glideapps.com/u/Jorge_Herrera)\
**Post date:** [July 3, 2020, 9:20pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/10 "2020-07-03T21:20:32Z")

</div>

si así creo que funcine no lo he probado, pero lo quería hacer desde el TAB form; he batallado por ratos y no lo puedo lograr. Intente tambien haciendo un IFTHEN pero la columna virtual donde logro el resultado de la condición del checkbox; no deja pasar el dato tampoco a la sheet hoja2

---

<div class="post-metadata">

**Author:** ![AlfredoZGC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfredozgc/32/4958_2.png) [@AlfredoZGC](https://community.glideapps.com/u/AlfredoZGC)\
**Post date:** [July 3, 2020, 9:46pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/11 "2020-07-03T21:46:09Z")

</div>

Mira hice un ejemplo rápido:

 ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/05e39023386dceb57d86e4c95e2144b147ef493c.png)

Mi hoja 1 luce así: Los campos Nombre, Teléfono y Check están en azul por que son user specific, el campo row id se agrega automáticamente cuando pones un campo user specific

 ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/458bf2585ff76136a1ed3aa8fbed0e61b329085f.png)

Mi hoja 2 luce así. Ningún campo es user specific

 ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9bd9f5b166a8188d04c45d51c687ad9472776b75.png)

El TAB para hoja 1 lo tengo así, es un TAB del tipo Details y ahi ingreso los 3 valores y despues tengo un botón que llamara a un formulario que graba en Hoja 2

 ![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c60e420a438e631eb1521cdf1ee5edd16dee33fa.png)

En la lista de componentes de ese formulario me aparecen como componentes todos los campos que tengo en hoja 1

![5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/15e1ae8337f5c9d4abadcd014297c2a5c99cec34.png)

Cada uno de esos componentes los he asociando para que envíen valores a las columnas respectivas de hoja 2.

Al momento de enviar el formulario la data se graba en hoja 2

---

<div class="post-metadata">

**Author:** ![Jorge\_Herrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_herrera/32/10119_2.png) [@Jorge\_Herrera](https://community.glideapps.com/u/Jorge_Herrera)\
**Post date:** [July 3, 2020, 11:10pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/12 "2020-07-03T23:10:24Z")

</div>

gracias por tu apoyo Alfredo, pero no es eso lo que busco tienes whastup ? o zoom para explicarte mejor

---

<div class="post-metadata">

**Author:** ![Jorge\_Herrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jorge_herrera/32/10119_2.png) [@Jorge\_Herrera](https://community.glideapps.com/u/Jorge_Herrera)\
**Post date:** [July 3, 2020, 11:25pm UTC](https://community.glideapps.com/t/get-data-from-user-specific-column/10543/14 "2020-07-03T23:25:43Z")

</div>

Join Zoom Meeting

> **[Join our Cloud HD Video Meeting](https://us04web.zoom.us/j/74725245073?pwd=Ym4vWk5SY09oV01Rdjh4cUV6WWxmUT09)**
>
> Zoom is the leader in modern enterprise video communications, with an easy, reliable cloud platform for video and audio conferencing, chat, and webinars across mobile, desktop, and room systems. Zoom Rooms is the original software-based conference...

Meeting ID: 747 2524 5073  
Password: 0uchEx