Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Hello @kpcollier, I found a tutorial on how to align one of the tabs to the right. Maybe this tutorial can help you: https://www.w3schools.com/howto/howto_css_topnav_right.asp Regards, kristina
  3. Cstricker, thank you so much for your quick reply. Your explanation makes sense. I will give it a try and I hope to be able to reproduce what you described and get the correct result. Also, thank you for sharing the screenshot; it helps a lot. Thanks again.
  4. Yesterday
  5. JolliBeng

    Radio button

    Hi Role21, You may add this CSS code on your DataPage Header: <style> input[type="radio"] + label { font-size: 16px !important; } </style> just change the font size to your desired size. -JolliBeng
  6. How can I modify the font size of Radio Button options? I cannot see them under Styles
  7. JolliBeng

    Rules

    Hello Heather, You need to make the fields editable for them to be used in Rules. And you can add a custom code to disable the editing. You can add this code on your DataPage header: <style> input#EditRecordID { pointer-events: none !important; } </style> Just change "EditRecordID" to your field ID. -JolliBeng
  8. Heather

    Rules

    Hi! I'm using rules. I see that when the form element of the field is "Display Only", it cannot be used in Rules. I want to hide section AB when field A is blank but I don't want field A to be editable. How can I achieve this? Thanks in advance!
  9. In my case it was more a SQL syntax issue. I have been writing SQL for a long time, 20 years. Using Caspio's triggers are a very small subset of SQL obviously but I was getting caught up in their syntax. When I thought about it in terms of SQL I figured it out. The group by groups all the inserted rows, by a particular value, in this case the header id and the sum agregate sums them which is exactly how you would do it in just plain SQL. Previously I was not grouping but when I used the group by it worked.
  10. Csticker, I have the same exact issue. Did you find a solution?
  11. Last week
  12. Harbinger

    Monthly Reminder

    Hi Scarlet, Just to add, Make sure to use the email notification feature in the scheduled tasks. So you'll get notified when the tasks went off. H
  13. NailDyanC

    Caspio Developers

    Hi, Just to add to the previous comment above, Caspio has a Professional Services team that can build your ideal app for you. You can tell them about your project and they will bring it to life, on-time and on-budget. You can fill in the form in this link https://www.caspio.com/professional-services/ and they will get back to you. You can also schedule a free consultation call with a Project Manager of the Professional Services team who will collect the details and provide you a quote estimate. By the way, Caspio's Professional Services is a team that creates and develops the application or custom code works based on your requirements at an extra cost. A meeting can be scheduled to get a no-obligation quote and to learn how we will deliver your vision on time and on budget.
  14. NailDyanC

    Performance - Filter A View Vs. Datapage

    Hi, Just want to add to the previous comment above, regarding with your concern, using a view to filter can have many usages. It is a good way to reduce the number of records and fields to only those essential to your current task. Another common use is to apply a filtered view to an Authentication. For instance, you can configure a view to remove records based on a set of criteria where app users are automatically removed from an authentication when set to inactive. Filtering views is an efficient way to display the data you want without making any changes to the tables. To answer your question, I think there is no such big difference in using filters in both Views and DataPages. You use view just to combine two or more tables and filter such results and also you can use DataPages for selecting only the fields that you want to display.
  15. Sorry, @kristina. If you could help with one more thing I would appreciate it. Now, I am trying to get ONE tab to be aligned to the far right of it. I've tried messing with it. I try to add a separate div with a new class for the one tab, set it to display:block and tried inline as well. Set the one div to text-align:right. Also tried just using !important to get it over there and I just can't figure this stuff out. Lol. Any help is appreciated. KPC
  16. kpcollier

    I have a problem enabling edit records in a datapage

    Are you sure the field you are trying to edit is on the correct table that you deemed editable? One thing I dislike about caspio is exactly this. Views are tricky to edit due to the fact you can only edit one table. Could you give us screenshots or something to see your example?
  17. So I'm currently using a view as a source for my reports data page, and I have already set a specific table in one of my tables to be editable in View. Then, I created a data page and I have enabled the inline edit already. But the problem is, I still cannot modify the specific element that I want. Any information on this? thanks.
  18. NailDyanC

    Is it Easy to develop app with Capsio

    Hi, Just want to add to the previous comments above, the first thing that you need to do is to build a normalized and well-architectured table. And for you to know the fields and tables that you need, you need to define the workflow of your application. As well as the Level of Users of the app. In this manner, it would be easy for you to identify which tables that you will need, and what type of relationship you need to establish. You can click the links below to view the presentations: Introduction to Table and Table Design Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU Addition to that, you can review some of their training materials for you to familiarize Caspio's features. https://howto.caspio.com/ https://www.youtube.com/user/CaspioInc https://www.caspio.com/training/ Also, they have Ready-made applications that showcase the features of Caspio. You may want to visit them at https://www.caspio.com/apps/ to find workflows that may suit your applications need. By the way, they offer free instructor-led training sessions multiple times per week. These online training helps you get up and running quickly. You can sign up in these training session here: http://howto.caspio.com/pre-recorded-live-training/ or watch the pre-recorded training sessions at http://howto.caspio.com/pre-recorded-live-training/ Hope that helps.
  19. NailDyanC

    Caspio's Latest Upgrade

    Hi All, Just want to update you about the current release of the new version of Caspio which is Caspio 16.0. You may refer to this link for reference and more details: https://howto.caspio.com/release-notes/caspio-bridge-16-0/ Regards, @NailDyanC
  20. Okay. The reason I want this feature is for UX/UI for the users in our company. I don't necessarily want to lock them out of the other records that do not belong to them - I would just like their records to pop up at first, and have the ability to see others if they need to. I was thinking I may be able to do this with a button that links to the Superuser, but I'm not sure if it will mess with redirection and authentication.
  21. kpcollier

    Embed Deployment Code Not Working In Weebly

    @Vitalikssssss, Yes, I have some JS for a popup in one of the pages. You can find the JS in this post. Here is the code I am using for the embeddable tab. <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> iframe#viewer0 { height: 768px !important; } iframe#viewer1 { height: 768px !important; } iframe#viewer2 { height: 768px !important; } iframe#viewer3 { height: 768px !important; } iframe#viewer4 { height: 768px !important; } iframe#viewer5 { height: 768px !important; } iframe#viewer6 { height: 768px !important; } </style> </head> <style> .ui-resizable-helper { border: 1px dotted gray; } ul#menu { width: 100%; height: 40px; background: #505459; font-size: .8em; font-family: "Arial", sans-serif; font-weight: bold; list-style-type: none; margin: 0; padding: 0; text-align: center; } ul#menu li { display: block; display: inline-block; margin: 0 0 0 5px; padding: 8px 15px 0; cursor:pointer;} ul#menu li a {color: #fff; text-decoration: none; display: block; float: left; line-height: 200%; } ul#menu li a:hover { color: #333; } .content{display:block; width: 100%; height:100%; padding: 10px; border:2px solid #505459; overflow:hidden; position:relative;} .ChannelView{ width:100%; height:100%; margin-bottom:100%;} </style> <script> function getElementByClass(classer) { var allHTMLTags=document.getElementsByTagName("*"); var array = []; for (i=0; i<allHTMLTags.length; i++) { if (allHTMLTags[i].className==classer) { array.push(allHTMLTags[i]); }} return array;} function channel(n){ var frames = getElementByClass("ChannelView"); var length = frames.length; for(var i = 0; i < length; i++) { if(frames[i].id == ("viewer"+ n)) { frames[i].style.display = "inline"; }else{ frames[i].style.display = "none";}}} </script> <div style="display:block; text-align:left;"> <div style="display:block;"> <ul id="menu"> <li><a onclick="channel(0)">Job Sheet</a></li> <li><a onclick="channel(1)">Done Jobs</a></li> <li><a onclick="channel(2)">SI Task Report</a></li> <li><a onclick="channel(3)">SI Consolidated Sheet</a></li> <li><a onclick="channel(4)">Orders</a></li> <li><a onclick="channel(5)">Bid Board</a></li> <li><a onclick="channel(6)">Vehicle Inspection Form</a></li> </ul> </div> <div class="content"> <iframe frameborder=0 id="viewer0" class="ChannelView" src="https://c3eku680.caspio.com/dp/xxx" style="display:inline"></iframe> <iframe frameborder=0 id="viewer1" class="ChannelView" src="https://c3eku680.caspio.com/dp/xxx"></iframe> <iframe frameborder=0 id="viewer2" class="ChannelView" src="https://c3eku680.caspio.com/dp/xxx"></iframe> <iframe frameborder=0 id="viewer3" class="ChannelView" src="https://c3eku680.caspio.com/dp/xxx"></iframe> <iframe frameborder=0 id="viewer4" class="ChannelView" src="https://c3eku680.caspio.com/dp/xxx"></iframe> <iframe frameborder=0 id="viewer5" class="ChannelView" src="https://c3eku680.caspio.com/dp/xxxx"></iframe> <iframe frameborder=0 id="viewer6" class="ChannelView" src="https://c3eku680.caspio.com/dp/xxxx"></iframe> </div> </div>
  22. MayMusic

    Copy with a formula from Datapage to table

    Can you bring an example of what you are trying to achieve?
  23. Hello Do someone know a formula to copying through a formula informations to a table please Alain
  24. Vitalikssssss

    Embed Deployment Code Not Working In Weebly

    Hi @kpcollier, Can you share with us a code which you used for the tabbed interface? Do you have any custom JS in your Datapages? Regards, vitalikssssss
  25. @MayMusic If you want to hide just Edit button and leave the details button, use this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function () { var values = document.getElementsByClassName("your_class_name"); var editButtons = document.getElementsByClassName("cbResultSetActionsLinks"); var firstButton = 2; var secondButton = 3; for (i = 0; i < values.length; i++) { if(values[i].innerHTML == your_condition) { editButtons[firstButton].style.display = "none"; editButtons[secondButton].style.display = "none"; } firstButton += 4; secondButton += 4; } }); </script> It is also adjustable if you have delete button: <script type="text/javascript"> document.addEventListener('DataPageReady', function () { var values = document.getElementsByClassName("your_class_name"); var editButtons = document.getElementsByClassName("cbResultSetActionsLinks"); var firstButton = 2; var secondButton = 3; for (i = 0; i < values.length; i++) { if(values[i].innerHTML == your_condition) { editButtons[firstButton].style.display = "none"; editButtons[secondButton].style.display = "none"; } firstButton += 6; secondButton += 6; } }); </script>
  26. simishu

    Want to Search by Text String, not Autonumber

    @Vitalikssssss thanks for the reply. I'm looking into this at the moment, and encouraged that this may be one way to do what I want. I'll keep you posted! Update: Seems like the view layout worked, and I've been able to configure virtual fields to enable search across multiple criteria. Thanks for the help!
  27. IamBlossom

    Filtering Criteria using Calculated Field

    Hi @NailDyanC, Thank you for your response. I have two tables, Student_Record and Student_Info. Both tables are linked together. Student_Record contains Payment field. Per Student_ID, I want to sum all the payments that particular student made. If greater than 0, then the Status should be Active, else Inactive. Here is my formula: CASE WHEN (SELECT SUM(Payment) FROM Student_Record WHERE Student_ID = target.[@field:Student_ID] > 0 THEN 'Active' ELSE 'Inactive' END I have this in my calculated field. I want to use Status as my filtering criteria but it seems that it is not allowed. Thanks.
  28. NailDyanC

    Filtering Criteria using Calculated Field

    Hi @IamBlossom , Regarding with your issue, may I know what is your formula so that I can test it on my end? But if you are using a Select Statement unfortunately select function is not allowed in a formula field. However, maybe we can use triggers to achieve your desired result. Thanks.
  1. Load more activity
×