Field Creation before importing Non-Hierarchical data?

Submitted by viking on 2023/08/06 22:16
Forums

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?

How do I Pause a VB script?

Submitted by viking on 2023/08/05 04:12
Forums

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

Can I add an Item to the home page?

Submitted by viking on 2023/08/04 04:05
Forums

I have read about home pages here 8. Home Pages.
"The main purpose of the Home Page is to provide links to pertinent information, such as relevant items, grids, pivot tables, mapviews, etc."

It is not clear to me if I also can add items to the home page (not links to an item, but an item)? Then, when I select the item, the document page would show information for the item (which may be text, a web page etc), like it does for a regular item in a grid.

Alarm/Reminder Questions

Submitted by viking on 2023/08/02 23:22
Forums

I am mostly working in a ToDo grid rather than in the Calendar.

1. In order to attach an alarm/reminder to a ToDo item, it appears that I must create an event for the item. Is that correct? There is no way to add the alarm directly to the ToDo item?

2. An Event with an alarm has an icon to the left of the Item text. I guess that it would be a a feature request to also add the icon to the item in the ToDo Grid? I am aware that I could otherwise add the column "ItemHasRemiders" to show this.

Copy/Paste Tags?

Submitted by viking on 2023/07/21 04:11
Forums

Is it possible to copy/paste several Tags from a Grid Tag column?
I have two items, item1 & item2, with the Tags Skating and Skiing. I want to copy these two Tags to item3 & item4.
I copied the two Tags in the Tag column, selected the two blank spots in the Tag Column and pasted:

z

Change a value in Auto-List of values field [maybe feature request]?

Submitted by viking on 2023/07/16 15:37
Forums

Is it possible to change a value of an Auto-List of values field Field Management Dialog - Editor so that it changes the value of all used instances?
For example, let's say that I have 3 values; Adam, Johm, and Steve. I have used all values at different places in my database.
I now want to change Johm => John everywhere where I have used it.

Is that possible, or do I need to do a Find and Replace in all Grids were I have used this field?

Hyperlinking to an Item in a Grid

Submitted by viking on 2023/07/15 23:03
Forums

I have read this section: Hyperlinks

I must be missing something..

I have an item with Item ID = 4828. I want to go to Grid1 and select the item.
My hyperlink is thus: "4828|Grid1". However, nothing happens when clicking on this link.
I can go to the grid by this hyperlink "Grid1" (but that does, of course, not select the item)