Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Field formula of items not selected in multi select

Topic Labels: Formulas
266 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JeffJohnVol
7 - App Architect
7 - App Architect

I researched older posts and found similar topics such as this, but nothing solved that answers this particular question....

I want to create a field with a formula that lists any items not selected.  An applicant has to acknowledge acceptance of the "rules", and we need a list of rules they did not accept.

Is this an easy do?

The sample form is shown below. The ideal answer is that the 3rd item would show up in the new field with the formula.

JeffJohnVol_0-1725823383008.png

 

Jeff Johnson
President, ChattLab Makerspace
2 Replies 2
Alexey_Gusev
12 - Earth
12 - Earth

Hi,

The formula is quite simple despite having much text, so I would create it using another formula. Otherwise, if you accidentally add extra quote, it will be hard to find a mistake in formula.
In some temporary or test table make a long text field 'Question' , put your questions one by one.
add formula field at right:

 

 

 

SUBSTITUTE("IF({X},'','X'&'\\n')&","X",Question)

 

 

 

Alexey_Gusev_0-1725836396680.png


Now collect all the lines you need and use it as a new formula. I mean copy-paste them all to the formula text.
Don't forget to remove the last ampersand.

 

Alexey_Gusev_2-1725836793858.png

That's it.
Please be aware - after you create a field with this formula, and work with it, later, if you change the name of any field mentioned in it, it will be automatically changed in  {Question A}  part (for example), where it represents a field name, but it will not be changed in a part 'Question A' - where it is just a text value.

Thanks!

Jeff Johnson
President, ChattLab Makerspace