Search the Community

Hi, I thought it would be good to put a couple Bulk Edit questions in one place, so anyone else can get a sense of how to edit this feature (I hope someone can help me figure out the answers). 1) Vertical alignment adjusted for the Bulk Edit popup I have some tabular datapages that are deployed in iframes on the bottom part of a web page. The normal vertical align position of the Bulk Edit popup form is appearing way far down (because it defaults to vertical-align=center, I think) and I need to bring it up to the top of the datapage (not the whole html web page it's deployed in, just the datapage). I've looked in the Style for settings for this and found some that appeared to be for the Bulk Edit popup but when I changed it nothing happened, so I'm wondering if it's some additional code that needs to go into the Style. I've attached a screenshot of what I mean- any help would be really appreciated. Thanks and- 2) Hide the left column 'active' check boxes in Bulk Edit popup I need to hide the left column of check boxes that show which Bulk Edit option is 'active.' These boxes 'check themselves' when you select something from the right column of data choices so there's really no need for them-- they confuse my users because they don't know what to check, especially if the right column also has check boxes. I was thinking a table or div with style="display:none" would work but I can't figure out where/how to put that in the datapage. Does anyone know?

Hi, the below code is to disable and relabel the Update button in Bulk Edit when it is clicked (it's a datapage with a lot of records and takes several seconds to update so the user needs to know what's happening and not click the Update button more than once). This code is in the footer of the Results page and not the Bulk Edit form. I need to add the additional code (see below) that redirects to another webpage and I can't figure out where/how to insert it into the disable/relabel code. Does anyone know how to do this? Here's the disable/relabel code for the Update button in Bulk Edit: <script> document.addEventListener('DataPageReady', function (event) { const target = document.querySelector('body'); const observer = new MutationObserver(mutations => { const updateBtn = document.querySelector('input[value="Update"]'); if(updateBtn){ updateBtn.addEventListener('click',function(){ disable(this); redirectToDP(this); }); } }); const config = {subtree:true, childList:true}; observer.observe(target, config); function disable(btn){ btn.disabled = true; btn.style.background="grey"; btn.value = 'Please Wait'; btn.removeEventListener('click',disable); } }); </script> Here's the code in the Bulk Edit footer for redirecting (I think it needs to be there because I have to get parameters from the Bulk Edit data fields): <script> function redirectToDP() { var v_proposal = document.getElementById("BulkEditItems_Triggers_CopyProposalID").value; var v_project = document.getElementById("BulkEditItems_Triggers_CopyProjectID").value; var url = "../proposal?ProposalID=" + v_proposal + "&ProjectID=" + v_project + "&pti=p"; location.replace(url); } </script> I tried to call the function 'redirectToDP' from the disable/relabel code but it doesn't work. Does anyone know how to get the redirect code to work with the disable/relabel code? Many thanks!

Hi, if you're like me, you want to optimize the Bulk Edit modal window for smartphones. This CSS works for me: http://cameronbaney.com/2012/07/26/pure-html5css3-responsive-modal-window/ add it to #BulkUpdateForm

Hi, Does anyone know how to auto-activate the 'Update' button in the Bulk Edits form, so the user does not have to make a selection on any of the fields, in order to Update? I have a Bulk Edit form that has fields that are 'pre-checked' for updating (see attachment) when Bulk Edits is open. I just need the 'Update' button to be activated as well so the user doesn't have to make a selection on any of the fields.

Hi, I'm trying to use some 'After Submit' code in a tabular datapage's Bulk Edit footer to go to a new destination after submission. The code below runs an 'auto submit' in Bulk Edit as well, but I can't get it to go to a new page afterwards. Does anyone know how to format this code so that after Bulk Edit submits a new page is navigated to? <script> var bulkEditSubmit = document.querySelector('.SimpleButton.ActionButton[value=Update]'); console.log(bulkEditSubmit); document.addEventListener('FormSubmitted', function(event) { window.location = '../invoice?InvoiceID=[@field:InvoiceID]&ProjectID=[@field:ProjectID]&pti=i'; }); setTimeout( () => { bulkEditSubmit.click(); }, 1000); </script>

Hi, the below code is used to create comma-delimited text values (in a text255 field) so the user can select multiple values in a list box and save them (separated by commas) in a text field. It's necessary to use this method instead of the Caspio-native 'List' data type because the lookup values need to be dynamic (I wish Caspio would enable this, been waiting FOREVER). This method works great for Details and Update datapages but I need it to also work in a Bulk Edit page. I've tried changing 'EditRecord' to 'BulkEditRecord' but it doesn't work. Does anyone know how to modify this code to work in a Bulk Edit page? This is so the user can select multiple records and update them with multiple selections in a listbox. <script type="text/javascript"> var v_state = "[@field:state]" ; var o_state = document.getElementById("EditRecordstate") ; o_state.multiple = true ; function f_listbox() { if ( v_state.indexOf(",") > 0 ) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_state[i].value == v_state) { o_state.remove(i); break ; } } var o_st = v_state.split(", ") ; for (var j=0 ; j < o_st.length; j++) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options[i].value){ o_state.options[i].selected = true ; break ; } } } } } document.addEventListener('DataPageReady', f_listbox); //You can also use the line below instead of the eventlistener // setTimeout(f_listbox, 20); </script>

Hi, I'm trying to use js to get the user's system date/time on their local computer, in the Bulk Edit section of a tabular datapage. I've used this code in various other datapage types but cannot get it to work in the Bulk Edit footer. In the footer of Bulk Edit, the field is Comments_Actual_Read_Date but it's not capturing the v_TimeStamp value. Does Bulk Edit need something besides EditRecord to reference a field? Here's the code I've got: <SCRIPT LANGUAGE="JavaScript"> /* Declaration and initialization */ Stamp = new Date(); var v_TimeStamp; Hours = Stamp.getHours() Mins = Stamp.getMinutes(); /* Attach a prefix with digit '0' if the minutes is less than 10. */ if (Mins < 10) { Mins = "0" + Mins; } /* Construct the value of the v_TimeStamp variable in the format m/d/yyyy hh:mm */ v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate() + "/"+Stamp.getFullYear() + ' ' + Hours + ":" + Mins); /* Field name - Date_Charge is referred with a prefix - EditRecord */ document.getElementById("EditRecordComments_Actual_Read_Date").value = v_TimeStamp; </SCRIPT> EDIT: Ah, I found a post showing you use 'BulkEdit' instead of 'EditRecord' but now the issue is if js is used to populate the Bulk Edit field it doesn't check the left column 'select' box automatically so the user has to do it manually. This defeats the purpose and is clunky. Is there a way to 'select' the field in Bulk Edit using js?

Unfortunately, this cannot be done with a table trigger because this table is updated by other datapages as well. I have a report that searches training dates, lists providers, and sets an indicator based on the fact that the provider took a training. The indicator can be set to yes for each provider with a bulk edit. An indicator date needs to be added when the indicator is set to yes. If this date is not added, I want it to default to the training date. It seems like it would be easy but I can't get the indicator date to save the training date value in the bulk edit if it is blank. There should be a way to take the training date from the results page, set the indicator date equal to that, and then if the user doesn't change that when setting the indicator in the bulk edit to yes/checked, it would save that training date in that indicator date field. I looked into doing this with a trigger, loading the training date into the indicator date field on load, using a placeholder, and JavaScript, but I can't get the value to save. If anyone has advice on how to do this, I would appreciate knowing about it. Thanks.

Hi, Does anyone know how/where to change the css in the Styles for the Bulk Edit link when it's hovered over, for a tabular datapage. I can change the style for the link in Source/Page Action section: .cbResultSetBulkEditActionLink { /*Results Page Bulk Edit ActionLink Attributes (For Gallery And List Pages)*/ color: green; font-family: Arial, sans-serif; font-size: 14px; font-weight: 600; text-decoration: none; } However, this only changes the link style when it's not hovered over. When hovered over the 'Bulk Edit' link reverts to its default styling and looks jarring. There must be some css somewhere for something like .cbResultSetBulkEditActionLink:hover but I cannot find it. EDIT: In case anyone needs a solution to something like this, I ended up sort of finding a solution. If you put _hover after it (what Caspio seems to use to designate hover), it basically removes the hover effect (it's supposed to change it, if you change the css but it seems to have just disabled hover). So if you put something like: .cbResultSetBulkEditActionLink { /*Results Page Bulk Edit ActionLink Attributes (For Gallery And List Pages)*/ color: green; font-family: Arial, sans-serif; font-size: 14px; font-weight: 600; text-decoration: none; } .cbResultSetBulkEditActionLink_hover { /*Results Page Bulk Edit ActionLink Attributes (For Gallery And List Pages)*/ color: green; font-family: Arial, sans-serif; font-size: 14px; font-weight: 800; text-decoration: none; } in Source/User Defined Styles it seems to work.

I have a Tabular report in which Bulk Edit is enabled. I would like to have a Javascript that will allow to automatically put a check in the Select All check box and automatically click the BULK edit link. Is this possible?

How can I redirect my DataPage after a Bulk Edit process? I have a Tabular report and I have the Bulk Edit feature enabled. After, I clicked on the Update button in the BULK Edit Window, I want it to be redirected to the Submission DataPage.

Hi, Does anyone know how to put code in the footer of a Bulk Edit form so it auto-submits (so the user doesn't have to click the Update button)? This code: <script type="text/javascript"> if(document.getElementById("caspioform")) { document.getElementById("caspioform").style.display = 'none'; setTimeout('document.forms["caspioform"].submit()',1000); } </script> works only on a regular Update or Submission form. If you use it in Bulk Edit it just keeps refreshing the records over and over. So there must be some specific code for Bulk Edit. As well, if I can get Bulk Edit to auto-submit I'd like to remove he Update button so if anyone has code for that it'd be really great. Thanks!

Does anyone know how to configure Bulk Edit to update a hidden check box to No or False? You can update a hidden checkbox to Yes but if you set the Default value to 'blank' it won't update the value to No/False- it just leaves it as is. I need to do this with a hidden checkbox so the user doesn't have to 'select' the checkbox field box in order to update to No/False. Any help would be great- thanks!

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 have a tabular datapage that I'm using Bulk Edit to update selected records. When the 'Update' button is clicked I need to redirect to another url (using some parameters passed). I've tried a number of methods but can't seem to get it to work. - tried a custom 'update' button in an html block but it doesn't actually update the selected records (perhaps this is because and 'Update' on a Bulk Edit isn't the same as on a Details page?) - tried to modify, in Localization, the Bulk Edit text with html code for the redirect url but it just shows the html markup in the button. Not sure if there's a way to do this there but it seems like it'd be cleanest if so. Any help would be greatly appreciated-

Hi, I'm using an app parameter on a search and report that displays calculated totals based on the end users search. The end user then has the ability to make changes (via the bulk edit) to the data displayed in the report. Once the bulk edit is submitted the data on the report refreshes fine; the app parameter does not refresh to show the changes made by the end user. The app parameter is being used to display grand totals. I can click the refresh in the browser which does update the app parameter. How do I get Caspio's app parameter to update when the report is updated without performing a manual browser refresh? Thanks, Bre

Good Morning, I'm using a bulk edit on a tabular search and report. I've noticed that my Cascading drop-downs in the bulk edit show blank entries when there in no data for the filed being edited in it's own table. I have a view set-up to filter out blank entries in the table being used for value purposes; however unless the field has data in its own table it still shows a blank. I found the following code for standard drop downs but haven't found any information for cascading drop downs used in the bulk edit. Hoping someone can assist with code updates. All my attempts have been unsuccessful. Thanks...Bre <SCRIPT LANGUAGE="JavaScript"> <!-- Function removeBlanksInDropdown searches for blank entries and removes all occurrences. It is advisable to use this script with the "Show distinct display options" checkbox checked in the dropdown configuration in the Caspio Bridge DataPage Wizard --> function removeBlanksInDropdown() { /* dropdown stores the value of the dropdown form element reference in the DataPage. */ var dropdown = document.getElementsByName("Value1_1"); for (var q = dropdown[0].length-1; q >= 0; q--) { if (dropdown[0].options[q].value == "") dropdown[0].remove(q); } } document.addEventListener('DataPageReady', removeBlanksInDropdown); </SCRIPT>

Hello! This might be an unusual request, but I am looking for a way to create and stamp a new submission ID on multiple records each time a bulk edit is submitted for a particular DataPage. The ID needs to be unique to other IDs, but it will be stamped on multiple records in the table at the point of submission. My thought was to create a hidden field with a default value, which would be a combination of a prefix (i.e., WO-) and then a system parameter (i.e., [@cbTimestamp]). The problem I'm running into is that I would like the date to be broken down into a numeric string instead of having spaces and punctuation, such as dashes and colons. This is what I'm currently getting: WO-08/30/2017 11:34:46. I would like to get this instead: WO-1504110886. Any ideas on this? I very well may be overthinking things, so I welcome suggestions. We don't have to use the timestamp at all, but it was just an idea for how to create a unique ID at the point of submission.

Hi there, I would like to share a JS solution which I have used for my project. This script that can be used to clear fields in the bulk edit screen. The bulk edit screen typically displays the data from the last update, and my JS allows not show the previous content of fields. Place following JS into the Footer of Bulk edit screen. Make sure that you have disabled HTML editor. <script type="text/javascript"> var aaa= document.getElementById("BulkUpdateFormBody"); var v_li = aaa.getElementsByTagName("input"); var v_ls = aaa.getElementsByTagName("select"); var v_lt = aaa.getElementsByTagName("textarea"); var f_tmpf = function(v_list, v_resList){ var v_res = v_resList || []; var v_length = v_list.length; for(var v_i = 0; v_i < v_length; v_i++) if((v_list[v_i].type || "").toUpperCase()!="HIDDEN" && (v_list[v_i].nodeName||'').search(/input|select|textarea/ig) != -1) v_res.push(v_list[v_i]); v_resList = v_res; return v_res; } var v_cleanI=f_tmpf(v_lt, f_tmpf(v_ls, f_tmpf(v_li, []))); v_cleanI.forEach(function(v_i){ v_i.value = ""; }); </script> I hope this will be useful for someone.

I use some script to get the user computer's date and enter it into a text field as a TimeStamp. I have it go into a text field and not a date field because I use that value to concatenate with other text fields for display purposes. I also use the script below so I can get the user computer date because users are all over the globe and setting a time zone in localization doesn't work (since everyone is on a different time zone). This all works fine in the Details page, upon update. But I also need the script to fill the Bulk Edit selected records field. I'm wondering if it's because Bulk Edit is designed for multiple records that the script doesn't work? I've tried the text filed for the date (Comments_Actual_Read_Date) as either hidden or text in Bulk Update but it's not updating. I think if Hidden the field should update without having the left hand check box checked. Here's the code in the footer of Bulk Update: <SCRIPT LANGUAGE="JavaScript"> /* Declaration and initialization */ Stamp = new Date(); var v_TimeStamp; Hours = Stamp.getHours() Mins = Stamp.getMinutes(); Secs = Stamp.getSeconds(); /* Attach a prefix with digit '0' if the minutes is less than 10. */ if (Mins < 10) { Mins = "0" + Mins; } /* Construct the value of the v_TimeStamp variable in the format m/d/yyyy hh:mm */ v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getFullYear() + ' ' + Hours + ":" + Mins + ":" + Secs); document.getElementById("EditRecordComments_Actual_Read_Date").value=v_TimeStamp; </SCRIPT> Any help would be great- thanks!

Hello - I only have one field to update for Bulk Editing and I would assign that field for bulk edit it's default value. May you please help me to have a script that will trigger the auto submit form for this bulk edit. Thank you so much

We have a number of processes which were originally built to update single records and used javascript to test for certain conditions and post values into fields dependiong upon the results. As an example, if an agent clicks the JS button to mark a job as compete, the script caclulates the current time plus 10 minutes and posts that to a field. When looking at the "live" situation on screen, the controller screen filters for jobs that are either no marked as complete, or where the Completed Time + 10 mins field value is after no (i.e. a job will be shown if completed within the last 9 minutes). This process works fine when an agent is only dealing with a single job but if he is processing a bulk edit of multiple jobs, the script fails to operate. Is it possible to run javascripts within the bulk edit popup window and if so, is there some code we need to enter to ensure that each record selected for bulk edit receives the same correct data? Any helkp woud be appreciated - even if it just tells me that it cannot be done so I can stop wasting my time trying. Thanks

We have an App that ideally we would like a user to be able to use the Bulk Edit facility to amend a value within a field and have this applied to all applicable records. So far so good. But we also need that value added to another notes type field within each of the affected records. In other datapages we use some javascript to concatenate the "value" to the notes field - you press Update and it all works great. Ideally would love to be able to do this with a Bulk Edit facility. However we have tried it and it did not seem to work. Perhaps the JS just wont work in this setting. Anyone any ideas for how we might achieve same or similar effect? George

First off, I have to say that the new 'bulk edit' and 'bulk delete' features are excellent and I'm sure will be a huge time saver for developers and end users alike! However, what I'd like to know is how to 'trigger' the acknowledgement emails from the grid, after a bulk update. At the moment, my individual records fire off an acknowledgement email from the details page when they've been updated. After updating them in bulk (or using the grid edit), I lose the acknowledgement email functionality unless I open the individual record and manually click on 'update' on the details page. Can the update button that triggers the email be included on the grid? Any thoughts would be appreciated!