I'm trying to change the colour of the row entry, based on what option I've chosen for the multi-select dropdown box. I mean the category field.

The problem is that it doesn't acknowledge the name of the category that I've chosen. It always ends up being purple, no matter what.

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.

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

How do I make a field uppercase using a conditional?

I tried reading the documentation but the instructions aren't clear.

Below you'll see my attempt.

Can this be done? There is the ItemParent field, but that's text only so not sure how one would get at the item's ID to check its property. Does it require scripting? Thanks.

Hey, trying to save some time figuring this out by picking your brains:

When an item changes from being a TLI to being a child item, e. g. because I dragged it from top level to underneath another top level item, I would IQ to clear certain fields (i. e. to make sure the item no longer has a value for some of my main grids). As I fiddle with these things so rarely, I tend to forget about most of the options - could this be done via auto-assign or would I need to script something?

Many thanks!

Coming back to IQ after a few months'  hiatus where I needed to be on mobile, I am delighted with the new feature of having a Surface sub-view for each grid. However, I can't find any corresponding field (like the "Surface1" field for the main Surface view). I can create items on a Grid Surface sub-view, and they also appear on the grid, but what about vice versa? If I create an item on the grid, how can I get it to also appear on the Surface sub-view?

Just updated from 122g to 122q hoping it would resolve some of my ongoing problems working with InfoQube but othing seems better.

Current issue:

1) Copy website text, (ctrl-c)

2) Paste text in IQ (ctrl-v)

3) Instead of pasting the text, I get a dialogue asking me to select HTML format or plain text.

4) After that, I get the main paste dialogue if the text is more than one paragraph.

Has anyone experience with recovering deleted items?

I accidentally deleted items and I am afraid to use IQ until I find these items (in a backup database).

Per the release info for IQ v120b, #46 "New: View recently deleted items. Tools > Options > This Database > Data Storage > Recently deleted items. List item IDs. Click the button to view these items in a backup IQBase. Use XML copy / paste to restore deleted items"

Looking for a way to quickly move items from one grid to another via keyboard shortcuts.

Can see two ways currently:
1. Set up auto-assign rules based on specific 'tokens' in the item text. To switch an item from one grid to another, edit the item text, type in the token text, type Enter. Let the autoassign-rule remove the token from the item text, assign the new grid and un-assign the old grid.
2. Via the properties pane, but navigating to and setting values for certain fields this way seems rather complicated.