Jump to content

NailDyanC

Caspio Rockstar
  • Posts

    392
  • Joined

  • Last visited

  • Days Won

    9

Posts posted by NailDyanC

  1. Hi, just to update this post and add in the previous comment above. Yes, by default we cannot call a formula field inside a formula field however you can copy the whole formula that you have in your other formula field so that it can still perform the calculation that  you would like. For example:

    Formula 1:

    [@field:field1] + [@field:field2]

    Formula 2:

    [@field:field2] + [@field:field3]

    In your other formula field you can use the following formula;

    ([@field:field1] + [@field:field2]) / ([@field:field2] + [@field:field3])

  2. Hi,

    As I understand your workflow, you want to extract the text "Code" in the word "Code_Description", right? If that is the case, you may try this formula:

    SUBSTRING([@field:Code_Description],0, CHARINDEX('_',[@field:Code_Description]))

    On 7/26/2019 at 10:46 AM, bbeshlian said:

    Hello,

    I have a field named Code_Description and I want to parse the code into a separate field. The contents of the field are separated by an "_".

    Current State:

    Code_Description
    CDL_Commercial Drivers License

    Desired State:

    Code Code_Description
    CDL CDL_Commercial Drivers License

    I modified a piece of code that was shared with me when I asked about parsing a comma separated filed. The code validates but nothing is returned. Here is the modified code:

    IsNull(Left([@field:Code_Description],(Patindex('%_%', [@field:Code_Description])-1)),' ')

    Any thoughts? Thanks in Advance.

     

  3. Hi,

    Here's another way to extract the "Code" text in your feild:

    SUBSTRING([@field:Code_Description],0, CHARINDEX('_',[@field:Code_Description]))

    On 5/14/2019 at 8:27 AM, bbeshlian said:

    George43,

    I copied your formula to parse a field called "Code_Description". I just wanted to get the "Code" piece in a separate field and the field format is Code_Description. Here is what I used:

    IsNull(Left([@field:Code_Description],(Patindex('%_%', [@field:Code_Description])-1)),' ')

    The formula checks out good but is not returning the "Code". Thoughts?

    Thanks

     

  4. Hi, just to update this post. It seems that the function that you will need is "Right(string,length)"since you will be getting the last number from the right which is 5.

    You may consider this workaround:

    Right((CONVERT(VARCHAR, ([@field: Fieldname]))),1)

     

    Just change the field name based on the calculated field that you are using.

  5. Hi, just to add in the previous comments above, you can also have a field and set the form element of that field to Calculated Value so that  you can store/save its result to the table. In a addition as well with to the triggered action workaround, you may consider checking this video: 

     

  6. Hi @JayDub, that is good to know. However, one problem with it is once you will print/view it in a PDF format, it will only print the first page even if you still have another page for some records. My solution to that is to maximize the number of records that will show in your tabular report so that it will be included in one page printing of your details page.

  7. Hi, just a suggestion. It would be better if you will click save first before redirecting it to a new page. The save button will be the trigger that once it is click it will go to the new page. You may check this post as well:

     

  8. You mentioned that you are using iframes in your DataPages like embedding a DataPage inside of another DataPage, right? Have you tried to check if you are passing/receiving the parameters correctly in the iframes? I encountered one issue in the past that It doesn't load the records in the PDF even if it is showing in the report, what I have done is checked the iframe deployment code if it passes/receives the parameter correctly.

     

  9. Just to add some additional information. In Caspio Release 25, you may now use unicodes. Caspio now supports Unicode symbols so you can display emoji characters and other symbols directly in your apps. They can be used in Tables, Views, DataPages, Email/SMS Notifications, Localizations, Formulas, Triggered Actions and Application Tasks. The supported symbols are listed at https://unicode.org/emoji/charts/full-emoji-list.html.

    image.png.380c0ca114032d9650630a54fbdd2a28.png

  10. Just want to add some additional information. In Caspio Release 25, you may now use unicodes. Caspio now supports Unicode symbols so you can display emoji characters and other symbols directly in your apps. They can be used in Tables, Views, DataPages, Email/SMS Notifications, Localizations, Formulas, Triggered Actions and Application Tasks. The supported symbols are listed at https://unicode.org/emoji/charts/full-emoji-list.html.

    You may try to implement this kind of workflow in your rating app. Like you may add stars and other unicodes in your criteria.

    image.png.380c0ca114032d9650630a54fbdd2a28.png

  11. Just to add and update this post, may this help as well. In Caspio Release 25, you may now use unicodes. Caspio now supports Unicode symbols so you can display emoji characters and other symbols directly in your apps. They can be used in Tables, Views, DataPages, Email/SMS Notifications, Localizations, Formulas, Triggered Actions and Application Tasks. The supported symbols are listed at https://unicode.org/emoji/charts/full-emoji-list.html.

    image.png.380c0ca114032d9650630a54fbdd2a28.png

×
×
  • Create New...