Steer on an automation to list the missing ticks in a checkbox field

[James_Noble]

Hi

I am a bit new to automation writing but would like to know if the Community thinks it is possible to natively (we don't now and won't be getting ScriptRunner etc) to run an automation to create a string of the missing items in a check box and write that to a new field.

Example - my check box has 10 teams who need to tick that they have done their bit.  I need a new field to auto update, each time a team ticks a box, to show the remaining teams.

Any help very welcome.

[Bill Sheboy]

Hi @James_Noble 

I can think of several ways to do this, with varying complexity and brittleness.  But first...

What problem are you trying to solve with the second field?  That is, "why do this?"  Knowing that may help the community offer additional options.

Until we know that "why", some options with your current scenario:

• Two option fields
  • You could have another multiple-select option field to represent the remaining teams.  Then, using multiple rules (and it will take multiple rules), set the values in the remaining field by de-selecting values when they are selected in the primary field.
• Hard-code the options
  • Using a Created Variable with the hard-coded list of values, use methods described in this article I wrote to find the difference between the two lists to store in the other custom field.  This is brittle as it hard-codes values in the rule.
• REST API to get options
  • As a variation of the above method, use the REST API with the Send Web Request action to first get possible values for the field, and then perform the list comparisons

Kind regards,
Bill