topic Re: In an expression, find a specific record in a table in App Development

In an expression, find a specific record in a table

juancaneu — Sat, 16 Nov 2024 10:15:30 GMT

Hi!

In a chart expression, I want to get a specific record in a table.

The table contains two fields: [date], [value].

Example: 2016-11-12, 120

2016-11-13, 145

2016-11,14, 208

Using today's date, I want to get the corresponding value in the table. (If today is 2016-11-13, I want to get the value 145.

Thank you in advance for your help.

Nicole-Smith — Mon, 14 Nov 2016 02:29:11 GMT

You can use an expression like this:

sum({<date={'$(=today())'}>}value)

I've also attached an example file.

juancaneu — Mon, 14 Nov 2016 12:13:09 GMT

Nicole:

Thank you for your precise and quick answer. I wish you a nice week!