Calculated Field Details Page change when checkbox is enabled

[GIOVAN]

Hello,

We need to approve all overtime hours. We can search from a Tabular report and then open Details Page to approve the overtime.

I want that when I checked BRW_Overtime_Approve. The field BRW_Overtime_Approved_Date = '[@cbTimestamp]' and field BRW_Overtime_Approved_by = '[@authfield:BRW_Employee_Full_Name]'.
I have done this with Calculated Field to get the info. Fields BRW_Overtime_Approved_Date  and  BRW_Overtime_Approved_Date are Hidden and On load, receive: Data Source Field CalculatedField1 and CalculatedField2.

CalculatedField1:

CASE WHEN [@field:BRW_OverTime_Approve]=1
THEN 
'[@authfield:BRW_Employee_Full_Name]'
ELSE
''
END

CalculatedField2:

CASE WHEN [@field:BRW_OverTime_Approve]=1
THEN 
'[@cbTimestamp]'
ELSE
''
END

The problem with this is that it works only when the datapage load, when we unchecked BRW_Overtime_Approve, CalculatedField1 and CalculatedField2 do not change automatically. Can anyone help me with this.

[George43]

You should use Calculated Value for the field BRW_Overtime_Approved_Date and the field BRW_Overtime_Approved_by .

I have created test-app for this workflow.

 

CheckBox_1_0_2019-Mar-21_1101.zip

[GIOVAN]

Thanks George for taking the effort to do this.
I forgot that we choice Calculated Value in the Details Page.

I have done this, now I am getting the following 2 problems:

1. The formula for BRW_OverTimeAproved_by is good but the Details Page is showing System.Object instead of the Full_Name.

2. When I used the following formula for BRW_OverTime_Approved_Date the Calculated Value give the error the formula is not good.  BRW_OverTime_Approved_Date is an Date/Time field.

CASE WHEN [@field:BRW_OverTime_Approve]=1
THEN 
[@cbTimestamp]
ELSE
''
END

When I change [@cbTimestamp] in GetDate() the formula seems to be okay but on Details Page is showing also System.Object. I never got this System.Object Before.

[George43]

CASE WHEN '[@field:BRW_OverTime_Approve]'=1
THEN 
'[@cbTimestamp]'
ELSE
''
END

I have discovered that behavior with System.Object When you have search section before Details Form. Regarding your second question, you should add '' to your formula

[GIOVAN]

Thanks George for your reply. I added ' ' to the formula. Now this error is showing.

"Incompatible data type. The result of the formula is Text (255) but must be Date/Time."

Any idea why?

[George43]

On 3/22/2019 at 3:41 PM, GIOVAN said:

Thanks George for your reply. I added ' ' to the formula. Now this error is showing.

"Incompatible data type. The result of the formula is Text (255) but must be Date/Time."

Any idea why?

What type of this field in your table?

[cheonsa]

Hello, I know it's a bit late, but for the other that may come across to this post, 

you need to use SysUTCDateTime() instead of [@cbTimestamp].

I tried this and it validates as expected:

CASE WHEN [@field:BRW_OverTime_Approve]= '1'
THEN 
SysUTCDateTime()
END

Assuming that [@field:BRW_OverTime_Approve] is a Text field that's why there's  quotation marks between 1.

 

Hope this helps.

[IamBlossom]

In addition to previous response, here's the available formula in Caspio:

https://howto.caspio.com/function-reference/

 

Cheers!