Creating a card with a creation date in the past

[John_Franks]

As mentioned elsewhere on this board I have inherited a project that covers 5 different boards. The volunteers have been fantastic in setting up this system to aid with Covid-19 relief work in the community.

I am trying to re-organise the cards (data) so that we can easily report what type of requests from the public we have received. Food, medicine, dog walking etc.

Simple question: Is it possible for someone using MongoDB to create a new card with a previous date?

[Phill Fox · Accepted solution]

Hi @John_Franks 

Welcome to the Atlassian Community.

Unfortunatly the API for Trello (published at https://developer.atlassian.com/cloud/trello/rest/ ) does not provide a mechanism for retrospectively adding cards with a different creation date. 

However, there is a workaround in that you can add a custom field to all cards with a new name (RequestedDate) and then in a two step process achieve what I believe you want to report on. 

1. For existing cards - pull the report and retrieve the created date from the ID of the card (See https://help.trello.com/article/759-getting-the-time-a-card-or-board-was-created for the explanation on how to do this). 

2. For new (historic) cards create the card using the CreateCard element of the API. 

Then update all the cards by storing the requested date value in the new custom field (RequestedDate)

https://developer.atlassian.com/cloud/trello/rest/#api-cards-idCard-customField-idCustomField-item-put

Now you will have a field on which you can pull the requested date of all cards regardless of when the card was actually created. Please remember as you go forward to populate the requested date on creation. 

You can use Butler to default the requested date field to now but only use this if you are certain you never want to backdate any future cards. 

Hope this helps

Phill