Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by Barbara

  1. Hello, You can try using javascript for that matter. I am using a "Buy this item" button to connect my report with details page. If you have something similar you can add an HTML block to your report and use javascript. In your case it would be something like that: <script type="text/javascript"> var cb_boolean = '[@calcfield:1]'; if (cb_boolean != '0') { document.write("<input type='button' value='Details' Name='mybutton' onclick='myfunction()'> "); } else { document.write("<input type='button' value='Home Page' Name='mybutton' disabled=true>"); } function myfunction() { window.location.href='url&paramToDetailspage'; } </script> Replace url&paramToDetailspage with your url to Details page. Cheers, Barbara
  2. An idea came to my mind which is worth to try: Disable the field label in the advanced tab Insert an HTML block before the field and enable "next element on the same line" in the advanced tab. This way the content of the HTML block appears before the field on the same line. Put the custom label in the HTML block like: Select [@InsertRecordFIELDNAME] submission Replace FIELDNAME with your submission type field name. Format the text the way you want it to display using HTML and Style tags. I think it should work but I haven't tried it myself!
  3. It seems like a one to many relational database where one creative can have many reimbursements and you need to stamp the reimbursement with the creative id in the reimbursement table as the foreign key. You can either achieve this by choosing the value of your dropdown as the ID field (there are Display and Value options in each dropdown that can be set separately for example Display to show the name of the creative and Value to store the id of the creative in the table). Another totally different approach is what is explained in this video: http://howto.caspio.com/getting-started/create-a-one-to-many-relationship/ Cheers, Barbara
  4. Yes, this is explained in the tech-tip here http://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-an-approval-process-for-new-submissions/ Cheers, Barbara
  5. There is a Source button from where you can switch to the source when you want to place pure codes. Does this help?
  6. Barbara

    Fault 51001

    Hi, does your Caspio Bridge account include WS API feature? If you're not sure, contact your account admin to verify this. If you know your Caspio Bridge account has this feature then verify the web service profile information that you've created inside Caspio Bridge. This information should be provided in the codes accurately.
  7. 1. In your authenticated HTML DataPage write a script to define variables and values as you already did. For example: <script> var type_admin = '[@authfield:admin]'; var type_manager = '[@authfield:manager'; var type_user = '[@authfield:user]'; </script> 2. Embed the HTML DP in every protected web page and hide it. Example: <div id="htmldp" style="display:none"> Deploy code of HTML DP… </div> 3. In your HTML web pages where you have the hidden HTML DataPage, write a JavaScript to show/hide content: <script> if (type_admin =='yes') { //show or hide your content document.getElementById('YourContentID').style.display = 'none'; document.getElementById('YourContentID').style.display = 'block'; } else if (type_manager='yes'){ …} … </script>
  8. Does grouping maybe help? It's explained here http://howto.caspio.com/datapages/reports/advanced-reporting/data-grouping/
  9. Charlene, were you able to get it to work yet? One other note is that if your fields are editable you can refer to them as EditRecordFieldName, if your fields are Display Only then there is no ID to refer to and that could be a reason your script is not working.
  10. See an example of creating a View to join tables at http://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/. When you create a View you will join the tables on the related field (unique id of the parent table and the related field usually called foreign key in your child/related table). In your View you will choose any field you need to display in the Report. View only allows one of the tables to be editable so you need to choose which table you want to be editable in the View settings. Then you will create a Report based on the View where you can set the editable fields and display-only fields in the details page. On another note, creating a relationship will facilitate creating a View and also allow you to enforce referential integrity of your data. You can get more information about this at http://howto.caspio.com/tables-and-views/relationships/. Hope this information helps. Cheers, Barbara
  11. Inline edit/add function in the results page does not seem to have have the receiving parameter option so I don't think it's possible through standard features. I'm not sure if there is any other way such as custom coding. Anyone knows? Cheers, Barbara
  12. Currently not a built-in feature. It is possible by custom development through Professional Services, http://www.caspio.com/support/professional-services.aspx. It's a good feature! Why don't you suggest it in the ideabox: http://ideabox.caspio.com. Cheers, Barbara
  13. Mass insert and update is not a built-in feature currently. There is a feature request in the ideabox for mass update at http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/2900405-mass-update. You can vote for it or suggest a new feature if it's different than what you're looking for. Cheers, Barbara
  14. App users can submit into the database one record at a time. Batch entry on user level is not an option at this time. Feel free to suggest this in ideabox http://ideabox.caspio.com/. Cheers, Barbara
  15. Goddady is a good one which works with Caspio pretty good.
  16. Caspio Bridge upgrades are normally performed very smoothly. As a customer you won't need to take any action and that's the advantage of the cloud platforms. If there are any issues after the upgrade, they work with you to fix them. I suggest if you want to get answers about policies and SLA, contact your account manager assigned to your account.
  17. Hi Mike, See the screenshot below which shows where to change the labels. As for the icon you can either choose from the default list or your own custom URL of the icon. As for the font and other formatting features of the label I am not sure. Will let you know if I find out. Cheers, Barbara
  18. You can also use the older version of Google which does not have geocoding limitation. This option is the quickest way to get your map up and running as you only need to take three steps to update the following items referring to the instruction at http://howto.caspio.com/extensions/maps/map-mashup-instructions/map-mashup-older-version.html: In the instruction 1.3, change map type “Y†for Yahoo to “G†for Google. In the instruction 1.4, change map type “Y†for Yahoo to “G†for Google (optional only if you have a Details Page). In the instruction 2.2, change Yahoo deploy code with Google deploy code (replace “YourKeyHere†with your API Key registered for your domain).
  19. If you are referring to exporting/downloading the results page, there is a download option. See how to enable it at http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/how-to-search-results-downloadable-for-users.html. Cheers, Barbara
  20. You can create a Report DataPage. Caspio has different Report formats including Tabular, List, and Gallery. See instruction at http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/. Then if you need to export the report in PDF, you can request Caspio PS for a custom development. See info at http://www.caspio.com/extend/platform-extensions/pdf-reports.aspx Cheers, Barbara
  21. You can contact Caspio Support to upload the USA zip codes table in your account.
  22. Hi, as for the first one there is a techtip at http://howto.caspio.com/customization/limit-the-number-of-maximum-submissions.html which may help you with what you're trying to achieve. For the second one your logic is correct but you need to define a variable and assign today's value then use that in your comparison. You can capture today's value by using [@cbTimestamp] In either case JavaScript method is not a bullet proof way of limiting submissions. Because JavaScript can easily be manipulated by a technical user as it runs on the browser side. A recommended method is to write a server side program to achieve this. This can be done by Caspio PS team. If you are interested to get a quote you can submit the requirements at http://www.caspio.com/support/professional-services.aspx. Cheers, Barbara
  23. It should work the same on an Update form since the submit button is the same in Submission and Update forms. Use Firebug to inspect the code while opening the page in Firefox browser then look for the submit button and also see if you get an error when script runs. One reason could be multi-form deployment on your webpage so the script is confused which "caspioform" it's referring to. Good luck! Barbara
  • Create New...