Jump to content

telly

Caspio Guru
  • Posts

    137
  • Joined

  • Last visited

  • Days Won

    2

telly last won the day on February 1

telly had the most liked content!

Recent Profile Visitors

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

  1. Hi @SunakoChan, The easiest way that I can think for tabular is to add the code on the actual label like this: Basically you will add the start tag before the label value, then end tag on the end of the label value. <div style="color:#00d7ff;">User ID</div> It will look like this: I hope this helps
  2. Hi @SunakoChan You can also check their documentation for guidelines: https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/https://howto.caspio.com/tech-tips-and-articles/common-customizations/render-date-range-in-calendar-datapage/
  3. Hi @SunakoChan, For you to achieve that you will need to have a separate Search and Report to filter the two fields at once. You can follow the instruction bellow: 1. Create your Search form and add two Virtual fields, enable 'Calendar popup' then go to the Advanced tab, and enable the 'On exit: Pass field value as parameter' for both virtual fields then saved your search form. 2. Next, create a Report Data page, choose 'Filter data based on your predefined criteria, then select the two fields you will be using. On the picker, click 'New Criteria' for both fields, and for the 'Criteria 1', choose 'Greater than or Equal' as the comparison type, and then put the parameter name of your Virtual 1 in the 'Value' section. For the 'Criteria 2,' choose 'Less than or equal', for the comparison type, and the parameter name of the Virtual 2 on the 'Value' section. The example is, if you enter a date from 7/01/21 to 7/31/21, it will show all the results within that range. By only entering a date in the 'from' field, it will only show the dates that are greater than or equal to that date. In contrast, if you only input a date in the 'to' field, it will only display results that are less than or equal to that date. I hope this helps.
  4. Hi @pmcfarlain, You can use CSS :nth-child() Selector for change the color of the column, Below is the example code that you can use, simply add it on the header of the DataPage: Note: Change the number inside nth-child(1) to the number of your column and background : change to your preferred color/color code. <style> [class*=cbResultSetHeaderCell]:nth-child() { background: Green!important; } </style>
  5. Hi @SadAko, The difference between IsNull and Is NULL, We use IS NULL to identify NULL values in a table. ISNULL() function lets you return an alternative value when an expression is NULL. For reference you can check these links: - https://www.w3schools.com/sql/sql_isnull.asp - https://www.sqlshack.com/sql-isnull-function-2/
  6. Hi @jayzk1e02, Have you tried to disable the ajax loading and check if it will work? For more information you may check this link: https://howto.caspio.com/datapages/ajax-loading/
  7. Hi @tuanlaptopgaming, You can use Rules or conditional forms, First include the Yes or No field then add virtual field to check the value: Then add rules: Expected result:
  8. Hi @pmcfarlain, You can use CSS :nth-child() Selector for change the color of the column, Below is the example code that you can use, simply add it on the header of the DataPage: <style> td[class*="cbResultSetData"]:nth-of-type(){ background-color: Green!important; } </style>
  9. Hi Sam, It seems that it is possible using a auto-submit/ auto-update. Once the user click check on the Yes/No field or checkbox then it will automatically submit or update a record on the other table. You can use this link as reference you can change the condition based on your workflow:
  10. Hi @captnjames, You can use this code, however it is only applicable if the DataPage is not responsive: <style> .cbComboBoxContainer{ -webkit-column-count: 5; /* Chrome, Safari, Opera */ -moz-column-count: 5; /* Firefox */ column-count: 5; } .ListData.ListBox.cbFormMultiSelect { height: 500px!important; } .cbFormMultiSelect{ border:none!important} </style> Please note that if the value/options is more than or less than 20, you may adjust the height value.
  11. Hi @AyezaKhan, You need to disable the HTML editor before pasting the code on the Header, for reference you may check their documentation: https://howto.caspio.com/faq/web-forms/how-to-disable-html-editor-in-datapage-headerfooter-and-html-blocks/
  12. Hi @Yelbic, You need to add field with Data Type file in the table for you to be able to add file or images: - https://howto.caspio.com/files-and-images/uploading-files-and-images/ - https://howto.caspio.com/files-and-images/referencing-your-files/
  13. Hi @PeterER8, If you want to automatically populate the values of the fields based on the value of the other fields you can use cascading element you may check this link: https://howto.caspio.com/datapages/datapage-components/cascading-elements/ If you want to save multiple records in one submission form, you can use trigger action for this, for more information you may check this link: - https://howto.caspio.com/datapages/datapage-components/cascading-elements/ -
  14. telly

    Cannot Edit Fields

    Hi @SuperNam, This usually happen if you are using different table for editing in the view, you can only edit the fields in one table. For more information you may check this link: https://howto.caspio.com/tables-and-views/what-are-views/views/
  15. Hi @Gabriel, You may check this link for media queries: https://www.w3schools.com/css/css_rwd_mediaqueries.asp I hope this helps.
×
×
  • Create New...