Barbara

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

How do I timestamp a record when value of a checkbox is changed?

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!

What is your date input format?

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

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

There is a Source button from where you can switch to the source when you want to place pure codes. Does this help?

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.

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>

Does grouping maybe help? It's explained here http://howto.caspio.com/datapages/reports/advanced-reporting/data-grouping/

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.

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

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

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

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