Duration?

Time field stores time in seconds (maybe milliseconds?) of the time since midnight of epoch, it’s in a sense a date/time field with a fixed date. It’s likely not a great use case for you here if your aim is data export. It’d be usable but you’d need to do some post processing on it.

In terms of managing this, I’d just have two fields, one for the action name (using a combo box picklist probably) and a second number field for the time duration in minutes. That should let you fill in your own action name and then the number field being duration in minutes can be set to what ever value you want. In terms of automation, I’d go towards having a script field which then sets the number field to the known values. Essentially you need to map the string value you set to a number and at the moment this is likely the easiest way:

function Fill_Duration() {
	var action = record.getFieldValue('fld-4807f45c4fd9403c8beef5edce917c6d');
	switch(action) {
		case "Action A":
			record.setFieldValue('fld-4b64c978546045ab944ea4c959d89953', 5);
			break; 
		case "Action B":
			record.setFieldValue('fld-4b64c978546045ab944ea4c959d89953', 10);
			break;
		case "Action C":
			record.setFieldValue('fld-4b64c978546045ab944ea4c959d89953', 20);
			break;
	}
	document.saveAllChanges();
}

Fill_Duration();

In my sample form, fld-4807f45c4fd9403c8beef5edce917c6d is the “Action” text field with combobox pick list and fld-4b64c978546045ab944ea4c959d89953 is my number field. I’d hide the script field because it doesn’t need to be visible. Then when you export the records to CSV, you’ll have a field with the name and a field with the duration, both of which you can override with custom values.

I’ve attached a quick form I did handling this, you should be able to do the same by replacing the form ID’s with the ones for your fields (either visible in the field editor underneath the description field or you can get it in the script editor by clicking “ID”).

Hi Kimberly,

You can filter based on a span of dates if you add multiple rules to your search, each targeting the same Date field.

For example:

Date Field is greater than or equal to 2021-11-02
Date Field is less than or equal to 2021-12-31

Does that make sense?