Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Barbie

  1. Hi @Batchini you can create a formula field in your table for Month and paste this code: Datepart(Month, [@field:Date]). Make sure to change the field name. And on your DataPage, select the Month field and set it to 'Dropdown'. You may refer to this screenshot: https://c0acs764.caspio.com/dp/ba4a60009a119570a12e4c478dc4/files/3294662 The return value of the formula that I have provided is 1 to 12. So if we are trying to get the Month we will use that 1-12 as the value. Hope it works for you -Barbie
  2. Unfortunately, there are no options for us to track the past users who recently logged in and searched for the records in the DataPages. In line with that, we have a workaround for some modification to your current DataPage to track the user's email address in the future. Here are the steps: 1. Please follow this article but we will also add minimal modification: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ 2. Afterward, you need to add an Email field in your table. On your DataPage configuration, make this field 'Hidden' and set the On Load to 'Authentication Fields'. you may refer to this screenshot: https://c0acs764.caspio.com/dp/ba4a60009a119570a12e4c478dc4/files/3329998. For this, you will be able to stamp the Email of the users in the table who tried to search in the Search Form. I hope this helps and please let me know if you have further question. - Barbie
  3. Hi @telly, Yes, it is possible. You need to add a Header and Footer in your DataPage and paste this code in the Header. form[id^="caspioform"] { display: inline-block !important; } div[id^="cbOuterAjaxCtnr"] { display: block !important; text-align: center !important; } I hope this works. -Barbie
  4. Hi @Batchini, Since you are aggregating you need to add a sum in every field. Please use the code below instead. (SUM([@field:field]) + SUM([@field:field2])+SUM([@field:field3]) + SUM([@field:field4]))/ NULLIF(SUM([@field5]),0) I hope this works.
  5. If you want the Rules to work, please remove the script and checked this forum post that will make your field non-editable and will still work using rules :
  6. Hi Batchini, Please add a Header and Footer in your DataPage and paste the code below in the Header. <style> .ListData .Item { float: left !important; } .ListData .Body { width: 400% !important; } .ListData.ListBox.cbFormSelect { border: none !important; box-shadow: none !important; } .ListData.ListBox.cbFormSelect{ height: 40px !important; } </style> I hope this works for you. -Barbie
  7. Hi Batchini, for you to be able to get rid of the extra boxes, I suggest to add a Header and Footer in your DataPage and paste the code below in the Header. (Refer here for more info: https://howto.caspio.com/datapages/datapage-components/datapage-header-and-footer/) <style> tr, td { border: none !important; } </style> Please note that you need to disable first the HTML Editor before pasting the code. You may refer to this article on how to do so: https://howto.caspio.com/faq/web-forms/how-to-disable-html-editor-in-datapage-headerfooter-and-html-blocks/ I hope it works. -Barbie
  8. Hi @Role21, You can also add a custom image by just inputting the link of it. You can refer to the screenshot. I hope this helps. Regards, Barbie
  9. Just to add, you can refer to this articles on how to create a tasks and triggered actions: https://howto.caspio.com/tables-and-views/triggered-actions/ https://howto.caspio.com/tasks/ I hope this helps. Regards, Barbie
  10. Hi Batchini, You can achieve that by following the steps below. 1. Add a field in the table and set the Data Type to 'Formula'. 2. On the right pane of your Formula field, in the Options section, click Edit and paste this code: CAST([@field:Date] AS DATE). Please make sure to change the field name. 3. Create a Triggered action that will update the date with the formula field. 4. Create a Task that will automatically insert the current date on your table daily. Please see attached file for reference. I hope it helps. Regards, Barbie
  11. Sometimes, we want to import an object but we need to back up our original data from our table to make sure that if we encounter errors, we would be able to retrieve our original data. To achieve that, we need to check this " Back up the above objects prior to import (accessible in the Messages area)." Message upon import. When checked and the import is a sucess, there should be an exported message with file included that indicates the date for the date of your import. The export message will be generated at the same time as the import message. The backup file is the export file, which could be used to restore. In all other relations with Importing of Data, visit this article: https://howto.caspio.com/tables-and-views/importing-data/ I have also attached a file for reference.
  12. Can you please try to add a Header and footer on your DataPage paste this code in the header: <style> #InlineAddComment { width: 500px !important; } </style> You can change the 500px to your desired width. I hope this works for you. -Barbie
  13. Yes, that is possible. On your 'Comment' field, click the Advanced tab and under the Layout Options change the 'Field width' to Pixels instead of Auto for you to be able to change the width based on what you prefer.
  14. Yes, you can achieve that. You may try this code: <div style="text-align: center; font-size: 15px; "><input style="background-color: #FFC433" class= "cb_custom_btn" type="submit" value="Click to Purchase your Ride"/> You can change the #FFC433 to your preferred background color.
  15. Hi @telly, Can you try this code instead: <div style="text-align: center; font-size: 15px; "> <input class= "cb_custom_btn" type="submit" value="Click to Purchase your Ride"/> I hope this works.
  16. Hi, Can you try this code instead? CONVERT(DATETIME, [@field:date_start], 114) CONVERT(DATETIME, [@field:date_end], 114) I hope this works for you.
  17. Hi, you can also check the limitations of Rules here: https://howto.caspio.com/datapages/forms/conditional-forms/
  18. Barbie

    Modified By

    Hi Telly, In your Tabular DataPage include your "Modified By" field in your Details page and set the form element to "Hidden" and then on the On Load, receive: choose the Authentication Fields and the fields that you want to display. Next is, add a Virtual field Label it as "Modified By" and set the form element to "Display Only". Under the Advanced tab check the On Load and choose the Data Source Fields and get the "Modified By" field. We used this Virtual field to display the Modified By in your DataPage since we set the Last Modified to "Hidden" I hope this helps. Thanks, Barbie
  19. <style> input[name*="InlineEdit"]{ color: black !important; } </style> I just made a minimal modification on kpcollier's code.
  20. Hi, yes that is possible. Follow these steps: 1. Go to the Styles and then click Edit 2. On the DataPage elements, under 'Results Page' click Paging. 3. On the Settings tab > Paging Control Cell 4. Change the alignment to 'middle-left' Please see screenshot for reference.
  21. Hi Batchini, Yes, that is possible. You need to add a Header and Footer on that particular DataPage. And then paste this code in the Header: <style> input[name*="InlineEdit"]{ font-size: 10px; } </style> Note: You need to disable first the HTML editor under Advanced Tab before pasting the code. Also, you can change the font-size based on your preferred size. I hope this works for you.
  22. You may also want to watch this video to quickly understand how to implement the Record Level Security on your App:
  23. You can also refer to this link on how to create a calculated field in a Report DataPage https://howto.caspio.com/datapages/datapage-components/calculated-values/
  24. Hi Watusi, You can try to paste this code in your header instead: <style> input[class*="cbSearchButton"]{ display:none !important; } </style> I hope this works for you.
  • Create New...