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.

I plan to import about 60 columns (and 2140- rows) of Non-Hierarchical data. I believe that I will need to manually setup the 60 corresponding fields in IQ before I do the import?

I don't think it is possible, but on the off-chance that I somehow missed it:

I have another CSV file with the 60 field names and field types, and I wonder it is possible to somehow import them into IQ to create the fields rather than to have to type them in one by one before the import?

The purpose is to create a link to another location of the item. My script modifies the item from "myitem" to "myitem {Link}" at item creation time (if possible)

The script is triggered when I create the item, but I need time to enter the text of the item before the script modifies the item.
The idea is therefore to Pause the script while I enter the text.

Function AddLink

     Pause 10 sec
     run rest of script

end Function