How can I exclusively select only one row

Submitted by patrick on 2022/01/22 04:33
Forums

I jury rigged a simple way to time a task by creating a yes/no field (named Clock In) which, when true, sets a date field to Now with Auto-assignment rules. Clocking out is accomplished by setting a different date field, and the duration can be computed using a column equation. It is crude and it works ok, but it would be nice if selecting the Clock In field for one task will deselect this field for all other rows (exclusive selection). Is this possible?

ItemColor Based on Tag and/or Item?

Submitted by viking on 2022/01/20 21:30
Forums

Question 1
I have a Field "WorkType", which is a Text Field with "Auto-List of values", and it has this equation:

AME:[ItemColor]=iif([WorkType]="Call","blue"," ")

When I select "Call" in the drop-down list for the WorkType, the ItemColor turns blue.

However, instead of using a Text Field with "Auto-List of values", I would like to use Tags instead.

Is that possible? Is there some way to monitor a change in a Tag values so that the ItemColor turns blue when the "Call" Tag is selected?
----------

Issues Importing Ecco PhoneBook

Submitted by viking on 2022/01/20 00:51
Forums

I am trying to import my Ecco phoneBook into an IQ file and I am running into several issues (Numbered 1-3).
I have several thousand items and I cannot show them all at once in Ecco (memory overflow), so I will have to import 25 times (once for each letter).

1. When I import the first letter, IQ imports all Ecco folders (many hundreds). They are not empty in Ecco, but they are not used for the PhoneBook items. IQ therefore creates hundreds of folders with 0 items. Can this be avoided?

Doc Pane Syntax Coloring?

Submitted by viking on 2022/01/05 20:47
Forums

I am using Notepad++ which shows Syntax coloring for various scripting languages.
IQ's VB editor shows Syntax coloring for VB scripts.

Can the Doc pane also show Syntax coloring? If so how?
I tried to save a colored script to html in Notepad++ (for import to IQ) but the colors disappeared :-(.

(This is not a feature request, just a question if it can currently already be done somehow)
 

p.s. I am wondering because I wanted to collect several scripts in an IQ database. Syntax coloring makes it easier to read.

automatically Carry Event foward

Submitted by Maxbear35 on 2022/01/02 17:58
Forums

I am slowly coming to grips with the IQ calendar. I can see it is very flexible.

I have imported my date from  Ecco and I can create events that show in  the calendar.

However I need to have the ability to have events automatically carry forward until marked done (ala Ecco)

How can I set an event to do that.

Thank you

 

 

 

Is it possible to create a dashboard with a Grid below the Doc Pane?

Submitted by viking on 2022/01/02 04:09
Forums

In the image below, the addressbook Grid is below the JUnk Grid. I want the addressbook to be below the Doc Pane instead, but have not been able to move it there.

z

Is it possible to create a dashboard with a Grid below the Doc Pane?

Also, is it possible to have the Doc Pane show only in certain Grids?

Merge Databases or Copy Items between Databases

Submitted by viking on 2022/01/01 17:13
Forums

1. Can I merge two databases? I have not found anything about this, so I guess it is not possible?

Alternatively,
2. What is the best way to copy all the items in one database to the other? At a minimum, I would like to retain the Fields and possibly Tags. If I could also copy over the Grids, that would be great.