JEllington

just to put this out there.. if you are not concerned with the "Data Table" tooltip displaying on older (non ES6 compatible) browsers. You can skip the overhead of using jquery and use querySelectorAll with the script located at the end of the footer in your Tabular Report DataPages, such as... <!-- remove "Data Table" tooltip from Tabular report --> <script> document.querySelectorAll("table[data-cb-name='cbTable']")[0].removeAttribute("title"); </script> Keep in mind the reason for using the jquery in previous solutions is for backwards compatibility with older browsers that do not support querySelectorAll.

Loading the script in the footer fixed the issue. With the script functioning correctly in legacy and not with async deployment, I didn't think to put the script code in the footer. Thank You so much for your help.

Hello.. I have a tabular report that will not recognize an element using document.getElementById( "elmName" ) (loctated in the Header of a report), if the datapage is deployed using ASYNC deployment... <script type="text/javascript" src="http://b4.caspio.com/dp/d6a9blahblah/emb"></script> returning a console message " VM3106:22 Uncaught TypeError: Cannot set property 'innerHTML' of null". If i put the script in the console as.. document.getElementById( "elmName" ).innerHTML = '<a href="httpcodehere">Test Button</a>'; the script runs without errors and replaces the html in the <div id="elmName">Original Text</div>.I have found if I use the legacy deployment .. <script type="text/javascript" src="https://b4.caspio.com/scripts/e1.js"></script> <script type="application/javascript">try{f_cbload("d6a9blahblah","https:");}catch(v_e){;}</script> the script runs document.getElementById without errors. (I have tried running this script in other tabular report datapages deployed asynchronously all with the same error and results. Then switching them to legacy deployment and the script runs without error.) Can anyone give me any insight on why the document.getElementById will not work if the datapage is using ASYNC deployment?

RESOLVED.. I was able to set the cbResultSetSearchAgainContainer display properties to none in the styles sheet..

attached are screen shots of datapage resuylts with and without data. Search again only displays when no data is found for record

Hello Vitlikssssss, yes I have unchecked all options. What is puzzling is the search again link only displays when there is no data found for the record (where if it were an option I would think it would show all the time regardless of the presence of data).

Hello, I have a Details Report DataPage that if no data is found (351) the results html page displays a “Search Again” link button, that displays only if no data is found. I have gone into the styles for the page and disabled the search icon and in the localization cleared the “Search Again” in the labels and markers section and it still displays the Search Again link. If I put 1 character in the custom text area it displays just that one character but if I delete all characters in the area it reverts to displaying "Search Again". Can anyone please let me know how to disable the Search Again link altogether. All comments are greatly appreciated.

Dazzler.. Thank you!! Brilliant fix. I was trying to figure out how to loop through each row and this does the trick perfectly. Many thanks on the amount of hair that can now remain on my head. (I was worried of pulling it all out over this one) Jim Ellington

Since the CB 10.0 upgrade Ive been updating all the deploy codes in my datapages utilizing the new Asynchronous DataPage Deployment Method (a noticeable pageload improvement over the legacy deployment method, plus no more chrome deprecated warnings in the console Thank you for this improvement Caspio). One problem I am faced with now is I have several tabular report pages that conditionally load link buttons dependent on the status field of each row. With the legacy page deployment I was able to perform this with the following script in an html block... <script> var stat = '[@field:Status]' if (stat == 'Assigned') { document.write('<a class="recordActions" href="assignedwopage.html?on=[@field:WO_Num]&at=[@field:Assigned_Tech]&stat=begin">View/Open WO</a>'); } else if (stat == '~Suspended') { document.write('<a class="recordActions" href="resumewopage.html?on=[@field:WO_Num]&at=[@field:Assigned_Tech]">Resume WO</a>'); } else { document.write('<label>WO Pending Review</label>'); } </script> -------------------------------------------------------- The innerHTML solution I came up with to replace the document.write follows... <div id="linkto"></div> <script> var stat = '[@field:Status]' if (stat == 'Assigned') { document.getElementById("linkto").innerHTML = '<a class="recordActions" href="assignedwopage.html?on=[@field:WO_Num]&at=[@field:Assigned_Tech]&stat=begin">View/Open WO</a>'; } else if (stat == '~Suspended') { document.getElementById("linkto").innerHTML = '<a class="recordActions" href="resumewopage.html?on=[@field:WO_Num]&at=[@field:Assigned_Tech]">Resume WO</a>'; } else { document.getElementById("linkto").innerHTML = '<label>WO Pending Review</label>'; } </script> Apparently this does not work because the “linkto” div is an html collection within the html block and improperly assigns the last read value to only the first row in the table. I tried a createElement method along with several other ideas all with the same results. Can anyone please inform me on the proper method to perform for the desired result of displaying a link button conditionally in a report. Thanks in advance for any and all suggestions.

I have a table with a field named Total_Time with a function datatype, that calculates total time using the flowing formula.. Round(((([@field:End_Hour] - [@field:Start_Hour]) * 60 + ([@field:End_Min]-[@field:Start_Min])) - (([@field:Break_Fin_Hour] - [@field:Break_Start_Hour]) * 60 + ([@field:Break_Fin_Min]-[@field:Break_Start_Min]))) /60 ,2) This works as expected… Now I would like to add a conditional statement that checks the value of the field "Assigned_Tech" and if the value is “Summary” then leave the Total_Time field blank, else run the formula. Im thinking.. CASE IF ([@field: Assigned_Tech])!==”Summary” THEN Round(((([@field:End_Hour] - [@field:Start_Hour]) * 60 + ([@field:End_Min]-[@field:Start_Min])) - (([@field:Break_Fin_Hour] - [@field:Break_Start_Hour]) * 60 + ([@field:Break_Fin_Min]-[@field:Break_Start_Min]))) /60 ,2) END Can someone please help me with the correct case statement to use. I spent 2 days writing the total_time formula and now am in a bit over my head using conditional statements in the formula. Thanks in advance for any an all help

Thank you May.. you are Awesome!!

I am having a problem with the Signature Pad working correctly on an html page that has more than one datapage embedded in it. As per http://forums.caspio.com/index.php?/topic/4693-js-adding-a-digital-signature-to-a-submission-form The sig pad works as desired only in the first datapage embedded on an HTML page. Any additional datapages embedded into the html page throw console errors accessing the sig canvas. The problem is.. I have an HTML page that displays an invoice. The first embedded datapage displays customer information, a second embedded datpage displays inventory items used and a third datapage containing the sigpad script, requires a customer signature and collects closing details then submits the invoice. The third datapage throws console errors running the sig pad script. If I move the third datpage (the page that contains the signature script) to the top of the html page above the 1st and 2nd datapages the sigpag works correctly. Proving the script works only if it is contained within the first embedded datapage. To work around this I created an HTML popup window that handles the signature. except now I find that I must have the signature script within the third datpage. Any help on getting the sigpad working on an additional embedded datapage is greatly appreciated.

The custom batch report works good. Is there a way to to save your session selections, so you dont have to go through the selection process every time? Thank You Mathilda

I am able to export my apps manually one at a time (extremely time-consuming) through “Tools/Export”. Is there a way to batch export all Apps? I have setup “Scheduled Export Tasks” through DataHub on my account. I am able to export Tables and Views but do not see an option to export the App’s datas pages. Am I missing something or does the DataHub task scheduler only support tables and views for export. Thanks in advance for all sugestions

Has anyone had any experience using the digital signature pad (http://forums.caspio.com/index.php?/topic/4693-js-adding-a-digital-signature-to-a-submission-form/) on a tablet? It mentions in the App notes that the pad is compatible with mobile devices. The signature works fine with a mouse on my desktop, but nothing on a touch screen tablet (Galaxy S2). Is there a setting in the tablet, or a plug-in that I need to enable (mouse drawing) functionality for the signature pad to work on a mobile device? UPDATE: my apologies for posting this thread without thoroughly researching the problem. After successfully testing the signature box on my phone and another tablet. I have concluded the issue is with my tablet. After a system reset the signature pad woks fine onthe tablet. Thank you Caspio and All for posting such helpful javascript snippets.