# How to retrieve a field of another sheet

**URL:** https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368
**Category:** Ask for Help
**Created:** [September 4, 2021, 10:08am UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368 "2021-09-04T10:08:58Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 4, 2021, 10:42am UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/2 "2021-09-04T10:42:06Z")

</div>

When you say you are using your own form, are you referring to a Google Form, or a [custom form](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014) in Glide? It’s easy enough to detect and prevent duplicates with Glide custom forms - check that example I linked to.

In terms of creating relations based on dates, the thing you need to understand is that a Glide date column will always be saved as a date _and_ time internally, regardless of what its displayed as. So if you create a relation on raw dates you are likely to get unexpected results.

What you need to do is convert it to a “fixed” value. One option is to use an if-then-else column that returns a true/false result by comparing the date column to some other known value. Do that in both tables, and then create a relation between the two “boolean” columns.

Another option is to use a combination of math and templates columns to “lock” the date to a fixed format excluding the time, eg “yyyy-mm-dd”, and then use the template columns to create the relationship.

---

_[View the full topic](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368)._