mdav20

Thanks for your help!

For some reason it's not sending to multiple addresses. It works when I use just one address. I have a table with one field with email addresses separated with a ";" example (matt@yahoo.com; joe@mail.com)

Perfect, thank you!

Not sure if this is the correct forum for this question. I would like to send a notification email to multiple people based on a field used in the submission form. We have different jobsites with different supervisors at each one. I have a field called "jobsite" that the user will pick the jobsite from on the submission form. For example if the user selects "CLEV" in form for jobsite and submits the form the notification email will only be sent to the supervisors in CLEV automatically. Each jobsite could have between 2 and 4 supervisors so I will have to be able to send one email to multiple people also. We currently have 17 jobsites within the company. Thanks in advance for any help!

Do you happen to know if this will work with signatures?

I agree completely, as my app's develop more and more I see this is going to be the deal breaker for us soon.

I figured it out, the following code was wrong, I needed to make 'Signature' and 'Foremen, Signature' the same as my field names // TODO: Add your signature fields here in the order they appear on the form --> var signatureFields = [ ['Signature', [@field:Incident_Signature_Employee!], 'cbParamVirtual1'], ['Formen_Signature', [@field:Incident_Signature_Foreman!], 'cbParamVirtual2'],

I have my dual signatures working on my submission form using the following code in my footer along with the other instructions found here.. https://forums.caspio.com/topic/6573-collecting-2-signatures/?page=0#comment-20486 but I don't think its storing anything into my table, the fields in the table are blank and when I try to display them onto a report using more code found in this forum nothing shows. It's my understanding the table field should have a bunch or numbers and letters like coordinates? Any help would be appreciated <!-- Footer code --> <script type="text/javascript"> $(document).ready( function () { // TODO: Add your signature fields here in the order they appear on the form --> var signatureFields = [ ['Signature', [@field:Incident_Signature_Employee!], 'cbParamVirtual1'], ['Formen_Signature', [@field:Incident_Signature_Foreman!], 'cbParamVirtual2'], ]; for (var i = 0; i < signatureFields.length; i++) { var api = $($('#cb_sign_wrapper_edit .sigPad')[i]).signaturePad({ drawOnly: true }); if (api) { api.regenerate(signatureFields[i][1]); } } $('#cb_sign_wrapper_edit form').submit( function () { for (var i = 0; i < signatureFields.length; i++) { // Dump signature JSON data into hidden signature field var newSignature = $('#cb_sign_wrapper_edit .output')[i].value; $('#InsertRecord' + signatureFields[i][0])[0].value = newSignature; // Capture each signature image into its corresponding [hidden] VIRTUAL field var api = $($('#cb_sign_wrapper_edit .sigPad')[i]).signaturePad({ drawOnly: true }); if (api) { api.regenerate(newSignature); $('#' + signatureFields[i][2]).val(api.getSignatureImage()); } } } ); } ); </script> </div>

I'm confused by triggered actions and I'm hoping someone can help. I have two tables for tracking asset's by serial numbers. One is asset information (make, model, size, serial number, etc) the other is asset hours which tracks when a asset is used and has installed_hrs and removed_hrs to track the time. Asset information has a field called "Status" (installed, spare, out for repair) I would like a trigger that when installed_hrs (asset_hours table) > 0 the "status" in asset information table changes to "Installed" So basically changed a field in one table based on a field in another table. Thanks

I would like to have access limited to records based on jobsite but also allow certain users to see all records (managers). So say user1 is a jobsite worker, he needs to only be able to see his jobsite's records. The area manager who is in charge of multiple jobsites needs to be able to see all records no matter what jobsite the record is tied to. I currently have user_Authentication table with a field named jobsite and user level security linked on the datapage which works good for the jobsite workers but the managers can't see anything since they don't have a value in the field jobsite. I don't want to have two datapages if possible. Thank!

I have the following script for onchange... I would like run it onload also, is there a easy way to do it? <SCRIPT LANGUAGE="JavaScript"> function calculate() { var current = parseFloat(document.getElementById("cbParamVirtual1").value); if (isNaN(current)) current = 0; var installed ='[@calcfield:2]'; var total_hrs ='[@calcfield:1]'; var currenttotal = parseFloat((current - installed) + parseFloat(total_hrs)); document.getElementById("cbParamVirtual2").value =Math.max(0, currenttotal); } document.getElementById("details").onchange=calculate; </SCRIPT> Thanks in advance!

I figured it out thanks to this by @mayMusic Thanks @MayMusic

I'm trying to calculate the number of hrs on a report details page. Its simply (hrs_removed - hrs_installed) nothing fancy. Here is the code I'm trying to use in the footer of my report details page. <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_field1 = parseFloat(document.getElementById ("EditRecordhrs_removed").value); if (isNaN(v_field1)) v_field1 = 0; var v_field2 = parseFloat(document.getElementById ("EditRecordhrs_installed").value); if (isNaN(v_field2)) v_field2 = 0; var v_total = (v_field1 - v_field2); document.getElementById("EditRecordhrs_total").value = (v_total); } document.getElementById("caspioform").onchange=calculate; </SCRIPT> Trying to get it populate the hrs_total field after putting in the hrs_removed and hrs_installed and before submitting the form.

I currently have a calculated field on a details report that sums up the a total hrs field in a table. This is the current formula and it works perfect... select sum(hrs_total) from tire_hrs_table where tire_id=target.[@field:tire_id] My problem is the hrs_total is the sum of [hrs_removed] - [hrs_installed] of only completed transactions and not currently open transactions. Every record has a hrs_installed but open transactions do not have a hrs_removed yet. I would like to add a virtual field for [current_hrs] to my details report which would allow the user to input the current hours. Then I need to take the virtual field [current_hrs] and subtract [hrs_installed] from records that do not have [hrs_removed] yet to figure out how many hours are on the open transaction currently and then add that to my formula i already have working. Not sure if I would use a CASE statement or how to use it. Hopefully that kinda makes sense. thanks for any help you guys can give

Thanks for the information. Caspio support figured it out, I have multiple datapages with update buttons on a single webpage. Causing the hover over the update button not to work since it was below the first update button. Thanks again!