 114

• Days Won

12

1. Glitch's post in Adding a Prefix with Calculated Value was marked as the answer
Hi there,
Are you doing this formula using a Calculated Field?
I think you need to convert the Virtual field first as a character.
I tried this on my end and the formula worked!
'2-' + CAST([@cbParamVirtual1] as VARCHAR)
I hope this helps.

Glitchin'
2. Glitch's post in Formula and " Record cannot be saved because an error was encountered in Triggered Actions." was marked as the answer
Hi @Becca37

Can you try out this formula?:
CASE WHEN Isnull([@field:StatusOverride],0) != 0 THEN [@field:StatusOverride] WHEN Isnull([@field:StatusOverride],0) = 0 THEN CASE WHEN Isnull([@field:DateOpened],0) = 0 AND Isnull([@field:DateOpened],0) = 0 THEN 'PENDING' WHEN Isnull([@field:DateOpened],0) != 0 AND Isnull([@field:DateOpened],0) = 0 THEN 'OPEN' WHEN Isnull([@field:DateOpened],0) != 0 AND Isnull([@field:DateOpened],0) != 0 THEN 'CLOSED' ELSE 'ERROR' END END I'm thinking, we should first isolate the Cases for the Override.

This formula works provided that the Field StatusOverride is a number.

Now if that field also includes text, this formula should work:

CASE WHEN [@field:StatusOverride] != '' AND [@field:StatusOverride] != '0' THEN [@field:StatusOverride] WHEN Isnull([@field:StatusOverride],0) = 0 THEN CASE WHEN Isnull([@field:DateOpened],0) = 0 AND Isnull([@field:DateClosed],0) = 0 THEN 'PENDING' WHEN Isnull([@field:DateOpened],0) != 0 AND Isnull([@field:DateClosed],0) = 0 THEN 'OPEN' WHEN Isnull([@field:DateOpened],0) != 0 AND Isnull([@field:DateClosed],0) != 0 THEN 'CLOSED' ELSE 'ERROR' END END
Both formula works on my end. I used the second one here. See attached screenshot.

Let me know if this works!

Glitch.
3. Glitch's post in Insert Data Into Log File (Table) was marked as the answer
Yes, this would be doable via trigger.
As you mentioned, you know how to set the trigger up.

It should be something like this right? But you need to pass a value from the inserted to the log file table.