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.

Color Column Header Red and Back makes Text White

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

Minor Bug:

1. Select a column; The header is Gray and the text is Black.

2. Column|Color|Red => The Column Header turns Red and the text color changes from Black to White

3. Column|Color|None => The Column Header turns back to Gray but the text color is still White

4. Fix it by Column|Color|Yellow followed by Column|Color|None

BTW, is it possible to only color a specific cell in the column red (not the whole item)? If so, can it be done by an Auto-assignment?

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?