# Relation not pulling in data - help with configuration of Relation

**URL:** <https://community.glideapps.com/t/relation-not-pulling-in-data-help-with-configuration-of-relation/83983>\
**Category:** Ask for Help\
**Created:** [August 23, 2025, 11:48am UTC](https://community.glideapps.com/t/relation-not-pulling-in-data-help-with-configuration-of-relation/83983 "2025-08-23T11:48:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nirmala\_shome](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nirmala_shome/32/91185_2.png) [@nirmala\_shome](https://community.glideapps.com/u/nirmala_shome)\
**Post date:** [August 23, 2025, 11:48am UTC](https://community.glideapps.com/t/relation-not-pulling-in-data-help-with-configuration-of-relation/83983/1 "2025-08-23T11:48:40Z")

</div>

I’m trying to get a relation set up between two tables. One table I have today’s date and an empty text field to pull in a daily affirmation.

All the affirmations and their corresponding dates are stored in a separate table.

I’ve tried to set up a relation but there is not data coming through - wondering if I’m setting this up correctly. Attached are shots of the tables and how I’ve set up the configuration.

I want the column Today’s Mantra to pull from my Full mantra table:

 ![Table 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c79493056944baa3574c5f301d00b5d3a0dc73cb.png)

Here is the table I want it to reference with the data column named and formatted the same:

 ![Screenshot 2025-08-23 at 13.44.32](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82f463997864fd35c1c1e50483b74cdc50d71247.png)

here is my configuration

 ![Screenshot 2025-08-23 at 13.44.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/5/750040405ade1e62cd5a9399c06db933c1de3d59.jpeg)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 23, 2025, 2:31pm UTC](https://community.glideapps.com/t/relation-not-pulling-in-data-help-with-configuration-of-relation/83983/2 "2025-08-23T14:31:21Z")

</div>

You have to consider the time that’s attached to that date. If the dates match, but the times don’t, then then relation will still fail because it’s not truly a match. That Now date is changing every 10 seconds because the underlying time is being update regardless of the forward facing formatting that only displays the date.

You have a handful of options.

- Convert all dates to YYYYMMDD. using math so they become numbers instead of dates.
- Create Template columns that convert your dates to static text without underlying times.
- Or use a Query instead of a Relation so you can compare where one date ‘Is Within’ the other date (Is Within ignores time).

---

<div class="post-metadata">

**Author:** ![nirmala\_shome](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nirmala_shome/32/91185_2.png) [@nirmala\_shome](https://community.glideapps.com/u/nirmala_shome)\
**Post date:** [August 23, 2025, 6:16pm UTC](https://community.glideapps.com/t/relation-not-pulling-in-data-help-with-configuration-of-relation/83983/3 "2025-08-23T18:16:46Z")

</div>

Thanks I was able to use a quary to get this working

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 30, 2025, 6:17pm UTC](https://community.glideapps.com/t/relation-not-pulling-in-data-help-with-configuration-of-relation/83983/4 "2025-08-30T18:17:21Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.