Relations based on dates not working as expected

Report a Bug
1

I have created a nice app using multiple relations to link row items across sheets.
However, I have discovered that the relation columns do not update their content upon addition of new elements!
Is it correct? If that is the case, I think it would be a software bug worth fixing; we need this relation column to populate dynamically.

Any help is welcome!

Thanks

2

Can you show some screenshots of how you currently set up the relations? Thank you.

4

I am having the same problem. I have my relation setup and added information to my sheet. The data is not updating on the app.

5

Can someone make a video demonstrating the issue? Does your data contain whitespace, making it not match? E.g. "David " is not the same as “David”.

6

In my case the bug is when relating dates. I have also found out it does not even relates all the dates of the original data. It worked with dates of Aug, but not Sep, Oct, Nov and Dec, except 10Sep2020…!
I have tried to give the same formatting to both the dates column, but that did not work either.

I have verified that a column relating strings of names works and updates fine.

7

It’s possible that even with the date formatting, that it’s still comparing the time portion of the date as well. The times may not be matching, even though it’s the same day and you are only viewing the date due to the formatting. Try creating template columns of the formatted dates and then using the templates for the relation.

8

Do you mean transform the date into something more unique on both sheets and then relate them?

9

No, I mean create a template column in the glide data editor, on both sheets, fill it with the date column value (essentially a duplicate of the date), then use the new template columns for your relation.

10

btw, that is the issue. If I align the time as well from both dates, the relation works. At this point, is there a way in the data entry of a date not to have to indicate a time (or have an invisible default time set)?

1 Like
11

Do what I mentioned above and it will work. Also, if you use a Date Entry component instead of the Date/Time Entry component, it should default the time to 12:00am I believe.

12

It indeed worked, thanks!
now I’ll try it on my real app (I was working on a test app)

Thanks

1 Like
13

This randomly started affecting my app. All relations were working fine, then they suddenly stopped working. It was the relations based on dates. Creating a template column as Jeff suggested, fixed the problem. Why did this suddenly become an issue for me???

14

I experienced the same, for a Zapier integration. I made two columns extracting separately date and time and combing them into a new Template column and used that to reference Zapier, and it worked. But I noticed the same issue appearing…

15

Closing due to inactivity. This topic will be deleted in a few weeks if there are no more comments.