Submitted by DavidF on 2020/07/14 18:50
Is there any way to categorise/indicate items that belong to the Inbox and to no other grid? Inbox = Yes and count of yes/no fields = 1, kind of thing? Thinking of a way to tidy it up. I use the Inbox as a first port of call and when I can't think of anywhere else to put something and it can get somewhat cluttered. It would be good to separate out all the ones that already belong to some other grid, from the ones that have no other home. Knowing then that the first lot I can safely clear from the Inbox, the second lot I need to go through to find them some other grid(s) they can belong to.
 
I can do this going through them one by one and checking the "shown in n grids" box, but it would be handy if there was a way of showing that status in the grid, or via a filter.
 
DavidF.

Comments

Hi David,
 
You could create a smart field to do this:
  1. Create a new number field, named ItemYNCount
  2. In the Properties section, check both Hide in... (I'm not sure the impact of this field has on the Properties pane responsiveness, so we'll hide it for now)
  3. In the Options section, enter
    <source>SELECT ItemID, Count(ID) AS ItemYNCount FROM ¯fYesNo GROUP BY ItemID;</source>
  4. In a grid (perhaps a new one), set the source to [ItemYNCount]=1 and [inbox]
  5. Another option is to use the Inbox grid and set the source filter to [ItemYNCount]=1
  6. Best would be to set the grid display mode to Flat list with context parents Off
HTH !
 
Pierre_Admin
IQ Designer
 

DavidF

2020/07/15 17:17

Permalink

This is pretty good Pierre, thanks! Just used it to clear out my Inbox quite handily. Made a new grid as suggested to hold all the Inbox-only items. As it happened they were all bound for the same grid, so selected them all, checked the new grid in Properties, unchecked Inbox, job done.
 
David F.