Forum Discussion
PeterKrasznekew
Qrew Trainee
Mark,
Thanks for the help on this. So I created a new List - User field, however, when I go to input the "if" statement listed below I'm getting the error "Column: 0 > Expecting userlist but found text" at the end of the formula. Do I need to define the users beyond just adding the "User()" field?
If(Includes([Assign to List], ToUserList(User()),
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_18=Completed" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()))
Thank you.
------------------------------
Peter Krasznekewicz
------------------------------
Thanks for the help on this. So I created a new List - User field, however, when I go to input the "if" statement listed below I'm getting the error "Column: 0 > Expecting userlist but found text" at the end of the formula. Do I need to define the users beyond just adding the "User()" field?
If(Includes([Assign to List], ToUserList(User()),
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_18=Completed" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()))
Thank you.
------------------------------
Peter Krasznekewicz
------------------------------
MarkShnier__You
4 years agoQrew Legend
What kind of field is [Assign to List]
Sounds like this is just a down and dirty multiple-choice text field and of course QuickBase has no idea if you have a John Smith on the drop-down list which user that actually is.
Can you have a [Assign to List] be a list user field type?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sounds like this is just a down and dirty multiple-choice text field and of course QuickBase has no idea if you have a John Smith on the drop-down list which user that actually is.
Can you have a [Assign to List] be a list user field type?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- PeterKrasznekew4 years agoQrew TraineeIt is a List-User field.
I was playing around with some things and think it now works using the "Contains" formula. Tentatively optimistic but I'll test with some other user roles and see if it works when selecting multiple people in the List-User field.
If(Contains([Assign to List], User()),
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_18=Completed" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())))))
------------------------------
Peter Krasznekewicz
------------------------------- MarkShnier__You4 years agoQrew LegendThat is strange.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------