Work around for Kanban
I have a formula text field that figures out and posts a job status ("In progress", "completed", etc).
I wanted a kanban chart for that, but it only works off a multiple choice field. So my solution was to create a multiple choice field, and have it change using dynamic form rules to match the formula text box. This has a couple of errors:
1) If you grid edit, the dynamic form rules to not fire, and so my multiple choice field does not update.
2) One of my rules is fired off a related table (i.e. I have an invoice table as a child. They can add an invoice. If they put in a date of that invoice, that triggers my formula text field). However, this does not fire unless I go into edit mode of the project (and as you know, you can add items from a related table without being in edit mode).
Thoughts on a work around?
------------------------------
Mike Tamoush
------------------------------
I wanted a kanban chart for that, but it only works off a multiple choice field. So my solution was to create a multiple choice field, and have it change using dynamic form rules to match the formula text box. This has a couple of errors:
1) If you grid edit, the dynamic form rules to not fire, and so my multiple choice field does not update.
2) One of my rules is fired off a related table (i.e. I have an invoice table as a child. They can add an invoice. If they put in a date of that invoice, that triggers my formula text field). However, this does not fire unless I go into edit mode of the project (and as you know, you can add items from a related table without being in edit mode).
Thoughts on a work around?
------------------------------
Mike Tamoush
------------------------------
