Jump to content

All Activity

This stream auto-updates     

  1. Past hour
  2. My dear friend Archie from Caspio Support was able to assist me. Here is the solution in case this helps anyone else. He also shared this very helpful URL with me: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/
  3. Today
  4. Hi, Hoping to get some guidance with the following please: I would like the report to only be visible if the following three conditions are met: (It worked great until I added the third criteria at the very bottom.) Thank you in advance!
  5. Thank you @LittleMsGinger ! Will certainly try and status accordingly. Appreciate your time!
  6. You can also use an HTML Block with an <img> tag.
  7. You can refer to the this post for one solution to this using HTML Block.
  8. Yesterday
  9. DruidCtba

    Image of a URL

    How do I display an image of a URL? Something like this Att. Druid®
  10. DruidCtba

    Layouts

    One last question, my friend @Vitalikssssss, that could solve this problem of mine by the logic of the Caspio service but I was unable to solve it, is about parameters to be passed. For example in my case if I create a virtual field like a radio button and pass the chosen value to the real field, it should not pass the chosen value to this field, and then I could use a RULES that if the chosen field is ANOTHER with the EQUAL BLANK value, would it make this field editable for the user to enter the value of his choice different from what I gave as default options? I tried but it didn't happen, it even takes before I choose an option a random value from the radio button options, because it doesn't work, wouldn't that be the idea of passing parameters? Regards Druid®.
  11. Great thread y'all! Hoping this one is easy I would like to change the font in my Tabular report based on two keywords: "Completed" Green Font "Incomplete" Red Font Thank you in advance!
  12. Hi, just to inform everybody, Caspio released its 21.5 version. This release includes bug fixes, security enhancements and performance improvements. For more details here is the link: https://howto.caspio.com/release-notes/caspio-bridge-21-5/
  13. Hi, just to inform everybody, Caspio released its 21.5 version. This release includes bug fixes, security enhancements and performance improvements. For more details here is the link: https://howto.caspio.com/release-notes/caspio-bridge-21-5/
  14. This link might be able to help as well: https://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/
  15. Hi @Lamin, it is not recommended in wix as the website automatically treats custom codes (such as Caspio's deployment codes) as a foreign one, meaning as a security measure: They are automatically setting it as iFrame codes, making a lot of functions limited such as passing of parameters and more.
  16. Last week
  17. DruidCtba

    Layouts

    Ah yes, now I understand the logic my friend @Vitalikssssss, but this will create another problem that is insoluble from my point of view, I already have data in my table and there are few, 9,878 rows in my table, if I use the TYPE field as a field calculated i lose all the information i already have in this column, this is not feasible for me. But now I have a question, if I have to create two more fields to use this logic that was suggested to me, I would not be creating extra fields in my table and in return this would not be very productive since it increases the size of my table in the database with unnecessary fields? Regards, Druid®. P.S. To test I created three fields: Tipo_Teste, Aux_Tipo and Aux_OutroTipo, but CASE in the calculated Tipo_Teste field works, but for me as I said it is not viable, because the real TYPE field already contains information that I cannot lose. P.S.2. How such a simple thing can become so complicated since the CASPIO service didn't think like google docs thought more sens
  18. DruidCtba

    Layouts

    Sorry my friend @Vitalikssssss, but I didn't really understand this logic field Caspio's formula for my case. I think you understand my problem and know Caspio in depth, so if possible you could show me step by step how I do this to solve this simple problem of having more options than those presented on radio buttons or dropdowns for a given field. my table? I imagined an AUX_TIPO field and the original TIPO field, but the TIPO field being a calculated field that would have a value other than those presented to the user, where would I allow the user to enter this value? That is what I have not understood so far. Regards, Druid®.
  19. Hello @Umbie, You have 2 options: 1. First create relationships between tables and then build a View based on these tables. In this case when you create a View, on the View Properties screen, the relationships are build automatically. 2. If relationships are not set up and you join tables in a View, you should choose the fields to join tables manually on the View Properties screen. Also, please note that you may find some helpful features only in the Relationship Settings. For example, Enforce Referential Integrity between parent and child table, Display value instead of the ID on the DataPage level. Here is the article about the Relationship Settings https://howto.caspio.com/tables-and-views/relationships/relationship-settings/ Hope this helps.
  20. Hi @Lamin, I think you a referring to Wordpress.com which actually do not support 3rd party Javascript codes. I can recommend using Wordpress.org, Weebly, Yola CMS for deployment of Caspio Datapages. Regards, vitalikssssss
  21. @Hastur Thank you so very much! It worked. I truly appreciate you taking the time to respond! Regards, Kevin
  22. Hello @taylorswiftlover, According to the documentaion, SysDateTime() function returns current system timestamp. More details can be found here: https://docs.microsoft.com/en-us/sql/t-sql/functions/sysdatetime-transact-sql?view=sql-server-ver15 Also, you can use the following function to get UTC date and time - SYSUTCDATETIME() To make it more relevant to another timezone you should use Dateadd() function. More details can be found here: https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver15 Hope it helps.
  23. Hi @DonateGood, You can use Triggered Action feature in order to create this type of functionality. 1. You need to add new field based on which Triggered Action executes. 2. Create a Triggered action which will fire on update event. Note: You will need to use two blocks. First block "Insert" going to copy the record if the checkbox is checked and the second one "Update" will uncheck the box after copy has been made. Please note that you will need to click on "Refresh" button in order to see new records which has been copied. Hope this helps. Regards, vitalikssssss
  24. Hello @KevinCeres You can achieve this using standard features. You can add the Virtual field to your form with 2 option: stay at form after submission or go next. The values of these radio buttons should be links. Based on the choice, your user will be redirected to the same page (reload) or to a new one. Check the print screens:
  25. Hi @jeffd2652, Date&Time stored in Caspio table always use a US formatting and there is no way to change this setting. You can use Localization in order to change the format how it appears in Datapages. Regards, vitalikssssss
  26. Hi @kenni11, It is doable in Caspio. You need to use a Submission Form type of Datapage along with Calculated value form element. Here is a video which covers above features of Caspio:
  27. Vitalikssssss

    Layouts

    Hi @DruidCtba, Indeed, Free account do not have access to features like Triggered Actions or Calculated value. You may use Formula field with CASE logic in table level. Formula fields available in Free account. https://howto.caspio.com/tables-and-views/data-types/formula-fields/ Your CASE expression can look like this. CASE WHEN [@FIELD_A] = '' THEN [@FIELD_B] ELSE [@FIELD_A] END Hope this helps. Regards, Vitalikssssss
  1. Load more activity
×
×
  • Create New...