Submitted by Maxbear35 on 2022/04/19 19:13

Win 10

IQ Ver 120PRE5

 

Everything works well. I have a column that auto inserts the date when I add an item. Just need a column to auto insert the time.

I tried setting up a new date column and changing the format to time but no luck.

Any help would be appreciated.

 

 

Comments

Hi Maxbear,

You have a couple of options...

  1. Do you want a text field ?
  2. or a date field ?

A text field will contain the time text which may or may not sort / filter correctly

A date field will contain both date and time, but you can choose to display just the time part

If the already working date includes date and time, you can have a smart field to display just the time part of that date field

p.s. If you're using the system field ItemCreated, then the smart field approach is probably the best. I can help set it up if you want

HTH !

Pierre

 

Thank you;

Whichever is easier to setup.

I will never sort or filter by time. I just need to see hen an item was entered. 

The easiest way is to use the existing field ItemCreated:

  1. In the Properties pane, Item Properties > Basic section, right-click on Created and select Show as a Grid column
  2. In the grid, right-click on the ItemCreated column and select Manage Field
  3. In the dialog, section Basic, you'll find a Format drop-down. Select Short Time
  4. Click OK
  5. The grid should now show the time each item was created

I see Created in the Properties pane at the top under Basic.

I also see the ItemCreated field under Values.  You could go to Tools > Manage Fields.  Highlight the ItemCreated field in the field list.  Then on the right side, under Options, make sure that you uncheck "Hide in Info Pane".  Also, if you like, uncheck "Hide in Available Fields".

Pierre.

As you directed it is done and it works.  The drawback is that I have to close IQ and reopen to get the time to show. IQ does not automatically show the time as the item is entered. Is there a way to do that?

Much appreciated.

 

 

 

 

Some fields (mostly those referred as "smart fields") do not auto-update

But no need to close and re-open IQ. Simply press F5 (Grid > Refresh) to refresh the display

How do I ?