I have a user field and date user assigned field. I would like to have the date assigned automatically populate when a user is selected. How can I do that with having to save the form first?
------------------------------
Carol McConnell
------------------------------
Solved
capture date when user is assigned
+12Best answer by MarkShnierYou
np, Create a Dynamic Form rule
When multiple conditions are true
and ALL of
[date] is (leave blank)
user assigned is not (leave blank)
Action:
Change the value of the field [Date] to the current date.
.. and uncheck the checkbox at the bottm so the rule fires all the time.
It's possible that the system will not allow to to check if a user field type is blank. If that is the case, you would need to create a formula user field called [null user] with no formula and have the form rules check of the user assigned is equal to the value in the field null user.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
When multiple conditions are true
and ALL of
[date] is (leave blank)
user assigned is not (leave blank)
Action:
Change the value of the field [Date] to the current date.
.. and uncheck the checkbox at the bottm so the rule fires all the time.
It's possible that the system will not allow to to check if a user field type is blank. If that is the case, you would need to create a formula user field called [null user] with no formula and have the form rules check of the user assigned is equal to the value in the field null user.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
+24np, Create a Dynamic Form rule
When multiple conditions are true
and ALL of
[date] is (leave blank)
user assigned is not (leave blank)
Action:
Change the value of the field [Date] to the current date.
.. and uncheck the checkbox at the bottm so the rule fires all the time.
It's possible that the system will not allow to to check if a user field type is blank. If that is the case, you would need to create a formula user field called [null user] with no formula and have the form rules check of the user assigned is equal to the value in the field null user.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
When multiple conditions are true
and ALL of
[date] is (leave blank)
user assigned is not (leave blank)
Action:
Change the value of the field [Date] to the current date.
.. and uncheck the checkbox at the bottm so the rule fires all the time.
It's possible that the system will not allow to to check if a user field type is blank. If that is the case, you would need to create a formula user field called [null user] with no formula and have the form rules check of the user assigned is equal to the value in the field null user.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.