Fomatting Date returned in Json Response
I followed the example listed here: How to use Pipelines to email a report at a specific time of day | Qrew Discussions (quickbase.com) However, my Json reponse includes a date. The example formats...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf you want a low tech low solution, just make a table with a record in it and include an embedded report of your report.
Then have a Pipeline update the record on a schedule to trigger an email notification.
But I think this will only work if the users have access to the app because if there are a lot of records on the report it will get truncated in the email if the report is too long.
This was my first thought, but unfortunately there is no way to filter a report before embedding it. In my case, the table I'm working from is qualified commissions for our sales staff. When they get paid, the pipeline would email the sales rep a report of all the commissions included in their payment. Having an individual filtered report made for each sales rep is not feasible.