# In GlideApps, how to get last entry replicated?

**URL:** <https://community.glideapps.com/t/in-glideapps-how-to-get-last-entry-replicated/51340>\
**Category:** Ask for Help\
**Created:** [October 9, 2022, 9:54pm UTC](https://community.glideapps.com/t/in-glideapps-how-to-get-last-entry-replicated/51340 "2022-10-09T21:54:46Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [October 9, 2022, 11:18pm UTC](https://community.glideapps.com/t/in-glideapps-how-to-get-last-entry-replicated/51340/4 "2022-10-09T23:18:00Z")

</div>

An approach that should work:

- **Create an array of the elements whose last element you need**. To do so, create a lookup column, select the column whose last element you need (in your case “AnsweredName”)  

- **Determine the number of elements in this array**. To do so, create an “Array length” column (you’ll find this column type under computed columns and array), select the column with the array of elements.  

- **Determine the index of the last non-empty element**. Indexes start at 0, so the index is the number of elements in the array minus 1. To do so, create a math column and subtract 1 from the number of elements.  

- **Fetch the last element of the array of elements using a single value column**. From the array of elements (“from” field), get the element with the last index from the start.  

This image sums it up I think, this is what your columns might look like:

 ![Screenshot 2022-10-10 at 01.15.58](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/ccf271b4ff60cc5aa8bdbe3ac8a8019050589dfa.jpeg)

**Another approach** :

- Create the array of elements
- Reverse the array: your last element becomes the first with index 0
- Slice the array between 0 and 1 (start at 0 to include index 0, end at 1 to exclude indexes beyond 1)
- Turn the single array element returned into text (joined list column)

 ![Screenshot 2022-10-10 at 01.34.21](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/09344bc81c33ae027d23fa97bd98e6d666270e04.jpeg)

---

_[View the full topic](https://community.glideapps.com/t/in-glideapps-how-to-get-last-entry-replicated/51340)._