Conditional text depending on what table data comes from?

gautam.bakshi · 2020-06-24T14:04:47.728Z

Hi There,

I have data being displayed from two tables(actual or predicted). What I do is I query both, sort by date and merge the results than print the latest results. It works perfectly if I have actual data it displays that, if I have predicted data then that gets displayed.

What I want to also do is notify my users that it’s a prediction but I’m unsure how to do this. I was thinking of looking at the result of the field then if it matches the most recent data in my prediction table then display “predicted” otherwise display “actual”. I understand conditions for a text area is what I need but I’m not sure how it can figure out where the data is coming from.

Any ideas?

system · 2020-09-02T14:04:47.666Z

This topic was automatically closed after 70 days. New replies are no longer allowed.