Button to uncheck checklists

8

@Daniel_Stieber et al:

A very good practice is to ask oneself: do I really need to do something, or is there an easier way.

Or, “Do I need to resort to deep object modification” in this case :slight_smile:

If

  • you need to uncheck all checklist items in a text field
  • and every line in that text field is a checklist item

the task can be rephrased as “Turn each line of text into an unchecked checklist item”.

This can be solved much more easily by splitting the text down into lines and then concatenating all together with a checklist item format :slight_smile:

The format string should have an unchecked list item on a single line (no text) and a trailing newline so that items are properly joined together and formatting is not reset. Then we have to Concatenate() that format once again and Trim() the trailing space:

thisRow.Ingredients
  .Split(Character(10))
  .Join([Unchecked paragraph with newline].Format)
  .Concatenate([Unchecked paragraph with newline].Format).Trim(),

The trick here is knowing that when you do

  Concatenate([Text A], [Text B])
  or
  List([Text A1], [Text A2], ...).Join([Text B])

then the last line of Text A receives paragraph formatting of the first line of Text B.

3 Likes