Skip to main content
Question

Fomatting Date returned in Json Response


Forum|alt.badge.img+6

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 Percentage and Currency, but does anyone know the syntax need to format a date data?  I need it in the MMDDYYYY format (no time stamp).

Thank you.

Mark

This topic has been closed for replies.

Forum|alt.badge.img+6

If the field includes the date and time, the field type is 'timestamp', otherwise it's 'date'.

So you could add:

{% elif field['type'] == 'timestamp' -%}
<td>{{ record[field['id'] | string]['value'] | date_mdy }}</td>

MarkShnierYou
Forum|alt.badge.img+24

If 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.  


Forum|alt.badge.img+6

I just thought of another route that my work for my needs.  If I create a date formula field to format the timestamp data to a simple date, then use the formula field with to export into my email report.  Instead of trying to format the data from inside the pipeline (outlook channel). - just may work!