Firestore Timestamp Solve

💬 Queries and Resources
1

I got a working solution for the Firestore dates. At least it appears to work, I am in no way an expert.

The problem was Retool sends any date object as a string to a Firestone query that then gets entered into Firestore as a string. Some workarounds involved setting the date object in the Value box. But this wasn't a good solution for me.

image
image1162×134 16.7 KB

By using Raw mode I was able to combine an object with my key/values from another query with a timestamp object.

image
image817×380 24.4 KB

I also wanted the return data to be the same value as the GUI mode.

I changed to the .add method and then had to modify the new returned data with the transformer to format the return to look like the GUI mode.

2

Why this is still not fixed @retool whatever @admins

3

Hi @bawantha,

I understand your frustrations here. While we have fixed the bug involving Retool's handling of the PostgreSQL TIMESTAMPTZ data type, we still have an open ticket for the issue related to daylight-savings in our backlog. Hopefully you get some value from the workaround listed above and of course, I'll log this as a plus one in our internal ticketing system.