Jump to content

Glitch

Caspio Guru
  • Posts

    114
  • Joined

  • Last visited

  • Days Won

    12

Community Answers

  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.
     
    How about implementing this to your table?
    https://howto.caspio.com/authentications-and-connections/authentication/stamp-a-record-with-user-profile-data/
    https://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/
    Then you can easily pull up that stamped user ID and pass it via trigger?
    Does that make sense?
    Hope this helps 
     
     
×
×
  • Create New...