Submitted by David_H on 2019/11/01 17:42
I created a grid using the source "ItemInCalendar". I want to have a single grid column that shows which calendar each item is assigned to. So for instance, the field values that would populate in the column would be *name* of the field, not the value in it, i.e. "personal calendar", "holiday calendar", "work calendar" etc.
 
I know, at least last I checked, that IQ does not support the old ecco feature of a column showing the value of child fields. But here I just want to show the name of the child fields (so to speak). Best way to accomplish?
 
If formulas are required, please include them :D.

Comments

Hi David,
 
It would only work when an item is only shown once in the Calendar (1 date field shown in the Calendar) but try this:
  1. Create a text field with name = CalendarName
  2. In field properties, set in options:
    <source>SELECT Event.ItemID, ¯Fields.Name AS CalendarName
    FROM Event INNER JOIN ¯Fields ON Event.FieldID = ¯Fields.ID;
    </source>
HTH !
 
Pierre_Admin
IQ Designer
 

LeftEccoForIQ

2019/11/03 05:02

In reply to by Pierre_Admin

Wow, mind-boggling!

I updated the doc with this trick: Smart Fields
The same can be used to display other event properties...
 
Pierre_Admin
IQ Designer