Automation - number field

🙏 Ask the Community
, ,
1

Hi guys! :wave:
Form where workers report hours worked. One field for start date and time. Another field for end date and time. Calculation field for hours worked using the two date fields.

Dashboard where I want to display hours worked per employee. Can’t use the calculation field to display that (is this correct?) so I had to use an automation to input the calculation field into a number field. Also can’t do that (is this correct?) so I had to use an automation to turn the calculation into a text field - SUCCESS! Used another automation to input that text field into to a number field - SUCCESS!

Is this really the best/right way to show calculated numbers into a dashboard?

2

If I am understanding you then I believe you can use a cal field in the Dashboard:

View Screenshot
View Screenshot1200Ă—1423 93.6 KB

View Screenshot
View Screenshot1200Ă—1633 137 KB

So the above list uses a calculation field for the worked hours.
View Screenshot
View Screenshot1200Ă—971 120 KB

However if you are trying to do something different in the dashboard and a calculation field doesn’t work in that situation then i would forgo the calculation field altogether and just use an automation to create the worked time and enter it it into the field that you need but I am fairly sure you don’t need to.

What dashboard component are you trying to add that won’t take the calculation result but will take a text field?