# Determine Dates From a Look Up Column **URL:** \ **Category:** Ask for Help\ **Created:** [April 2, 2021, 6:00am UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039 "2021-04-02T06:00:28Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 2, 2021, 6:00am UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/1 "2021-04-02T06:00:28Z")
Is it possible for Glide to capture dates on lookup from a multiple relation column? It’s only giving me the option of ‘empty’ or ‘not empty’ for the column when trying to set visibility. Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 2, 2021, 9:49am UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/2 "2021-04-02T09:49:10Z")
What’s your use case here? Dates can only be used when they are returned from a single relation. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 2, 2021, 12:23pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/3 "2021-04-02T12:23:52Z")
right. You’d have to use a single value column to grab a single date from a multiple relation. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 2, 2021, 1:04pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/4 "2021-04-02T13:04:06Z")
I see, Im trying to have the text ‘No Events’ display when there are no current events. I did a multiple relation by business name from the master sheet to the events sheet (businesses have more than one event) and a lookup on the end date column thinking I could set the visibility from that. ---
**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:** [April 2, 2021, 1:14pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/5 "2021-04-02T13:14:32Z")
> [@Jen\_NYCP](#): > > I see, Im trying to have the text ‘No Events’ display when there are no current events. Isn’t that the case when your relation is empty? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 2, 2021, 3:14pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/6 "2021-04-02T15:14:13Z")
No, because that just means they don’t have any events, not that it has past. ---
**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:** [April 2, 2021, 3:20pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/7 "2021-04-02T15:20:05Z")
Okay, so what about something like this: - Create an if-then-else column in your events table that returns the word `true` for any row that meets whatever criteria you need to filter on - Create a template column in your Business Owners sheet that just contains the word `true` (no replacements) - Create a multi-relation that joins those two columns ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 4, 2021, 1:48pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/8 "2021-04-04T13:48:34Z")
Ahhh, thank you that worked!! I actually have no more instances I am trying to do the same thing. let me see if this works for them as well. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 4, 2021, 2:15pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/9 "2021-04-04T14:15:49Z")
Are the ‘IF’ cases also ‘AND’ cases, or ‘OR’ cases? I have the following set up, but ‘True’ is still showing up for past dated favorites. I also tried it swapped. ![favdd](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6ba5c0bc423a340fa5ce7d16f241b8fca5e9538.png) ---
**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:** [April 4, 2021, 2:21pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/10 "2021-04-04T14:21:32Z")
When you need multiple conditions to be true (“and”), you need to flip the logic around. Try this: - If Is Favourited is not true, then false - If End Date is before today, then false - Else true ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 4, 2021, 2:25pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/11 "2021-04-04T14:25:18Z")
Yesss that worked, thank you! Ok doing one more. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 4, 2021, 2:41pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/12 "2021-04-04T14:41:25Z")
Stuck on the visibility for this one…The column is displaying correctly, but the visibility isn’t. I want the text to show when the row reads false. I tried ‘not true’ as well. ![favddfd](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/567778752ae0a1be9a30654227b5c5e8da30cc05.png) ![favddfdf](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/1093cbb2cca53a40a5920d44e7cedaf4cb715f54.png) ---
**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:** [April 4, 2021, 2:50pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/13 "2021-04-04T14:50:50Z")
Do you actually have rows in the sheet where that column is false? Is there any other filtering or row owners that could be causing the rows not to be shown? btw… I usually avoid checking for false. I always check for `true` or `not true`. That shouldn’t matter in this case, but it does make a difference when you’re checking the state of boolean columns. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 4, 2021, 3:02pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/14 "2021-04-04T15:02:45Z")
Yes, all but one row is false. This is correct,as only one event has a date that is on or after today. and noted! The joined list is also off of a lookup column, when I clicked a cell in the joined column, it didnt expand into a long list… ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 6, 2021, 2:55pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/15 "2021-04-06T14:55:01Z")
Does anyone have an idea what I am doing wrong? My joined list is not listing all the items in the column it’s pulling from. Thanks! ---
**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:** [April 6, 2021, 3:09pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/16 "2021-04-06T15:09:11Z")
No row owners anywhere in that table? Does the view change if you preview as different users? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 7, 2021, 1:34am UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/17 "2021-04-07T01:34:34Z")
No, no row owners. I tried it again. So the If, then, else column is displaying correctly. The multi relation is listing all the names of the business owners, not their email address or name of the business in these two true rows. Should it be doing that? ![names](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a10df0d1c83f198079ebe2d3e963ef932a6f7109.png) In this case: I would like for businesses that do not have current events, the text ’ No Current Events’ is displayed. The joined list in the If,then column is for businesses that have at least one event (new and old). I think the next column should be one that shows the email address linked to the business, linked to the event which reads true. Not sure how I will do that however. ![names1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a3eea1743c549410d5c57ac2383d7594e404c5a8.png) Ok I figured out how to have the email adress for true events show up in the column next to it. I created a joined list from this, but visibility is not working as it should. Anyone have a solution to this?? Thank you! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/determine-dates-from-a-look-up-column/25039/18 "2024-01-17T16:52:44Z")