Modify DueDate based on Text Field by Auto-Assignment

Submitted by viking on 2022/01/24 01:21
Forums

I have a text Field "KnownDueDate" with a popup list "Known" &  "Unknown".
If I select "Unknown" I want the DueDate to be blank. If I select "Known", I do not want the DueDate to change.

I tried various auto-assignment rules but I can't get it to work properly.
Any suggestions..?
   
 

 

Is it Possible to Combine a Field to Show Date or Text?

Submitted by viking on 2022/01/23 17:20
Forums

I don't think this is possible, but maybe someone has an idea:

I have a date Field "DueDate". Sometimes the DueDate is unknown. I don't want to leave it blank, but to show a due date if one is known, and to show "Unknown" if not known. Is that possible somehow?
 

The closest I can think of is to have two Fields (DueDate and a Text Field with Known/Unknown)
Alternatively,
Use a text Field for the DueDate, but that will cause other issues.

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