Forum Discussion
MarkShnier__You
Qrew Champion
Quickbase can do many of the colours that are just expressed in regular words but here is a nice site dine by @Laura Thacker Laura who is also a another QuickBase Solution Provider, which has basically all the colours you would ever need and you would use the hex codes instead of the word green.
https://laurahillier.quickbase.com/db/bhy8pumtp
As for you other issue, yes that is a fatal flaw in my suggestion. I did not realize that the status was being used for the Kanban column choices.
So one way is to retain your status field for the kanban choices.
Then retain your logged field.
Then retain the formula field for the most recent status update which is a formula field.
Then use an "ACTION" to change the value of the logged field to be the value of the Status field. Fire the ACTION when the record is changed and the status field changes.
Also use a pipeline for this but the trouble is the pipeline could take five or 10 seconds to run so not as good a user experience as a very old-fashioned but fast running ACTION.
ā
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
https://laurahillier.quickbase.com/db/bhy8pumtp
As for you other issue, yes that is a fatal flaw in my suggestion. I did not realize that the status was being used for the Kanban column choices.
So one way is to retain your status field for the kanban choices.
Then retain your logged field.
Then retain the formula field for the most recent status update which is a formula field.
Then use an "ACTION" to change the value of the logged field to be the value of the Status field. Fire the ACTION when the record is changed and the status field changes.
Also use a pipeline for this but the trouble is the pipeline could take five or 10 seconds to run so not as good a user experience as a very old-fashioned but fast running ACTION.
ā
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
EddyElasmar
2 years agoQrew Member
I was actually able to use a dynamic form rule for this.
I added another field copied from status. Names it shop status...
When [Shop Status] IS NOT EQUAL TO "Blank"
Action Change [Status Update] to "The value in Shop Status"
Then unchecked the fire changed box.
Yes ! Laura is awesome I am very familiar with her work. As she is mine.
Thank you so much for your help. It works and looks awesome.
------------------------------
Eddy Elasmar
------------------------------
I added another field copied from status. Names it shop status...
When [Shop Status] IS NOT EQUAL TO "Blank"
Action Change [Status Update] to "The value in Shop Status"
Then unchecked the fire changed box.
Yes ! Laura is awesome I am very familiar with her work. As she is mine.
Thank you so much for your help. It works and looks awesome.
------------------------------
Eddy Elasmar
------------------------------
- MarkShnier__You2 years agoQrew ChampionYes, Dynamic form rules will work if your changes are being edited on a form. I thought you were dragging records between Kanban columns to change the status.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- EddyElasmar2 years agoQrew MemberMark,
I am changes the status by dragging the record between the KanBan. I have tested it, it is still triggering normally and logging in the date as it would if I manually changed the dropdown.
Do you know something I don't here?
Thanks for all your help. Pretty long thread so I appreciate the quick turnaround
------------------------------
Eddy Elasmar
------------------------------- MarkShnier__You2 years agoQrew ChampionIf it works it works. What happened to this comment.
Issue: I now cannot select any type of status for the KanBan to be based off of. As we switched the [Status Update] log the time.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------