Jump to content

All Activity

This stream auto-updates     

  1. Past hour
  2. Meekeee

    Forum App?

    Hi @waltmayo, You can check the Caspio's ready-made apps here: https://www.caspio.com/apps/ For the forum you want, I think the closest to this is the FAQ Manager: https://www.caspio.com/faq-manager/ I hope this helps!
  3. Today
  4. directrix

    Floating Nav

    I followed the article found at your site: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-creating-a-floating-navigation-menu/ but I cannot make it to work. Please help. <style> #menu { margin:0; list-style: none; width: 140px; text-align: center; } #menu li { font: 90% "Arial", Arial, Helvetica, sans-serif; margin: 0; padding: 0; } #menu a { background: #222; /*Standard Color*/ border-bottom: 1px solid #000000; color: #ccc; display: block; margin: 0; padding: 20px 12px; text-decoration: none; } #menu a:hover { background: #004400; /*Hovered Color*/ color: #fff; text-shadow:#ffffff 0px 0px 5px; /*Text Glow*/ padding-bottom: 20px; } </style> <div style="position:fixed; top:0; right:0;"> <ul> <li><a href="link1" title="Link1">Link1</a></li> <li><a href="link2" title="Link2">Link2</a></li> <li><a href="logoutURL" title="Logout">Logout</a></li> </ul> </div>
  5. LunaLovegood

    API Authentication

    Hello Medron, Caspio Bridge REST API authentication is based on OAuth 2.0 protocol and supports client_credentials flow, meaning that before a client can access Caspio Bridge resources, it must be authenticated using Client ID/Secret pair (can be found once you started creating WSP or Web Services Profile). And all REST calls should be made in HTTPS. When successfully authenticated, a token is generated that must be used in all follow on calls to the resources endpoint. And to limit the access, you may find this (the one in black) in the Web Services Profile as well: Hope that helps.
  6. Is there a way to Authenticate API Requests with OAuth2 Password and then limit information from data tables to only that belonging to the logged in user?
  7. LunaLovegood

    Connect to Google Drive

    Hello @directrix, I got this same error and contacted their support team. Then advised me that this is a Google issue as they have made changes recently. But if you have an existing task that is connected to Google Drive, it'll work perfectly. Fret not, Caspio DevOps team is now looking for a way to make this work. *winks*
  8. HampasLOUpa

    use of Caspio

    In addition to what TWIRED said, you also would need the following: General HTML Knowledge - There will definitely a time where you will need to create your own tables, do hyperlinks etc. In depth knowledge about Database - Caspio is technically an Online Database Application Platform so a strong and working (not theoretical) knowledge about Database would be ideal. Ability to learn - Well Caspio is like new way of developing, so best get someone who can easily learn. Most importantly - PATIENCE, PATIENCE, PATIENCE. - Caspio will require all it's users to be patient with everything. Well at least from my experience, that's about everything you will need.
  9. directrix

    Connect to Google Drive

    Hi, I am creating a new scheduled task connecting Caspio to Google Drive, but I am getting an error. Please advise.
  10. kristina

    Creating a searchable tagging system

    Hi @Richtopher, I regret to inform you that, you cannot establish relationships to connect that List-String field to another table. List-string contains multiple values, however, in relationships it requires specific value. For your another concern, you can do keyword search across multiple fields. Here are the links that can help you achieve your desired workflow: https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/ https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ I hope this helps.
  11. Yesterday
  12. Hi @Trevor, As of July 12, 2018, Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/ This release includes a new feature , Calculated Values in Submission Forms. This allows you to generate calculations which you can use as your total value for all your fields. Check these videos for more information:
  13. Smashley

    Triggered actions on import

    I just finally found this after building a pretty elaborate trigger based on bulk imports. Anyone know if this feature has been requested/is in the works?
  14. So it seems I can use this but sporadically. The issue I have is that I am embedding 9 data pages on one web page. I should, theoretically be able to get the BeforeFormSubmit, DataPageReady, and FormSubmitted event from any of the datapages in the web page. But I seem to only be able to attach and listen to one of the datapages, and not all of them. As well, I think I need the FormSubmitted event rather than the BeforeFormSubmit. If you could guide me in the correct direction there it would be helpful. And finally related to this same topic, once I get the FormSubmitted or BeforeFormSubmitted event from one of the datapages I would like reload/refresh another database that currently displays information from a table populated by a trigger. I do not want to reload the entire web page as that takes too long. So to be more clear: I have three datapages: Page 1 - grid of pend approval costs Page 2 - second grid of approved costs Page 3 - Displays total costs from Grid 1 and Grid 2 by way of a trigger on the underlying data table from Grid 1 and Grid 2. I separate out pending approved costs from approved costs so that I can modify pending approved costs in any way, but only exclude approved costs so the grids have different abilities. I have 2 Tables - Costs (both pending approval and approved) Total of all costs When I update either Grid 1 or Grid 2 the posted data is updated in the Costs table and a trigger totals the costs (both pending approval and approved) and updates the total cost table. The datapage for total costs needs to be refreshed (through an ajax call or some event) when Grid 1 or Grid 2 is submitted. But I do not want to reload the entire page, just the embedded Total Costs datapage.
  15. IamGroot

    Pop-up Form on Submit

    Your welcome @Perzival, I'm glad and happy that I helped you with that
  16. directrix

    Display WebPage Name on the Report

    Thank you two, @JolliBeng and @Andrii, for the suggestion. But I realized that may question is wrong. My true question is how can I saved the value of WebPage name in my page field in my table: Like what I have mentioned above, I am using a submission form to record the IP and the page that they used to go. This is my DataPage Setup. I am using a lookup table for info requested. That LookUp table is where Facebook and the likes and their corresponding URLs are stored. And after they have selected the option, they will be redirected to what they have chosen.
  17. Perzival

    Pop-up Form on Submit

    @IamGroot that is exactly what I need. You're awesome. Cheers!
  18. JolliBeng

    Datapage logic

    Hi HampasLOUpa, It is possible to put multiple values in a logic. You may use logical operators. Please refer to this link. Hope this helps. -JolliBeng
  19. Last week
  20. HampasLOUpa

    File Types

    Hi, You can upload most type of files such as documents, spreadsheet and images and most especially the most common sql file formats . You can also upload videos and music but can't be played. Since I think they don't have a player for that. These medias are treated as general files. Hope this helps.
  21. HampasLOUpa

    Can you convert a Formula field to a Date/Time field

    Well as for me. It worked. I was able to use the date to filter my report. My date is also a formula field. I also used "Full Name" field which is also a formula field. You can use Calculated field though. Hope this helps.
  22. NailDyanC

    create id

    Hi, Regarding with your question, yes you can create unique ID fields in your table. Just create a field inside your table and set your ID as a unique ID. Just click the Unique button next to the field that you want to be unique. Just like in the attached screenshot below.
  23. Meekeee

    Calculation Help Needed

    Hi @braxwell, As of July 12, 2018, Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/ This release includes a new feature , Calculated Values in Submission Forms. This allows you to generate calculations which you can use as your total field. Check these videos for more information:
  24. WatashiwaJin

    Span in Calendar

    Any thoughts on this? I really appreciate your help
  25. IamGroot

    Pop-up Form on Submit

    Hi @Perzival, You can create another DataPage and add HTML Block with the linked of the user confirmation, here some sample code for pop-up form: For you to better understand the process, you can go through Caspio's How-to: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/add-an-option-to-a-public-facing-dropdown/ https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-add-a-required-i-agree-option-to-your-form/ I hope this helps you
  26. NailDyanC

    How To Delete File?

    Hi Allen, Do you mean you want to Delete permanently your file to your database? If that's what you want, Go to All assets->Files select all the files using a checkbox in the left top corner and delete files using bulk actions if you want to remove a lot of files. If you want to remove only just select the file you want to delete and click "Delete". Thanks, @NailDyanC
  27. Yes all these messages are in the localization you are using for this report page. Create a copy of the localization and under Results Pages >> Messages >> 351 No Records Found >> Add your custom text. You can also add HTML tags for instance <a href="UTL OF THE PAGE"> Add New </a> or you can also have JS.
  28. YourSolutions

    Automatic Email When Field Condition Met

    Many Thanks for your reply, I will take a look at the various resources you have made available to me. I am not an experienced programmer / coder so I was really hoping for a simpler method. Would it not be possible to run an IF Function, for example: IF the "calculated field" value is > than or equal to 90% THEN send an email to Address X ELSE IF "calculated field" is between 60 and 89 THEN send an email to Address X and Address Y etc;
  29. HampasLOUpa

    Automatic Email When Field Condition Met

    Hi, If you want this to happen in a DataPage level, you will need to write a several codes for that. It's possible but kinda tricky. Some can be complicated though, so if you're not a hardcore web developer/programmer, you will definitely have hard times figuring it out (but if you wan to try you can see these links though: https://www.codeproject.com/Questions/785941/How-to-send-email-in-HTML-using-javascript , https://www.smtpjs.com/ , https://stackoverflow.com/questions/48283396/sending-email-from-javascript-with-smtp-server , try also googling other links/tutorials). There is another way to do that.It's a bit different to what you want but I think I will do. As I was exploring Caspio Bridge, I saw this Triggered Action functionality. It works in the Table/Database level. When there is an activity in your Table, say you updated a value of a field, you can select several options like send SMS, Email or even populate another table. This is also a bit tricky to configure but as per my experience, Caspio offers wide range of support, How-To, video tutorials and Online Training. Try these links : https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps. Thanks.
  1. Load more activity