# Get last value from a table to a new one

**URL:** <https://community.glideapps.com/t/get-last-value-from-a-table-to-a-new-one/72460>\
**Category:** Ask for Help\
**Created:** [April 10, 2024, 3:26pm UTC](https://community.glideapps.com/t/get-last-value-from-a-table-to-a-new-one/72460 "2024-04-10T15:26:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Low\_Code](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/low_code/32/61434_2.png) [@Low\_Code](https://community.glideapps.com/u/Low_Code)\
**Post date:** [April 10, 2024, 3:26pm UTC](https://community.glideapps.com/t/get-last-value-from-a-table-to-a-new-one/72460/1 "2024-04-10T15:26:55Z")

</div>

Hola! Estoy realizando una aplicación que en la que necesito que se escriba en una tabla de 1 fila siempre el ultimo valor de otra:

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

Solamente necesito que en la otra tabla se sobreescriban los campos Sprint, Version, Inicio\_Sprint y Fin\_Sprint, todos correspondientes a la última fila de la tabla anterior:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6bf87548303746e612e84fe3df88da3b05cc66e.png)

Debo aclarar que la idea de ésto es que los datos figuren en la hoja de Google Sheets para luego hacer IMPORTRANGE a otra hoja de cálculo.

Si existe alguna posibilidad de realizarlo sería muy agradecido de obtener respuesta. Muchas gracias!

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [April 10, 2024, 3:38pm UTC](https://community.glideapps.com/t/get-last-value-from-a-table-to-a-new-one/72460/2 "2024-04-10T15:38:41Z")

</div>

Based on the subject of your topic, have you tried the Single Value column?

---

<div class="post-metadata">

**Author:** ![Low\_Code](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/low_code/32/61434_2.png) [@Low\_Code](https://community.glideapps.com/u/Low_Code)\
**Post date:** [April 10, 2024, 5:22pm UTC](https://community.glideapps.com/t/get-last-value-from-a-table-to-a-new-one/72460/4 "2024-04-10T17:22:17Z")

</div>

Yes I tried, but the value is not written to the Google Sheets sheet

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [April 10, 2024, 5:48pm UTC](https://community.glideapps.com/t/get-last-value-from-a-table-to-a-new-one/72460/5 "2024-04-10T17:48:23Z")

</div>

I assume both of your tables are sourced from a Google Sheet:

1. If table A does not contain the computed data you want to copy to table B, you can still do it from the Google Sheet side using Query or Importrange.
2. If you want to do it from the application side and have computed data, then you can use the “set column value” action to table B along with the “on submit” action to add a row in table A. In other words, your table B will be updated according to the submit button click action.