Jump to content


  • Content Count

  • Joined

  • Last visited

About Tubby

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi Arthur. I found this in Caspio's HowTo Articles: https://howto.caspio.com/function-reference/ I thought it might help you. Check under "Text Functions". Basically, you will just need "N" before the single quotes that wrap your values in the formula field. For example: This way, your values will be converted to NVARCHAR which allows Unicode characters which most other language characters are. This will not affect your normal English characters. Here is a sample output on the table and on a report datapage: It even works with emoticons/emojis. I hope this helps you.
  2. Hi again Hexy! These are the criteria for the different Password Strength: Fair: Password must be at least 6 characters, including at least 1 number. Good: Password must be at least 8 characters, including at least 1 number and both lower and upper case letters. Strong: Password must be at least 12 characters, including at least 1 number, both lower and upper case letters, and at least 1 special character (e.g. _, #, ?, !) You can actually see this criteria if you test the options out and just put 1-2 letters so an error message will display like shown here: I hope this help
  3. Hi @JKSGT, Sorry about my previous message. I think I may have found the ACTUAL solution. What I found is, wrapping your Virtual Fields with single quotes (' ') actually fixes your problem. It gives 12/31/1900 as the result when [@cbParamVirtual2] is null, you don't even need to use ELSE to set it as NULL. Check this formula: CASE WHEN '[@cbParamVirtual2]' IS NOT NULL THEN DateAdd(year, 1,DateAdd(day, -1,CONVERT(DATETIME, '[@cbParamVirtual2]', 103))) END I hope this helps. -Tubbs
  4. I think you can actually use <br> for Calculated Values. However, you will need to enclose it with a single quote. Refer to this syntax: '[@field:Line1]'+'<br>'+'[@field:Line2]' You can also use CHAR(13) which is a SQL Function called "Carriage Return" since Calculated Values accepts SQL statements. Refer to this syntax for CHAR(13): '[@field:Line1]' + CHAR(13) + '[@field:Line2]' This will output the values like shown in the screenshot below: I hope you find this useful.
  5. Hi, I dont have a direct solution for this but I found a workaround if you are trying to achieve the same output as mine. This is what I have: Since I cannot enable data grouping for the ParentID when it is already used for the aggregation and I cannot create a virtual field in tabular reports, I made an addition field in my table and made it a Formula data type. That way I can insert the value of the ParentID to the formula field and use that field in the aggregation instead. Afterwards, I enabled data grouping for the ParentID field and it was automatically ordered by descending the
  • Create New...