Search the Community

Hi, I'm not sure if this is possible but I need to set up a trigger to copy multiple records from one table to a) the same table and b) to another table. This is basically so a user can draw from old records for new projects without having to re-enter all the data again. The user would be doing this via Bulk Edit (selecting multiple records and updating a field for them all). There are a couple ways I thought this maybe could be done: 1) having Bulk Edit update one field ('copy_me') to 'True' and then a trigger that runs 'On Update' using Where 'copy_me'= True to select the records to copy. Then run duplicate those records (but not all fields, only some) on the same table OR into another table. After that the next step in the trigger would be to change 'copy_me' to False Where 'copy_me' was True so that the record was no longer 'triggerable'. 2) use a separate table to store, in a new record, the Id's (integers) of each record that's been chosen via Bulk Edit and then running an 'on Insert' trigger that Joins those Id's (they're in one text field, comma separated) to the main table's Id's and pulls various fields to copy them into a new table. I currently have the first half of this scenario set up (storing multiple record Id's in a separate table's text field via Bulk Edit) but don't know how to create a 'duplicate records' trigger for it. If anyone knows the specifics of getting a trigger like this to work-- or a better way to copy multiple records after they've been updated via Bulk Edit-- I'd really appreciate the help.

Hi all, I cannot seem to overcome an issue with the use of Javascript on a bulk edit screen. There is a basic little script I wrote to control when users should be notified about changes done in bulk. It should simply prevent notifications from being sent if the user did not alter the initial delivery status of a product. While the script itself executes just fine upon each change to the delivery status field, the value that gets inserted into the text field which toggles the actual notifications isn't being saved when I hit "Update". It works if I manually type in Yes or No, but not if it's done via the script. I suspect this has to do with Ajax in one way or another, about which I lack the necessary knowledge to troubleshoot, unfortunately. var pSDeliveryOld = document.getElementById("BulkEditParticipation_List_2016_Delivery_status").value; var dStatusChangeNotification = document.getElementById("BulkEditParticipation_List_2016_Notification_DStatusChange"); function statusCheck() { var pSDeliveryNew = document.getElementById("BulkEditParticipation_List_2016_Delivery_status").value; if(pSDeliveryOld !== pSDeliveryNew) { dStatusChangeNotification.value = "Yes"; } else { dStatusChangeNotification.value = "No"; } console.log("System to send notification: " + dStatusChangeNotification.value); } document.getElementById("BulkEditParticipation_List_2016_Delivery_status").onchange = statusCheck; Could one of you experts out there help me get the Yes/No value saved in the table? Many thanks in advance! Best, Kristof

Hi, I'm using the bulk edit option on a tabular report. I have rules set on the bulk edit to govern what data can be changed during the bulk edit based on the records selected by the user. I have placed css code into the datapage (configure bulk edit) and my stylesheet to update the text of the required fields to red in the bulk edit dialog box. In the Caspio preview all the required fields show as red. On my website the required fields still show as black. I used the developer tool and found that the class assigned on the website is different from the class assigned in the CASPIO preview which is why the color is incorrect on the website. The td class on the website should be <td class="cbBulkFormLabelCell cbBulkFormLabelRequired"....</td> Website class assignment: <td class="cbBulkFormLabelCell_334daf58b60dbf cbBulkFormLabel_334daf58b60dbf" style=""><span class="cbBulkFormEnableCheckBoxContainer_334daf58b60dbf"><input type="checkbox" name="EnableBulkEditScan_Load_Table_MAIN_ALLScans_RENDCkb" id="EnableBulkEditScan_Load_Table_MAIN_ALLScans_RENDCkb_334daf58b60dbf" disabled=""></span><label for="EnableBulkEditScan_Load_Table_MAIN_ALLScans_RENDCkb_334daf58b60dbf">Rate End:<span style=""><span class="cbFormRequiredMarker_334daf58b60dbf">*</span></span></label><span class="cbBulkFormHintLabel_334daf58b60dbf" id="BulkEditScan_Load_Table_MAIN_ALLScans_REND_hnt_334daf58b60dbf"><img class="cbBulkFormHintLabelImage_334daf58b60dbf" src="https://c3amf140.caspio.com/images/tooltip_icon_gray_outlined.png" alt="[?]"></span></td> CASPIO class assignment: <td class="cbBulkFormLabelCell cbBulkFormLabelRequired"><span class="cbBulkFormEnableCheckBoxContainer"><input type="checkbox" name="EnableBulkEditScan_Load_Table_MAIN_ALLScans_RENDCkb" id="EnableBulkEditScan_Load_Table_MAIN_ALLScans_RENDCkb_612e7963285d5d" disabled=""></span><label for="EnableBulkEditScan_Load_Table_MAIN_ALLScans_RENDCkb_612e7963285d5d">Rate End:<span class="cbBulkFormRequiredMarker"><span class="cbFormRequiredMarker">*</span></span></label><span class="cbBulkFormHintLabel" id="BulkEditScan_Load_Table_MAIN_ALLScans_REND_hnt_612e7963285d5d"><img class="cbBulkFormHintLabelImage" src="https://c3amf140.caspio.com/images/tooltip_icon_gray_outlined.png" alt="[?]"></span></td> Bulk Edit CSS (Placed in stylesheet and datapage) <style> .Dialog { width: 660px !important; height: 630px !important} <style> .cbBulkFormLabelRequired { color: #F44336 !important; font-size: 10px !important; font-family: Arial, sans-serif !important; font-weight: bold !important; z-index: 2000 !important; } .cbBulkFormLabel { color: #444444 !important; font-size: 10px !important; font-family: Arial, sans-serif !important; font-weight: bold !important; } .cbBulkFormData{ font-size: 10px !important; } .cbBulkFormSelect{ font-size: 10px !important; color: #333333 !important; font-size: 10px !important; font-family: Arial, sans-serif !important; font-weight: 300 !important; padding: 5px 6px !important; background: #FFFFFF !important; border-color: #e9e9e9; border-width: 1px !important; border-style: solid !important; box-sizing: border-box !important; } .cbBulkFormTextField{ font-size: 10px !important; color: #333333 !important; font-size: 10px !important; font-family: Arial, sans-serif !important; font-weight: 300 !important; padding: 5px 6px !important; background: #FFFFFF !important; border-color: #e9e9e9; border-width: 1px !important; border-style: solid !important; box-sizing: border-box !important; } </style> Thanks, Bre

We have a requirement for our Users to be able to update v quickly a large number of records within a tabular type report. The Bulk Edit/Update on its own wont work for us as we need to - when updating each of the records - to concatenate two Notes fields together along with a system date within each record and update another field. We can do this quite easily with JS in aa single Details Page (simple JS concatenating the two different notes values and adding today's date). However this approach does not seem to work on the Bulk Edit/Update - as whilst we can change a common field value across multiple records we cant get JS to individually do a concatenation in each of the records involved. Am really interested in any ideas for this. Our latest thinking - please comment - is to use a Tabular report of searched records to display in std tabular form to the User. But to have an HTML block at the end that has a URL link they can click. This would open some kind of hidden web window/tab containing a Details record that we can apply the JS to (as advised above) for concatenating the two Notes field values and the date within each record. We have not quite got this to work and I would be really interested in views from this Forum. A key stumbling block is to arrange for a Parameter value that can be selected once - whilst at the Tabular report - and then reused/retained as the User works his/her way down the list by clinking on the link quickly opening/closing a Details form (using Auto Submit?). This parameter value we use to update a field with the records status. It and the values of the Notes fields that we concatenate and then update another field and really the record changes we are trying to accomplish. We have tried using a second datapage with a dropdown of the values that would hold a parameter value to pass over. However it loses its value after the first click. We were wondering if we could have somekind of dropbox field that we could set once and which would then keep its parameter value held whilst the User was clicking the html link block on the Tabular report and then activating the hidden web window/tab with the Details record. Any ideas from you experts out there :-)

The script below can be inserted into a footer. It preselects all rows with a value greater than 1, so that they can be Bulk Edited. It loops for a field in a tabular datapage with a class of cbResultSetTableCellNumberDate, and then it looks for the value of the text of those cells that match. On my datapage, I have just 1 column with numerical data, so I don't need a more specific selector than that... Then, it jumps up to the Row of the matching cell, then down to the first element in the Row (the cell that holds the checkbox), then down again to the checkbox itself, then uses a click event to check the box. To make use of Bulk Edit, a click event must be used, and not document.getElementById("checkbox").checked = true; because Bulk Edit is grayed out until there is a click (not a change) event. <script type="text/javascript"> var elems = document.querySelectorAll(".cbResultSetTableCellNumberDate"); for (var i=0, m=elems.length; i<m; i++) { if (elems.innerText >= 1) { elems.parentNode.firstChild.firstChild.click(); } } </script>