Search the Community

Hello all, Thanks in advance for looking at this. I'm looking for a clean way to refresh the data in a tabular search and report without reloading the whole page. I know that enabling AJAX in the Wizard allows the tabular report to use AJAX to filter and page through results without needing to reload the entire page each time. Reloading the whole page mandates that the user enter in all of the required search values prior to seeing the updated data. I am looking for a way around this. I currently have a system that works where I have added a calculated field as the final column in my results table. In that calculated field I have already placed "GetUTCDate()" . I named the calculated field "Last Updated: (click to refresh)". Essentially this shows up as a column and displays the date and time the table data was loaded. Filtering by this column refreshes the data and updates the "Last Updated:..." field as well. For me this solution currently does work, however I would be interested in a cleaner way of accomplishing this. Perhaps a method that does not require the use of its own dedicated column in the table is possible. On a side note, the data that I am most interested in refreshing is another calculated field (SQL). This is relevant because (at minimum) I do not actually need the entire table to refresh if only there is a way to refresh these calculated fields. Thanks again for bearing with me. I'm curious to see if others have had a similar problem or could use this solution that I currently have in place. COdell

I've been successfully passing parameters from a submission form, deployed as embedded in my web page, to a tab structure that contains several datapages for the results. This tab structure (also deployed embedded) is based on nested iframes and was built using Caspios embedded tab interface So far so good. Recently I modified the submission form by putting it in a tab structure with other submission form datapages. But this time I used the Ajax approach suggested by Caspio (http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/create-tabbed-navigation-for-multiple-datapages/) because I was told that this would be more reliable for passing parameters than using a second iframe embedded structure on the same web page. So in summary I have submission form tabs (Ajax based), passing parameters to nested iframe tabs Unfortunately the parameters which used to be passed are no longer being passed. Any ideas?

Hi there! I'm trying to create a submission page in which part of includes the option to submit a file. I am able to use the API to submit normal text info (dates/numbers/prices/etc.), but submitting files is some what of an issue. Currently, this is what I have: The code that retrieves the file and calls the API request leFile = $('#customFile')[0].files[0]; var formData = new FormData(); console.log("form data: " + $.type(formData)) var blob = new File([leFile], leFile.name, {type: leFile.type}) formData.append('file', blob); $(this).caspioPostFile(formData,leFile.name,leFile.type); The API request itself: $.fn.caspioPostFile = function(fData,fName){ //Get access token console.log($.type(fData)); $.post( "https://" + cbIntegrationId + ".caspio.com/oauth/token", { grant_type: "client_credentials", client_id: clientId, client_secret: clientSecret }, function(cbAuth){ //Run POST call $.ajax({ url: "https://" + cbIntegrationId + ".caspio.com/rest/v2/files", type: 'POST', data: fData, processData: false, cache: false, headers: { "Authorization": "Bearer " + cbAuth.access_token, "Content-Type": "application/json", "Accept": "application/json", "Content-Disposition": "attachment; filename="+fName }, dataType: 'json', success: function (data) { console.log("Post Success") console.log(data.Result); }, error: function(data) { console.log("Post Failure") console.log(data.responseJSON); } }); } ); }; Now before I get this as a response, yes I have viewed almost every page on Caspio's site for documentation on rest API v2 and v1, but the problem is that none of it has any concrete examples of code for making this request in v2. The swagger site and its documentation also doesn't help my case for the same reason. I have switched the content-type from application/json to multipart/form-data and back, I have attempted adding Access Control headers, but all of it results in a failed request (returning POST 400, POST 415, or an issue with CORS policy). Does anyone know what I'm doing wrong, or has an example that I could potentially pull from?

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

I have three data pages on one web page (WordPress site): 1 input form, one tabular datapage with inline editing enabled, and one pivot datapage all working from the same table. When the user inputs data via the input form, the AJAX feature works great and both other two reports update instantaneously without a page refresh (quite impressive). However, if the user chooses to go over to the tabular datapage and edit or delete an item, then the AJAX updating doesn't work for updating the pivot table right below it. Is there something wrong with my setup or is this not even an option/possible. Thank you, Kaveh

Hello! I am using the HTTP basic authentication method for my mobile app and have followed the POST request as outlined on the website. My ajax call is as follows: $(document).ready (function () { $('button').click(function () { var Client_ID = $('clientid').val(); var Client_Secret = $('clientsecret').val(); $.ajax ({ type: 'POST', url: 'Token endpoint', data: 'grant_type=client_credentials', headers: { 'Authorization' : 'Basic Q2xpZW50X0lEOkNsaWVudF9TZWNyZXQ=' }, success: function(data) { window.location.href = 'page1.html'; }, }); }); I encoded the string "Client_ID:Client_Secret" as advised too. Upon checking my network console, I'm getting a 400 error. Can anyone help?

I have a combined chart and report datapage that I use to display a list of jobs and their status. I would like the list and chart to have dynamic colours according to their status. This is quite easily accomplished, and in fact I have already completed it. My issue comes in place with AJAX. I cannot disable AJAX on a combined chart/report datapage, therefore when I do a bulk edit on my report, the chart reverts back to the default colours. I am guessing this is because the chart loads without running the javascript in the datapage. Is there a way to execute javascript in a datapage not only on load, but also on an AJAX call? Thanks, Josh EDIT: I just realized that it's not because of the combined chart/report that I cannot turn off AJAX, but it is because of the grid edit.

Hello, New user here. I have a couple of datafields added and all seems to be working well except that any fields that have been set to REQUIRED that don't have info in requires the form be submitted and a full page reload before being flagged. This is a huge issue for me. Is there a way (Ajax?) that the required fields can be checked for content upon SUBMIT without the page being completely reloaded? Thanks! Troy.