# How to retrieve a field of another sheet **URL:** \ **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:** 9\ **Page:** 1
**Author:** ![Leonfort2](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@Leonfort2](https://community.glideapps.com/u/Leonfort2)\ **Post date:** [September 4, 2021, 10:08am UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/1 "2021-09-04T10:08:58Z")
Hello Maybe I have a problem with lookup. There you are : Sheet-Golf: Golf-Name, Date-event, a relationship with the Sheet-Inscription: Golf-Name, Player name, Date-event, via Golf-Name. When I display the Golf-Name via inlist (in the Golf page) I visualize all the registrations. I created a creation button for a registration. I would like to retrieve, display, the Date-event field of the Sheet-golf in the form I created, it is not the Form of Glide. If I use Glide’s form, I can retrieve the date-event, but it’s a custom form with a lot more fields. I am using my form because the Form Glide does not identify duplicates when I click submit. Unless we can do a check before submit, but I haven’t figured out how to intercept the action of submit. It might be very easy to do, but I can’t find any similar examples or issues on Community. So I created a personalized form and a Lookup in the registration sheet to retrieve the date-event. It works well, but I find all the event dates. I know that when we have a multiple relation, we find all the elements in the lookup field. But then how to do to have only one date-event? How to do for a simple relationship? Thanks for reading me this far, and thanks for your help. ---
**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")
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. ---
**Author:** ![Leonfort2](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@Leonfort2](https://community.glideapps.com/u/Leonfort2)\ **Post date:** [September 4, 2021, 11:02am UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/3 "2021-09-04T11:02:53Z")
Hello Darren Thanks for help. I use Custom Form. I know how to detect duplicate, but in my case I have this Golf-sheet (Gof-Name, date-event), date is in European form, I have two rows Val Grand 16/09/2021, 09:00:00 (related Val-Grand Leonfort2) Val Grand 16/09/2021, 16:00:00 This is possible to have multiple event in the same day at the same Golf ! Registration-sheet (golf-name, Golfeur-name, date-event), I create a registration (without date-event) Val-Grand Leonfort2 : created Val-Grand Leonfort2 : duplicate because the test is on golf-name, Golfeur-name) So, I would hope to transfert the date-event from Golf-sheet to Registration-sheet to detect correctly duplicate row. ---
**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, 11:13am UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/4 "2021-09-04T11:13:23Z")
I guess my question would be why are you not collecting the date and tee-time with the registration? Without that, I don’t see any way that you can prevent duplicates. So what happens, does a user register with just a name and venue first, and then come back later and provide the date and start time? I guess you could check for duplicates at that point. But what actually counts as a duplicate? If I have an existing registration at 9am on the 16th, and then I try to create another one at 9:05am on the same date, is that considered a duplicate? What about 10am, 11am, etc? Whatever the case, it will be acheivable, you just need to have a clear picture of the requirements. ---
**Author:** ![Leonfort2](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@Leonfort2](https://community.glideapps.com/u/Leonfort2)\ **Post date:** [September 4, 2021, 11:19am UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/5 "2021-09-04T11:19:29Z")
In my exemple there are 2 events. The date-time of registration event is not important. I would to detect that the golfeur cannot register at the same event twice. ---
**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, 11:24am UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/6 "2021-09-04T11:24:39Z")
ah, I see. Okay, so that’s easy enough. Just create a template that combines the event name and golfer name in your registrations table. Then when a new registration is being created, create an identical template column that joins the new golfer name and event they are registering for. Then create a relation that joins those two template columns. If the relation is not empty, you have a duplicate. ---
**Author:** ![Leonfort2](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@Leonfort2](https://community.glideapps.com/u/Leonfort2)\ **Post date:** [September 4, 2021, 11:26am UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/7 "2021-09-04T11:26:34Z")
Thanks, I’ll try and I tell you. ---
**Author:** ![Leonfort2](https://avatars.discourse-cdn.com/v4/letter/l/c37758/32.png) [@Leonfort2](https://community.glideapps.com/u/Leonfort2)\ **Post date:** [September 4, 2021, 12:48pm UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/8 "2021-09-04T12:48:38Z")
This is ok but without date-time. I have an idea : when I click on bouton Registration I can copy to cliboard, by an action, the date-event. Now, I don’t know how to retrieve this in registration form. Have you an idea ? Are an action field to do this ? 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:** [September 4, 2021, 1:07pm UTC](https://community.glideapps.com/t/how-to-retrieve-a-field-of-another-sheet/31368/9 "2021-09-04T13:07:19Z")
> [@Leonfort2](#): > > I have an idea : when I click on bouton Registration I can copy to cliboard, by an action, the date-event. Write to User Specific columns in your User Profile sheet. You can then use the values anywhere.