How can I change the timestamp format in an addon by using filters in a 'Get Records' Function?

qb

How can I change the timestamp format in an addon by using filters in a 'Get Records' Function?

Below is a recording of my current setup that works in my 'Query All Records' function. However, in my 'Get Records' function, I'm encountering the following error: 'Please use a numerically indexed array.

https://www.loom.com/share/3eedaf9c07b045cea31aca66ca7dcb8f?sid=822c9b89-7dc0-4895-9c82-e136b2c6197c

frederic

You must delete the first for each because your variable "expeditions" has only one object that is not an array. You do not need to iterate on that.

Then, you should use "var:expeditions.sessions_id" instead of "var:item.sessions_id" on the second "for each" expression.

frederic

In your second "for each" you probably should use "var:sessions_id" instead of "var:sessions_id.sessions"

cause in your datamodel "sessions_id" doesn't seems to have any children named "sessions"

If it didn't fix it, please provide the result from that get record query for further investigations :)

qb

Thanks for all your help so far!

I think I'm getting there but I get one new error: "Unable to locate var: sessions.Date".

https://www.loom.com/share/207b33e70f624df894f5817a4daf55ea?sid=33b54d32-43da-4beb-9c55-78caef13fcf9

qb

Yes, that worked! Thanks for all the help @frederic , much appreciated!