Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by Barbara

  1. It does work! It's also good to know that the code is applicable in submission, update and details pages. For results list or gallery view, you can use <div> element.
  2. Hi, I think creating collapsed sections which is expandable if needed is a good option. There is a tutorial which explains the steps: http://howto.caspio.com/tech-tips/creating-collapsible-sections.html. You may find it helpful. Cheers, Barbara
  3. InsertRecord prefix is used for submission form field ids so it's not relevant to search form. In search form the search fields start with Value1_1, second field will be value2_1, and so on. Now if you have deleted and added fields, this order might be different so it is always recommended to use a developer tool such as Firebug to inspect the element and find the proper id, your code should be like: var fieldName = "Value1_1"; var x1=document.getElementsByName(fieldName); x1[0].multiple=true; function splitAndParse() { var result = ""; var cleanResult = ""; for (var i = 0; i < x1[0].length; i++) { if (x1[0].options.selected) { result += "\""+x1[0].options.value+"\"" + " OR " ; } } document.getElementById("cbParamVirtual1").value = result; } document.getElementById("caspioform").onsubmit=splitAndParse;
  4. multi-select listbox in a search/report DataPage provides the functionality that you need. However as I understand you have separated your search than results so you have two DataPages passing and receiving search criteria as parameters. In this case you need to custom implement the multi-select functionality as it is not a standard feature in such situation. There is a forum post which provides the implementation method and a sample JavaScript, http://forums.caspio.com/index.php/topic/3694-enable-multiple-selection-for-listbox-with-virtual-fields/?hl=%2Benable+%2Bmultiple+%2Bselection. Does that help? Cheers, Barbara
  5. Using Caspio I don't think it is possible if the PDF is a file rather than text stored in the database.
  6. Question #1 seems a basic question about creating a report where you use a View for the datasrouce instead of a table. It is fairly simple, you will select Report for DataPage type and then in the second wizard screen where you select your data source you will use the View that you have created. These steps are also explained in this article http://howto.caspio.com/datapages/creat ... -datapage/ 2. Tables relationship is a famous database concept and it is not Caspio specific. A database could be relational or flat. The most important part of an application implementation is the database design. If your database is relational it is very important to design the tables and constraints properly from the beginning. Caspio has an example of a relational app which is explained in this article http://howto.caspio.com/parameters/in-a ... pages.html. 3. Caspio has listboxes that you can link to a look up table and enable multi-selection. Similar feature for checkboxes is a great idea and is available in the feature request database but yet not scheduled for the next release. When this feature is planned in the roadmap we will update the forum posts. 4. I'm not sure if I understand this correctly. Let me guess what you may want to do and provide suggestions. You can use a report and search for a record, I assume that record has bunch of yes/no fields. The search results returns all the fields related to the record you have searched. Now you want to grab all the fields that are checked as Yes and pass them to another form to be inserted into a new table? If you notice I have created a workflow here to achieve the functionality of reading and writing specific data into another table. This is not a simple process though, you will need a Java Script to read the Yes values and ignore the No's and then construct a URL where the Yes values are passed as parameters into the URL. The URL is the link to a submission form where new record including the Yes values are passed. Another way which is a better solution is to perform the same task from the backend database using a task or trigger depending on more specifics that you can provide how often and when this task should be performed. Consulting with Caspio PS is recommended. In my opinion there are different factors to consider when implementing an application. 1. Complexity and size of the project including the database deisng and application workflow 2. Technical knowledge required to build such database and application 3. Timeline Factors which contribute to the difficulty level of a project: • Relational Database • Number of DataPages • Parameters and Relations • Customization if built-in features does not exist • Advanced reporting and calculations • Custom Layout • Web services While a simple application such as membership directory (see here, http://www.caspio.com/apps/specialized- ... ctory.aspx) takes a few hours to implement in Caspio, there are more complicated apps which takes weeks and months to create depending on the developer's timeline. The same membership directory could take you months to create using PHP, HTML and MYSQL database. You need to learn database programming, PHP or any other server side language programming and of course HTML to design the forms and report. On another note, Caspio offers Professional Services to those who don't have time in learning the platform or the application is not easy to implement and requires medium to advance technical or database knowledge. I recommend if you request a price quote from Caspio Professional Services and a few other development companies. You can compare and make a decision. Professional services to take on this project is a guaranteed success and saves you a lot of time. Cheers, Barbara
  7. A few suggestions about various support channels you can use other than phone and live chat, and clarifications about which channel is recommended for different type of questions, and the response time you should expect: 1. Recommended support channel for technical questions within standard features of Caspio Bridge is the ticketing system. You can open a ticket anytime at https://support.caspio.com and receive a response in one business day. Usually you hear back from support within the same day of posting your question unless the question is posted in the afternoon which makes it possible to get an answer the day after. 2. Recommended channel for code-related questions such as Java Script and API calls is the community forum, and if you are not sure you can always start with a ticket and Caspio support may refer you to the forum to seek help from the community and developers if the solution falls outside of standard features and requires coding knowledge. Response time in the forum is not guaranteed, which is why ticket support channel is recommended first. 3. Self-help resources are available including video tutorials, how-to articles, and technical FAQs at http://howto.caspio.com/ Regarding the concern about adding DataPages, I'd like to inform you about new pricing which offers unlimited DataPages, see more information at http://www.caspio.com/pricing/usage-plans.aspx and contact your account manager if you have questions. Last comment about multi-select on search form, use checkboxes instead of multi-select listbox. Multi-select listbox concatenate the values with comma and a Java Script needs to be written to split and parse the values with OR in between each and send the parsed string to the Report page. The code is not easy so I recommend using multiple (as many options as you need) virtual checkboxes in search form and pass value of each as parameter to the next page. Next page is the predefined criteria report where in the configure filtering fields you can select your field and insert multiple Criteria using the "Insert" button at the bottom of the DataPage Elements. Choose "OR" for the criteria and set each criteria receive checkbox parameters. It may sound long instruction but you can implement it in less than 5 minutes depending on how many options you have:) I hope you find this information helpful. Best, Barbara
  8. This website provides multiple solutions you can pick the desired one, http://webdesignledger.com/tutorials/11 ... -solutions Cheers, Barbara
  9. Caspio Bridge lets you import data to your account in the following data file formats: Microsoft Access files (.mdb and .accdb) Microsoft Excel files CSV (Comma Separated Values) Tab Delimited text Fixed Width text Caspio Bridge XML Custom XML Read more about importing at http://howto.caspio.com/tables/importing-data.html. Barbara
  10. Instead of using settimeout which calls the submit function every 5 seconds you can use page onload event to call the function only when the window loads: window.onload = f_submit; Cheers, Barbara
  11. How about setting the localization of the calculated field to show as many decimals as you need? Cheers, Barbara
  12. I don't think Caspio offers this. You may look somewhere else...
  13. You must have reached Caspio during scheduled maintenance. Caspio normally announces scheduled maintenance a week in advance and sends a reminder two days before it happens. Have you received any? If not, you need to check your contact info on the account profile. Login to Bridge, from the top menu find Account >> Contact info and update the email address if needed. Cheers, Barbara
  14. I have searched online for "turn off password saving using javascript" and I find a lot of discussion on this subject. The most common method using java script is as suggested by ShWolf however the drawback is that this doesn't work on all browsers, and that it doesn't prevent using already saved passwords. I could not find any solid solution to this. Cheers, Barbara
  15. Can you exclude the blank entries from your results? You can use filtering fields and choosing comparison type "Is Not Blank".
  16. Wow, thanks normindr for such a great advice! For those who are having difficulties to get their Caspio apps work on phones, direct your users to use their device’s default browser to visit the address m.opera.com and install Opera for their phones or tablets. Cheers, Barbara
  17. Here is the instruction how to create relationship at http://howto.caspio.com/release-notes/c ... ridge-7-1/ and an article about how to create a view to join tables at http://howto.caspio.com/views/creating- ... ables.html. Cheers, Barbara
  18. Are you passing the parameters through URL? You can pass more than one parameter as in the example below: http://www.domain.com/myresults.htm?par ... er2=number Also if any of these parameters may be blank and the results must ignore that parameter you should add &cbResetParam=1 to the end of the parameter in order to tell the browser to clear the cache otherwise browser remembers the previously passed parameter if the parameter in the current session is left blank. Barbara
  19. Just checking couple things: 1. Is your field name "departamento" as referenced in your code? 2. What form element is used for field "RO_AppNum"? If it is "Display Only" it must be changed to a text or hidden field. 3. Instead of "document.getElementById("caspioform").d1.onchange=bloquiar;" use: document.getElementById("EditRecordRO_AppNum").onchange=bloquiar; If the tips above does not solve the problem, you may want to use Firebug to further troubleshoot as it shows you the Java Script errors so you can spot and fix them. Firebug is an add-on development tool in Firefox for free. Cheers, Barbara
  20. Scott, I believe you have posted your question in a wrong forum, this is Express DB forum but I came across your question related to Caspio Bridge so your question may have left unanswered for a long time. To post questions related to Caspio Bridge go back to the Board index and below the Bridge How-To find the Ask Questions Read Answers. To answer your question about hiding the submit button, this is doable using Java Script. See the sample code below: <script> document.getElementById("Submit").style.display = "none"; </script> Cheers, Barbara
  21. Caspio charts do not have percentage function, they have "Sum, Average, Min, Max, Count" which aggregates the records based on the function and group by the Category field that you can choose in the Configure Chart Options wizard screen. To answer your second question, to have more than one bar on the chart you can create a second series, upto 5 series can be created if I am not mistaken. Cheers, Barbara
  22. Hey Kyle, I am not sure how you are using pageviewincrement for this purpose because every time the details page is viewed this number adds one. So it can not be a good variable to hold the number of users signed up. To answer your question, if a user is deleted from the sign up table, a trigger in the backend database can be written to decrease the number of sign ups. Happy new year! Cheers, Barbara
  23. I have been a Caspio user/developer for a long time and almost know most of the features and capabilities of Caspio Bridge. However I never came across this question. I know Caspio uses SQL-Server but no matter which version they use as an end user or Caspio developer, I don't see any benefit knowing the version of the backend database. Cheers, Barbara
  24. Not sure if this code is the right way to use for conditional display purpose. Caspio provided Java Script examples are under Java Scripts Solutions in the Bridge How-To forum, viewforum.php?f=14 There is also an article in the how-to site which seems close to what you are looking for, check it out at http://howto.caspio.com/tech-tips/creat ... tions.html Cheers, Barbara
  25. Hi, I do not think this is a good idea to have one table to collect the data in your case. As you have mentioned, the data you collect for each type of user are different so the good design is to have them in separate table. If you store them all in one table you will end of having too many blank cells and later in report generations you might face with problems such as hiding blank columns or cells... If you want to use this form only to collect data and you do not care about reporting part, then it is okay to use one web form but as you also know it requires customizations as Caspio forms do not have conditional field hide/show. The closest script I can see might help you is in this article http://howto.caspio.com/tech-tips/creat ... tions.html but of course it still needs some modification if you want to hide and show based on the drop down selection. There are more sample scripts that you can see for example how a drop down element is being called in Java Script, check the samples at viewforum.php?f=14 Cheers, Barbara
  • Create New...