Color coding report based on Date Modified
Hi all! I'm trying my hand at color-coding a report based on any records updated in the past 7 days. I found a few similar threads/tried to emulate the formulas, but it's giving me guff because Date ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThere is no function called "Changed", so you can't just invent a function which don't exists. Can you you telll me if you are using Legacy Style forms or New style forms and also if all edits will be on forms as opposed to users using Grid Edit. There may be a simple way to trap the date a certain field was changed if you happen to be using Legacy Forms..
Thanks, Mark! I used Google to try to find that hah - that's the whole "experimental" disclaimer of AI, I guess! 🤣
I'm using mostly new style forms, though I have a few handful legacy forms left. Last I knew (this may have updated), by default, tables will include one legacy template that can't be deleted.
I coudl make a legacy form for the purposes of this trap though -- the activity I'm doing is very specific to our team huddles, and the new field I created "Present status breif detail" was created specifically for this purpose, so it could absolutely live alone on its own Legacy-style form. Typically, my staff are grid-editing the detail each week though, not using a form. In my mind, I'd love to find a way to essentially have it highlight any records that had a status update, for ease of viewing the team-wide updates.
- MarkShnier__You
Yes. If you respect your staff to editing on a form and you force them to use a legacy form then there is a form rule on legacy forms that says when the record is saved, and when this field changes then do something.
but if you are going to allow grid edit, then you need to plunge into the pool and do your first pipeline