How do I use the replace() conditional formatting for expressions, to automatically replace piece of text within another field?

Submitted by desbest on 2023/10/05 05:25
Forums

How can I use the replace() conditional formatting to change "watch" to "embed" automatically within my AutoEmbed field.

I tried reading the documentation but I couldn't get it to work, as the command's syntax wasn't well defined.

infoqube my grid 2

 

auto-assign a value to a text field based on existing state of yes/no field?

Submitted by jimspoon on 2023/10/05 02:26
Forums

Say I have a yes/no field "Banana" and if it is checked, I want to assign the text "Banana" to the field "Fruit Type".  I thought an Auto Assign rule for the Banana field "A:Fruit Type="Banana"" might do it.  But it seems that the rule will not trigger for items where the "Banana" field is already checked when the rule is created.  I can double-click on the Banana field to bring up the items in a scratch grid, and I added the Banana field as a column.  Then I highlighted all the items in the column, pressed space to clear the checkmark, then space again to re-check the items.  This works to