Skip to main content

Hello airtable community, 

 

I am facing a problem while working on my CRM base. I have an auto “created date” field to track when a new deal was created. I then use this field in the interface to create a dashboard so this field is important. The problem I am facin now is that some of my team members have not filled up this table with their deals and are lacking behind. They are now going to update it but when they will create a new deal the “created date” field will be updated as today’s date even though the deal might have actually happened months ago. In this way my dashboard will not reflect my actual dealflow. 

How can I have a field that will basically fill up itself as a general rule but which I could still modify if i need to? 

I hope this is clear. 
Thanks,

​@ipshita 

You could just create a normal date field and set its default option to default to the current date.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hey ​@ipshita, you’ll want to follow ​@ScottWorld advice. By doing so, you’ll get the flexibility of a regular date field, and the automatic populating feature of the Created Date field.  
 

Mike, Consultant @ Automatic Nation 

Try converting your existing ‘Created’ type field into a Date field and toggle on ‘Default to Current date’?  That way your formulas, dashboards etc won’t be affected since the data’s the same while also allowing your team members to key past data in moving forward

 

Terms & Conditions