Skip to main content
Solved

Can't see what is wrong with this formula using List

  • September 30, 2024
  • 0 replies
  • 361 views
Forum|alt.badge.img+7

Have a formula that I can't find what error is. 

Error I'm getting is:

column: 81 > Expecting , 

Any help appreciated.

Here's my formula:

List(", ", If([Approval Status] = "Pending", [Related Administrator Name]) )

Best answer by DonLarson

The faculty table organizes the Leave requests.   If you are replacing a paper based system then it does not immediately help you.  Once your Users have more than one request over time it is very helpful for reporting.

View original
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

The problem is that List function needs at least 2 text fields to  concatenate together separated by the specific separator character which have set to be a comma and space.

If you are not trying to list some things together than don't use the list function:

If([Approval Status] = "Pending", [Related Administrator Name])

Maybe you can say in plain English words what you were trying to have the formula due and we can help.  

Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+7
  • kheatley
  • Author
  • Registered
  • September 30, 2024

Maybe I should be clearer in what I'm trying to do.

We have an approval process with multiple persons needing to sign-off, so there could be multiple "Related Administrator Name(s)".

Would the example you created above still work or would I need to use List?

Forum|alt.badge.img+19
  • DonLarson
  • Qrew Cadet
  • October 1, 2024

Do really have multiple Related Administrators?  That would look like this:

In this case my Projects table can have three Related Administrators from the three relationships.

The field Related Admin XXX  is the reference field back to the Administrator table and is a number. That is not what you want to show the User.  The Look Up field with the Administrators Name should go into the formula.

 You would want a formula like this:

If([Approval Status] = "Pending", List(",", [Admin One Name], [Admin Two Name], [Admin One Name]), "" )

If your app looks completely different, please share how it is built.

 

Terms & ConditionsAccessibility statement