Jump to content

Nuke354

Caspio Ninja
  • Content Count

    28
  • 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. You should create a header and footer and we will add a CSS style to modify the "View Details"'s position. Here's the code: <style> .cbResultSetPanelColumnarRAContainer:hover { margin-top: -[height here] !important; } .cbResultSetPanelColumnarRAContainer { margin-top: -[height here]px !important; } </style> You may have to adjust depending on the height of each item. Hope this helps.
  2. You should set the number of records in results page to 1 and define sort order by timestamp field in Search Results Options of a Report DataPage. Choose List Report type if you prefer list layout versus tabular. If you desire the Details page format then enable Details page and checkbox "Always skip results page when only one record found". Steps are listed below: 1) Create a tabular (or list depending on the desired look) report DataPage 2) Enable Advanced Options and Parameters 3) Navigate to Search Results Options 4) Change the default sort order to timestamp field from the dropdown (make is Z to A) 5) Change Records per page to 1 6) Go to Advanced tab, select radio button for total records returned and type 1 Follow next steps if you want Details page: 7) Enable Details page and check box for "Always skip results page when only one record found" 8) Select any field in the details page and click Finish
  3. For you to be able to implement this process in your end, follow these steps: The file name or path should be saved inside your table with File DataType field -> then create a Report DataPage(tabular) -> use the File field in the report page and the data will be downloadable by anyone(check the screenshot). If that is not what you wanted, please elaborate you inquiry further. Note: If the file is "image", it will just display and unable to download it. I hope this helps.
  4. If you want to put combine a text field with the hyperlink, you can create an HTML Block and follow the following format: [@field:Text] <a href="[@field:Test_File/]" target="_blank">[@field:File_Description]</a>
  5. Can you explain more on where you are putting the hyperlink? Is it like the image attached? If that is the case, I highly recommend going to this link. It seems like you are facing the same issue in the given link.
  6. Yes you can make a download but this needs little bit of Javascript: First you need 2 DataPages: A Report DataPage A single Record Update form The workflow is similar to this article where the single Record Update Form with a View Counter and a download link. In your Report DataPage, you should create a link that redirects to your submission form. In your Single Record Update From, we need to hide the fields just like in the linked article above. Then set the file counter field to a View Counter Then add this code example: <script> window.location.href = "[@field:Music_File/]"; setTimeout(func, 500); function func() { window.close(); } </script> We create a delay to before closing the window so the download cannot trigger multiple times when the tab is closed. You should now be able to count when the download link is clicked. Hope this helps!
  7. You can retain the code in the HowTo article but slight modifications. We use the concept of https://www.w3schools.com/cssref/sel_nth-child.asp to achieve this Here's the code: <script> var isi = document.getElementById('visi[@field:ID]').parentNode.parentNode; if('[@field:Sales#]' > 500){ isi.querySelector('td:nth-child(4)').style.backgroundColor = '#A1DE93'; } else{ isi.querySelector('td:nth-child(4)').style.backgroundColor = 'red'; } </script> You could also check this deployed Datapage URL: https://c0dcd456.caspio.com/dp/ad9b7000d75f22b3a5474682b6db
  8. You could try using CSS to acheive this. Just add a Header and Footer element to your DataPage. Then use this code, th:nth-child(4)[class*="cbResultSetLabel"]{ text-align: left!important; } td:nth-child(4)[class*="cbResultSetData"]{ text-align: left!important; } The child number is dependent on what column you want, you may to play with the child number value to achieve your desired outcome.
  9. 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.
  10. 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.
  11. In addition, you could also try visiting this article for more info. Hope this helps.
  12. 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.
  13. 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.
  14. 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/
  15. 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
×
×
  • Create New...