Days open count on custom field

Dazler · ‎02-18-2023

Hi,

I have been tasked with creating a custom table with a field that counts how many days the ticket has been opened. It is based on ticket creation date and then every 24 hours that the ticket is open the count increases.

Does anyone know how I could go about this? Any help would be appreciated.

BharathChintala · ‎02-18-2023

@Dazler Create new flow triggers on creation of record add wait timer flow logic for 24hrs then add update activity update count then send this to loop again 24 hrs then update

If my inputs have helped with your question, please mark my answer as accepted solution, and give a thumb up.
Bharath Chintala

Dazler · ‎02-18-2023

Hi @BharathChintala,

Thank you for replying back.

I might have a problem with using the flow, these tickets are expected to be open for an lengthy period of time. It could be open at times between 1 week to 6 months. I don't know if I would want a flow to be running for that long.

BharathChintala · ‎02-18-2023

If you want to update record exact 24hrs from created time flow is best option.

if you want in different way best option is schedule job

Run hourly or 6hrs or 12hrs or daily based on how frequent records create

in side glide that table and query open tickets and check duration diff between created and today and update record count.

If my inputs have helped with your question, please mark my answer as accepted solution, and give a thumb up.
Bharath Chintala