- Asked by Bob
- 21 days ago
1 person found this helpful
Right, so as you know, the reason they are called Dynamic Form Rules and not Dynamic Grid Edit Rules is because they only work on Forms.
So you have two choices, sort of low tech and hi tech.
Low tech is that you change the field type of that [Status] field to log changes and then have a new field that is a text formula field to parse out the ;latest status and the date of the change.
Here are the formuals for that.
Most recent value (formula text field type)
Trim(Right([my update field]),"]"))
Date of most recent update (this needs to be a formula date field)
ToDate(Left(Right([my update field],"["),9))
Who did the most recent update (formula text field type)
Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
The other option is more technical and that involves setting up a Webhook to record that update date. YOu can read about Webhooks in the help docs, but realistically, unless you are really smart you will need some help getting your first one working. Then they become easier. :) I needed help and examples my first time.
Contact me via the information in my Profile if you want one on one assistance with webhooks or else go low tech.
Was this answer helpful?
QuickBaseCoach App Dev./Training , Mark Shnier, Principal
QuickBase Solution Provider 21 days ago
cannot use webhook due to the limitations on how many you can use. sometimes our users are entering or modifying 20+ lines at a time
That is not a limitation. Just use an ACTION ( which is really webhooks for dummies - so I will go dummies any time I can)
Have the Action do the update on the record being edited.
You will see that it is not obvious how to get an Action to edit the record you are on.
Just create a report links field and configure record ID on the left and navigate on the right to the same app, same table, same Record ID# field.
Then use that for the Report Link in the Action. Just be sure to set the conditions for the Action so it does not get into a loop and keep firing based on it's own edits.