I have a field doing a calculation and I want to get that into a DB. I have 2 other fields working fine but this one keeps putting in 478,382.5 where the calculated is always going to be under 24.
Can someone tell me whats going wrong
Can you share the screenshot of your calculation along with the fields that are being used for this calculation?
Can you show the expression used to set value in Total Time in Bed?
This is the calculation
@benjamin.bm.andrews
You should debug that expression. I think the 1st part of the date-time is empty.
Sorry, The expression is
How do you debug an expression? I did debug on the test site and that seems to work fine. and its not going red so I cant check that for errors.
Its the same as the other two that work, only difference is the arbitrary text used
Add debug_mode=true in the URL. That will enable the debugger.
Click on Inspect on the bottom right. Then hover on the element you would like to debug. You should be able to see the same expression you have configured. (It must be blue in color). You can click on the expression, that you open the evaluator on the right.
Nothing stands out. Says that its valid.
I don’t think that you are doing that right. Do you want to get on a quick call? If yes, DM me the link.
This topic was automatically closed after 70 days. New replies are no longer allowed.