Forum Discussion

JoeHargrave's avatar
JoeHargrave
Qrew Trainee
6 years ago

Stuck on a dynamic form rule regarding current user and date

When a task is assigned to a user, I have adjacent fields that I want to auto-populate with 'Assigned By' (current user) and 'Assigned On' (current date). My trouble is that I can't figure out how ...
Forms
JoeHargrave's avatar
JoeHargrave
Qrew Trainee
6 years ago
Good point Austin. Sorry....
Yes, I went with the checkbox idea. After thinking about it further, it was actually a good solution for my need and it works beautifully. There may be a simpler route, but once I really digested what I wanted the user's workflow to be, it's perfectly fine.

Yes, I tried looking for 'user field not blank' but that option didn't seem to exist.  That's what threw me for a loop in the first place. In the rules, choosing a user field and stipulating 'not blank' simply didn't exist as an option.

------------------------------
Joe Hargrave
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
When I have wanted to compare a user field to blank, I actually make a formula user field called [Null user] and just leave the formula empty.  Then the form rules have something to hook on to.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------