Jump to content

Nuke354

Members
  • Content Count

    20
  • Joined

  • Last visited

  • Days Won

    1

Nuke354 last won the day on July 9

Nuke354 had the most liked content!

1 Follower

About Nuke354

  • Rank
    Member

Recent Profile Visitors

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

  1. May you please try the formula syntax below: ----- [@field:Field1] + CASE WHEN DATALENGTH([@field:Field2]) = '' THEN '' ELSE ' Citation: ' + [@field:Field2] END ---- This should always output the first field and concatenate the second field, if the second field is not blank. It is possible that you have forgotten to put an ELSE block in your CASE Statement when you tried to do so. This is important because if the CASE Statement is not satisfied, it will return NULL. And doing operations with NULL values always results to NULL.
  2. If you want to change the font size of the text fields, go to Styles-->Form/Details--> Fields . There is a drop down list there where you can change the font size of the text fields. If you want to change the font size of something specific, you may check the "Source" tab. It is accessible by clicking the "Source" button besides the "Settings" button. You will find the Style codes in there where you can manually check and edit the font size as well as any other styles.
  3. In addition, you could also try visiting this article for more info. Hope this helps.
  4. If you want to change the font size of the text fields, go to Styles-->Form/Details--> Fields . There is a drop down list there where you can change the font size of the text fields. If you want to change the font size of something specific, you may check the "Source" tab. It is accessible by clicking the "Source" button besides the "Settings" button. You will find the Style codes in there where you can manually check and edit the font size as well as any other styles. Hope it helps.
  5. In order for you to apply all of these in your DataPages, you will need to modify your styles and apply. Just go to Styles > Edit Style > Table Layout > Data Cells > Layout Options set to "No Wrap". I hope this helps. Thank you so much.
  6. To prevent these attacks, you can use IP filtering. The other recommendation would be to add captcha to public submission forms. This would prevent it from an automatic (made not by humans) submissions. For more information on our CAPTCHA feature: https://howto.caspio.com/datapages/datapage-components/captcha/
  7. Nuke354

    PDF Report Page

    For Build plans and higher, the PDF is available by default. However, you can only enable PDF Download in our Results DataPage. You can only set the fields in your Details page as the source of your PDF. Note that it is not possible to download the Details Page exactly how it looks. However, there is an alternative solution to this, create a separate Details Page and then Use CRTL + P then choose “Microsoft Print to PDF”. You can also check this similar forum post about this inquiry on how to integrate a third party PDF generator in your details page: https://forums.caspio.com/topic/4911-wanted-to-share-this-third-party-pdf-generator/?page=0#comment-15421
  8. You may have to use Triggers since you need the calculations to adjust for ongoing evaluations and filter out only the submitted values but we need more information on your workflow to further understand your issue.
  9. For you to resolve the error message, please try this formula instead: CASE WHEN ([@field:Member_status] ='Hibernated 2018/19') THEN 'N/A' ELSE (SELECT ([@field:Sub_status_summary]) FROM m_membership_master_accounts WHERE Account_Email=target.[@field:Account_Email]) END Hope this helps.
  10. Here is an example to change document.write code from https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-generating-geolocation-coordinates-from-web-form-submissions/ article: 1. Define an id of some type <p>, <span>, etc. outside the <script>. 2. Within the script, then add the innerHTML code. <span id="error_message"> </span> <script type='text/javascript'> . . . document.getElementById("error_message").innerHTML = "This Datapage require Standard Caspio Deployment for full functionality." ; . . </script> In your case, if I take one example: <table width="600" border="0"> <tr> <td width="130"> <span id="font_change"> </span> <script type='text/javascript'> document.getElementById("font_change").innerHTML='<span style="font-family:arial;color:#425A10;font-size:15px;"><b>Operator:&nbsp;&nbsp;</b></span>'; </script> Please try the above format for all your document.write statements. I hope that helps.
  11. The answer to your question is yes. We can do a SELECT from a view in a calculated field. When doing so, we need to prepend the name of the view with "_v_" (Without the quotes). For example, if the name of the view is MyView, we refer to it as _v_ in the Calculated Field. I hope this information helps. Let us know if this works for you.
  12. If you want to calculate all the fields even if there are some blanks values to the other fields, you may use ISNULL for that. Let say: ISNULL([@fieldTest1],0) + ISNULL([@field:Test2],0) + ISNULL([@field:Test3],0) You may follow and continue that format until "ISNULL([@field:Testxx],0)".
  13. You could use one or more SELECT statements by separating them by parenthesis Example: (Select)-(Select)
  14. What you can do is use this task trigger config as a template if you want to combine the old table data plus the newly inserted data. With this, you can different sorts of operations and to manipulate values (pre-insert values and post-insert value) using a trigger upon insert.
  15. Hi @Altair Unfortunately, it is not possible to store text larger than 64000 characters in the table. This limitation is set by design. You can enable 'Display remaining characters' in the text area section and store your text in the two or more fields. In this case, you should divide your text according to the remaining characters.
×
×
  • Create New...