Jump to content


Caspio Moderator
  • Posts

  • Joined

  • Last visited

  • Days Won


sandy159 last won the day on June 19

sandy159 had the most liked content!

Recent Profile Visitors

498 profile views
  1. Hi @paulbennis, Yeah, you may change the white-space attribute for the label to nowrap and adjust the field width a little bit. Or you may play around with alignment. Try to paste this CSS to the Header of the DataPage. Make sure to disable the HTML editor in the Advanced tab first. <style> .cbFormNestedTableContainer{ align-items: end; } </style>
  2. Hi @pmcfarlain, It should be possible to change it in Styles. Go to Styles -> Form/Details -> Layout -> Label Cells. Change the 'Wrap Text' attribute to 'No Wrap' As another option, it is possible to change directly on the DataPage. Paste the following CSS to the Header of the DataPage. Make sure to disable the HTML editor in the Advanced tab first. <style> .cbFormLabelCell { white-space: nowrap !important; } </style> Hope this helps! Feel free to update this thread in case of further questions.
  3. Hi @pmcfarlain, I have done some research on it before as well, looking for the best CMS compatible with Caspio. I know you were looking for some other options but I would only recommend using Wordpress.org or Weebly CMS for deployment of Caspio Datapages. It is also possible to use GoDaddy but only for the Web Hosting for FTP-deployment approach not like the site builder. Here is related forum post as well: Regards, Sandy
  4. Hi @BGrambo, This error usually appears when the SELECT expression returns an array of values instead of single value. You may try to add the TOP 1 statement like this: SELECT TOP 1 CreditHold FROM CompanyCreditHolds where CompanyName = target.[@field:CompanyName] Here is the related forum post as well: Feel free to update this thread if it is not the case and the error still exists.
  5. Hi everyone! I had the same question on how to calculate median and found out that there is no built-in function in SQL for that I have found a workaround though, here is my example: SELECT ( (SELECT MAX(Price) FROM (SELECT TOP 50 PERCENT Price FROM Products_sold ORDER BY Price ) AS BottomHalf) + (SELECT MIN(Price) FROM (SELECT TOP 50 PERCENT Price FROM Products_sold ORDER BY Price DESC) AS TopHalf) ) / 2 AS Median Where 'Price' is the field name, 'Products_sold' - table name. You want to make sure to change these to your field/table names. Here is a helpful external resource as well: https://stackoverflow.com/questions/1342898/function-to-calculate-median-in-sql-server I hope that it will be helpful for someone!
  6. Hi @wdandrewsshpg, If I understand you correctly, you are talking about the Keyword Search across multiple fields. You may check the article on how it can be implemented: https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/ Feel free to update this thread if you were looking for something else or if you have questions. Regards
  7. Hi @Sam23, You may want to set two criteria for the search field with the "OR" Logical operator between them. More information in the article: https://howto.caspio.com/faq/reports-datapages/how-to-add-today-to-after-now-or-next-x-days-criteria/ Regards, Sandy
  8. Hi @Sam23, Basically, for the cascading dropdown to work, it should always have the parent field. As a workaround, it is possible to receive a parameter to the parent field and then hide the field with some CSS. So in total, the dropdown list will be filtered based on the received parameter but it will not be visible to the end-users. For example, if I want to filter the City Name based on the received State abbreviation. The StateAbbr is set to receive External parameter on load. And then it is hidden with the solution from this article: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ The CityName field set up as a usual Cascading Dropdown: I hope that will help! Feel free to update this thread if you have further questions.
  9. sandy159

    Referral Link

    Hi @Benades, Looks like passing Parameters as Query String Values will be a good fit here: https://howto.caspio.com/parameters/parameters-as-query-string-values/ For example, http://www.site.com/registration.html?rid=[@field:Referrer_ID] Then you need to receive the parameter as [@rid] in the registration form : https://howto.caspio.com/parameters/receiving-parameters/ Hope this helps!
  10. Hello @AccessNerd, The font size in the iFrame changes since the browser treats it as the smallest breakpoint and increases the font size as it does for tablets/mobile phones. As an option, the iFrame can be resized by defining a style attribute and width:100%. You may check the article: Remove iFrame Border and Change Size Another way, is to change font size in Styles for tablet/mobile screens. Go to Styles -> Source -> All -> find .cbResultSetData class -> change font size Hope this helps!
  11. Hi @RunForrestRun, If you want to change the font color of the current record page on all Detail's DataPages then it is possible in Styles: Go to Styles -> Form/Details -> Navigation -> Current Record For more in depth customization, go to Styles -> Source -> All -> Find .cbFormJumpToTextField class -> change color or other attributes to the required value Hope this helps!
  12. Hello @PeterER8, If you want to make the Grid Edit to display as Default upon load, you may find the following forum post helpful: Regards
  13. Hello @PeterER8, Yes, it is possible to change the Label names in the Localization settings. Go to Localizations tab -> Results page -> Labels and Markers -> Grid Edit -> Custom Text Hope this helps!
  14. Hi @Arundhati, Please take a look at the URL on the webpage with 404 error. You may need to disable the 'Relative' checkbox to be redirected to the correct webpage. Hope this helps! Feel free to update this thread if you have further questions.
  15. Hi @georgep, For the Display only fields on the Details page, it is possible to change styling in the Styles tab. It should be needed to add the 'min-height' to make the fields look the same. You may go to Styles -> Form/Details -> Layout -> Source. Find .cbFormDataCell and .cbFormDataCellNumberDate classes and set the 'min-height' property to the needed value. So even if the field will be empty, the data cell will have min-height to it. Hope this helps!
  • Create New...