I have a multi-select text list field [Tools] that I am using in a formula. When items in the field are selected another field shows corresponding information. The formula below has been working for several months. I went in to add to it and now it is not working. I have several set up like this and I checked the ones I had not changed and they also are not working. What has changed with Text Lists that is causing this not to work? How should I rewrite this formula?If([Related Department or Group] = 3 and Contains(ToText([Tools]), "ASR (Legacy)") and [Need Advanced Search] = "No", "sec-idm-ccna-mstr-asrlegacy-cbsalldata")Thank you.

I suggest a step to debug is to make a new formula checkbox field with this formulaContains(ToText([Tools]), "ASR (Legacy)") and see if it works.

I'm not understanding what this would do. I'm using a multi-select text field in my formula.

All I'm saying is there is nothing that appears to be wrong with your formula so I suggest a next debugging step is to try testing that one piece of your formula and report back what the string you were testing was and what the result of the formula was.It's unlikely it is a Quick Base bug in the Contains function, but to try to prove a bug you would have to have the most simple formula possible.

It's highlighting the field [Tools] in my formula and giving me the following message."Expecting number/text/bool/date/datetime/timeofday/duration/workdate/user/userlist but found textlist."This has been working fine for several months now so I'm not sure why it all of a sudden doesn't.

Sometimes the formula editor gives false warnings. It is meant to be an interactive aid, but its not always perfect. So the question is ... is the formula actually working?

Formula using a text list field was working and now isn't

13 Replies

QuickBaseCoachD
Qrew Captain
7 years ago
Then you should break down the other parts of the formula into pieces as well. Perhaps the other data is also not what you expected.

ie

[Related Department or Group] = 3

and then the part

[Need Advanced Search] = "No"
ArchiveUser
Qrew Captain
7 years ago
I've tried each of the above and the check box checked. But my original formula still doesn't work.
Could it be the IF? Do I not need that part anymore?

This is what I have
If([Related Department or Group] = 3 and Contains(ToText([Tools]), "MFE"), "sec-idm-ccna-ssas-mfe-cbsalldata")&

Should it be
[Related Department or Group] = 3 and Contains(ToText([Tools]), "MFE", "sec-idm-ccna-ssas-mfe-cbsalldata")&
QuickBaseCoachD
Qrew Captain
7 years ago
This syntax is correct

If(
[Related Department or Group] = 3 and Contains(ToText([Tools]), "ASR (Legacy)")
and [Need Advanced Search] = "No", "sec-idm-ccna-mstr-asrlegacy-cbsalldata")

So if that is not working then the data in the fields is not what you expected. For a record that is not working, what is in the field

[Related Department or Group]

and what is in the field

[Need Advanced Search]

Note that the "No" will be case sensitive, for example if the data has "no", then that will not be true.

Forum Discussion

Formula using a text list field was working and now isn't

13 Replies

Related Content

Using Grid Edit to Edit Multiple Records at Once

Address field not working

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

syntax help with formula

Delete Formula Button Error