Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

About telly

  • Rank
    Advanced Member

Recent Profile Visitors

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

  1. Hi @SunakoChan , If you want to hide the Calculated field you may use this code on the header: <style> #target table:nth-of-type(1) td:nth-of-type(4) {display: none;} #target table:nth-of-type(1) th:nth-of-type(4) {display: none;} </style> </header> <div id="target"> <header> For the reference of this code, you may check this link: https://forums.caspio.com/topic/5323-hide-column-in-tabular-repor
  2. Hi Sunako, You want to dynamically display the image base on the value of a field, this is possible using a Case statement in a calculated field.Below is the step by step instruction on how to achieve this:1. Go the result page then add a calculated field2. Case statement(you need to change the name of the field):CaseWhen [@field:FIELD] = ' ' Then ' 'Else '<img src="IMAGE_URL" />'End3. Add HTML BLOCK4. From there you can call the Field link and the calculated field(Make sure that you render the calculated field as HTML). The format should look like this: <a href="[@field:FIELD]">[@calcfield:1!]</a>
  3. Hi , You want to hide the "no records found" message and also the header of the Page. To achieve this we need to add custom code, below is the other workaround to hide the message and header:To hide the header, follow the following steps:1) Edit Localization, customize the HTML text in the Custom Text by adding div tag:<div id="norecord"><h1>No records found.</h1></div>2) Edit DataPage. Go to the 'Configure Results Page Fields'. Insert Header&Footer.3) Paste the code in the 'Header' field: <span id="HideHeader"><h1>Text</h1></span> Enter your header text instead of Text.4) Paste the code in the 'Footer' field:<script>function func_NoRec_Header(){if (document.getElementById("norecord"))document.getElementById("HideHeader").style.display = "none";}window.onload=func_NoRec_Header;</script>To Hide the message, follow the following step: Go to the Header and paste this code: <style>#norecord{Display:None!important}</style>(For reference you may check this link:https://c0acs764.caspio.com/dp/ba4a60009a119570a12e4c478dc4/files/3879089).For reference you may check these link:- https://forums.caspio.com/topic/3282-hiding-the-header/- https://howto.caspio.com/faq/map-mashup/how-to-hide-the-map-if-no-records-found-on-the-result-page/
  4. Hi @Sansa2016, You need to disable the HTML editor before you input the code. For reference you may check this link: https://howto.caspio.com/faq/web-forms/how-to-disable-html-editor-in-datapage-headerfooter-and-html-blocks/ Have a good one and stay safe!
  5. Hi @VAP1, Just an update, for new version of Styles and when your DataPage's configuration is set to "enable responsive". Here's the new code:Header: <style> #target table:nth-of-type(1) td:nth-of-type(5) {display: none;} #target table:nth-of-type(1) th:nth-of-type(5) {display: none;} </style> </header> <div id="target"> <header> Footer: </footer> </div> <footer> Have a good one!
  6. Hi @SunakoChan, Also, here are helpful links that you can check: - https://howto.caspio.com/datapages/datapage-components/datapage-header-and-footer/ - https://howto.caspio.com/faq/web-forms/how-to-disable-html-editor-in-datapage-headerfooter-and-html-blocks/ - https://howto.caspio.com/datapages/responsive-datapages/modifying-styles-for-tablet-and-mobile/ Regrads, Telly
  7. Hi @SunakoChan, Yes, it is possible, adjust the height of the Drop-down and the options inside. You may paste this code on the header of the DataPage <style> .cbFormSelect{ font-size:26px!important; } </style> Or you may adjust the font size on the style. Just go to Style > Fields > Dropdown/Listbox > change the size. I hope this helps. Regards, Telly
  8. Can I use a wildcard such as % or * in the file name to be collected from the source SFTP folder such as LUTO_Outlet*.csv because the name of the file to be collected will change slightly each time? I find Datahub in general very good, but lacking in certain features which I and other Caspio customers have reported and requested via the appropriate channels.
  9. Can you help with Case Statement involving a date/time field and a number field? I am receiving an invalid formula error on the following: CASE WHEN [@field:Min_Rendered] IS NOT NULL THEN [@field:Reminder_Date] + Try_Convert(datetime, [@field:Min_Rendered])ELSE 'ETA Not Provided'END Reminder_Date is a date/time datatype and Min_Rendered is a number datatype. But the value of the Reminder_Date field upon record update form element is a TimeStamp My current workflow: When the User submits the record, they fill out how many minutes they are from the location site. Upon submit there is a Timestamp. For the Company user, when they view the record, I am trying to give the estimated ETA. So the timestamp + the number of minutes. The sample result should be: 1/19/2020 11:29 AM The time of 11:19([@field:Reminder_Date]) + the Value of the minutes 10([@field:Min_Rendered]).
  10. I’m looking to create a report of given table with a timestamp field that should give me Count of records group by Cole_ID and Minute submitted of timestamp field.So for example the following table If same Cole_ID was entered 3 times at same minute, it should give only one record listing the Cole_ID with count 3. I need a group by query against the entire table, the purpose of this is to see how many records where edited at the same minutes (we are suspecting a system error). How can I accomplish that with Caspio?
  11. telly

    Data Page Name

    Hi, Is it possible to get the name of the DataPage and display it on the Header?
  12. Hi , I need help with formatting the Date, as of the moment the format that I have is 01/01/2020 and I want it to be display like this January - 01 - 2020. Is this possible? Thanks.
  13. Hi Frank, thank you for confirming. I added the responsive code, still can't replicate the issue. It would be helpful if you provide the link of the DataPage that has this issue for us to be able to test on our end. Thank you. -Telly
  14. Hello Frank, We implemented a Caspio Mobile Kit and set the field to autocomplete. However, we wasn't able to replicate the issue. We tested it using android phone and iPhone and both are working. Please refer to these screenshots: May I know what browser did you use, version of your iPhone and type of deployment that you used? Thanks, Telly
  15. Hi - I need to use a font "Poiret One" one of my DataPage, I tried to set the style inside the header and add !important, but no luck. Here is my screenshot of the DataPage Also is the font that I wanted: Thank you in advance.
  • Create New...