Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by Breee

  1. Hi. I reached out to suppot a while back and was advised that hiding columns in the new PDF download feature would be considered custom code. This was surprising since the pdf generator provided by Caspio only displays what the user sees on the screen and all hiden elements remain hidden; the only hiccup is that this process requires 2 datapages to work properly. The PDF generator only captures what is on the page along with set margins and zooms that I added to the code. I still don't have an answer to this issue related to the new PDF download feature so I thought I'd check back to see if anyone has found a way to hide columns when using it. I have lots of calculations so my report download is super small when the PDF is produced. All input is greatly appreciated. Thanks.
  2. Thanks for the response. I have opened a support ticket. I'll update this thread when I receive feed back. Best, Breee
  3. Hi, I'm using the new Caspio PDF report download option. I'm noticing that my hidden columns show up on the PDF. Previously, I was using the Caspio PDF generator code provided by Caspio based on my account type and the hidden columns remained hidden. I tried placing the hide column JavaScript in the source code for the PDF configuration but that does not seem to work. Does anyone know how to hide columns on the tabular reports using the new PDF feature? I'm using the the data in the hidden columns for SQL calculation purposes but the end user does not need to see the raw math. As always, I appreciate the input. Thanks, Bre
  4. Good Morning, Is anyone else experiencing any tabular report styling issues since the new release? I was informed by support that my pages that use javascript might be conflicting with AJAX. I'm confused because they were perfectly fine prior to the release. Over the weekend I went through my entire application and found that there are styling glitches that are happening. For example, my bulk edit dialog displays on top of the tabular report. If the user decides to make addt'l updates it displays behind the report when selected a 2nd time. The z-index is set for this element so I'm not sure why the sudden changes to the display. I also have the group label issues mentioned above the col-span tag disappears, checkboxes not displaying, etc. I'm trying to determine if I'm the only one experiencing this. It's frustrating because everything has been working just fine for more than a year. Further, it's limiting the functionality of my application. I'd appreciate any feedback. Thanks. Bre
  5. Thanks Douvega I will try that to see if it works. I'm with you on the whole clear cache external user situation steveruehlen. This is my issue as well. I also experienced some styling issues with my reports so I'm afraid to touch anything at the moment. I have Caspio support assisting so I'm hoping that will also be resolved. Thank you both for your input. Bre.
  6. Hi, I use grouping on most of my tabular reports. I'm still actively working on my application so I may have to go back to already existing datapages for edits all the while creating new datapages. What I've noticed is that the grouping function for tabular reports use to display a col-span styling element that no longer exists post the Caspio Update. If I create new datapages or edit new ones my grouping is working in the likeness of standard column headers which defeats the purpose of having a grouping capability. In my pre Caspio Update existing datapages that have not been edited since the update the grouping headers span the entire column count as they should. Does anyone know how to fix this? I have over 150 datapages that use grouping in some capacity. As you can imagine, it's a lot of work. My reports do not look that great w/o the grouping function spanning the column count. Please see examples below. For example: Pre Caspio Update (Correct) - Test Group Header (Spans 3 Columns) Column 1 Colum 2 Colum3 Post Caspio Update (Incorrect) - Test Group Header (Spans Itself Only) Column 1 Column 2 Column 3 Thanks. Bre
  7. Yes, I experienced this issue as well. It was resolved by clearing the cache and browser. Not the perfect fix but at least users can log-in.
  8. I am also trying to apply the same logic on a bulk edit webform I need the update button to hide conditionally. I need to hide the update button when CorpEOPIDGen is checked (yes) . I'm unable to call the bulk edit update button to hide it based on the checked logic above. This is what I have so far. <script> if (document.getElementById("EditRecordCorpEOPIDGen").checked){ document.getElementById("Mod0EditRecord").style.display="none"; } </script> ...also tried <script> if (document.getElementById("BulkEditCorpEOPIDGen").checked){ document.getElementById("Mod0EditRecord").style.display="none"; } </script> I've yet to successfully hide the update button on the bulk edit webform. Any assistance would be appreciated. Thank you.
  9. Thank you so much DesiLogic! This works perfectly! Bre
  10. Hi Franchiser, I'll post a sample page is a few. In the meantime here are the end-user's steps. Ex: - Enter search criteria into Caspio Search Form - Search and Report displays 5 rows; calcfield value of each row is $20.00. - App Parameter (used is the header section of the report) includes a calcfield that shows the sum/grand total amount of the 5 rows displayed on the search and report $100.00 (5 rows at $20.00 each = $100.00). - End User changes the first row to $0.00 using the bulk edit update. - Search and Report displays $0.00 for the '1st' row and $20.00 each for the remaining '4' rows = $80.00 - App Parameter continues to show old grand total amount, $100.00, as if the bulk edit update did not occur. (Manually refreshing the page will display the updated grand total amount of $80.00) **It seems that the bulk edit update function does not apply to app parameters whose data might be affected when calcfields are being used in the app parameter. I'm trying to bypass having the end user manually refresh the page whenever an update is made to the report using the bulk edit. Is there a way to refresh a page after the bulk edit update button is clicked? Thanks so much for taking a look at my question. It is greatly appreciated. Bre
  11. Hi Carlson, Thanks so much for the feedback. The update seems to have affected some of my scripts and my delete triggers. Grateful that you will be sharing your troubleshooting results with the community. Many Thanks! Bre
  12. Hi. I've been using this script which was working perfectly through last week. Currently, it selects the checkboxes but now fails to select the bulk edit link. I'm not sure how to update the script to open the link. Any assistance would be appreciated. Thanks. Bre
  13. 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
  14. Hi Roattw, I had similiar issues when starting out. Capio's calc fields have some limitations that I wasn't accustomed to. I reached out to support and was provided with the following guidelines for the use of SQL in Caspio's calc fields: Here what can be used in our calculated fields:- Any expression: https://msdn.microsoft.com/en-us/library/ms190286.aspx- Any transact SQL function - https://msdn.microsoft.com/en-us/library/ms174318.aspx- CASE statement - https://msdn.microsoft.com/en-us/library/ms181765.aspx- SELECT returning scalar value: https://msdn.microsoft.com/en-us/library/ms189499.aspxYou cannot:- Define variables - Define functions- Use UPDATE/DELETE/INSERT clause. Hope this helps a little. Bre
  15. Hi, I have a trigger that has been functioning for well close to two months without issue. Suddenly, the trigger is failing to validate or push/delete information to the specified table. Upon review I'm now receiving this error message 2031 "Datasource field is invalid because it's name is absent" is a where clause. This is strange since no changes have been made to the trigger or the tables. The datasource fields are present which is why they are able to be selected. I tried to research the error but it seems to be general in nature. Also, the same datasource fields are being used in a where clause elsewhere in the same trigger without issue. Any direction that can be provided would be much appreciated. This is a MASTER trigger that provides the backbone of my application for all intensive purposes. Thanks, Bre
  16. 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>
  17. Good Morning, I'm attempting to close a search and report after a bulk edit is processed. Per the F12 developer tool the button element is as follows: <input class="SimpleButton ActionButton" type="button" value="Update" style="max-width: 720.5px;"> I'm unable to use the emails and destinations page since this is a bulk edit. Is there a way to modify the above code for bulk edit window closure? My attempts to create a new button have lost the bulk edits altogether. Currently, I'm using criteria on the bulk edit's search and report (Does not contain "False") along with a localization script to perform a crude window closure and page refresh which is working. The issue is that since the bulk edit sets the false criteria it's filtered out of the bulk edit's report indefinitely unless the user makes a change to the record which might not happen. My goal is to keep all records together no matter the rate updates. My process is below. Method currently being used is as follows: I'm using a (Rate Update)search and report with bulk edit to update rates in many records. The user decides the records that require updates. All of these records have the same Invoice ID (unique ID). I'm then using a pop-up window link to a 2nd search and report (Payment Details) on the 1st search and report (Rates). The link automatically selects all records with the same Invoice ID on the 2nd search and report and opens the bulk edit for that report. The user can only view the bulk edit box (set at 100% of the 2nd data page height and width). I added this control to ensure that the user selects all records associated with the Invoice ID to add the updated invoice's payment details (pay date/check no/etc.). This way even if updates were not made to the rates of each record the records will always stay together on each updated invoice. Once the 2nd search and report's (Payment Details) bulk edit is complete it assigns "false" to each of the automatically selected records that share the same Invoice ID. The Payment Details search and report filters out the "false" text and defers to the "No records" script that I"ve placed in the localization for Payment Details. The above works well the first time around. Every time thereafter it does not work. This is because the record would have to be selected in the 1st (Rate) search and report to have "True" added back to the record so that it will not filter out of the 2nd (Payment Detail) bulk edit. I cannot rely on the user to select each record. Select ALL can't be used because the rates are different for each record. What I'd like to happen is for the bulk edit window (Payment Details) and the it's search and report to close after the update button is clicked in the bulk edit. Currently, without the above steps the window just stays open and the report can be viewed; the 1st datapage will not refresh with the latest updates. I appreciate any assistance that can be provided. Thank you! Bre
  18. 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
  19. Breee

    Hiding the header

    Thanks again for responding. I did insert: <span id="HideHeader"><h1> [@app:ORG_Hourly_EOP_Header] </h1></span> into the the header section of the configure results screen but the header is still displaying. I checked with Caspio support and they suggested that I check in forum for assistance. I'm not sure how to get the code to recognize the app parameter for hiding purposes. Any other suggestions would be appreciated. Again, Thank you. Bre
  20. Breee

    Hiding the header

    Good Morning, Thank you so much for your reply. My header is an app parameter [@app:ORG_Hourly_EOP_Header]. I added the following code to localization and the header and footer locations of my datapage (configure results page); the localization message is showing "No Records Found." The app parameter header is still displaying it is not hidden. I'm showing the code that I used and its placement below. Localization: Forms/Details Messages 351: <div id="norecord"><h1>No records found.</h1></div> Datapage Configrure Results Page Header: <span id="HideHeader"><h1>Text</h1></span> (I'm assuming that I need to call the app parameter into the div somehow but I'm unsure how to go about that). Datapage Configrure Results Page Footer: <script>function func_NoRec_Header() { if (document.getElementById("norecord")) document.getElementById("HideHeader").style.display = "none"; } //window.onload=func_NoRec_Header; document.addEventListener('DataPageReady', func_NoRec_Header); </script> Further assistance would be greatly appreciated. Thank you. Bre
  21. Breee

    Hiding the header

    Hi, Does anyone know how to modify this code to hide "APP Parameter" headers? I tried updating the above and also used the Hide Map instructions found earlier; both attempts to update have not been successful. I have a search filter on a datapage that is using an "APP Parameter" header. When a search returns "no records" based on the filtering of data I need for the header to hide and for a message to display in its place. Currently, when the search occurs and no data is returned the header shows with blank information and live URL links. I'd like to hide the header in its entirety and direct the user via a message to search another area of the website. Thanks.
  22. Hi, Is there a newer version of this script? Can it be used to calculate cumulative time difference? For example, I have timestamps for records entered into my table and need to have the difference between the new stamp and the previous timestamp for logging and auditing purposes for each unique ID. All stamps are entered into the same column. I'm already calculating the difference between start and end times which is working perfectly using the date diff function. However, the difference that I'd like to capture name all the data is in the same column. (Column) Time_Stamp Unique ID: 25 Row 1) 01/28/2018 18:06:32 Row 2) 01/29/2018 18:06: 32 Row 3) 01/29/2018 19:06:32 The Time difference would a follows: Row 1) Null (No previous time_stamps for Unique ID 25) Row 2) 24 Hrs. (Row 2 - Row 1) Row 3) 1 Hr. (Row 3-Row2) and so on .... I'd appreciate any feedback that can be provided. Thanks, Bre
  23. Hi, I struggled with this for a few days so I thought it best to share what ultimately worked for me. In case anyone has a like issue with having a tab within the IFrame refresh without landing back on the parent page I was able to figure out how to refresh the child IFrame tab separate from the parent location without creating a button for refresh. The Caspio Embedded tab interface code does not designate a DIV ID; a DIV ID is required for the script to work. Also, the IFrame must include a name that you will have to add in as well. I've highlighted in red the items that need to be added to the existing code. Bolded red items are the glue that make the script work so be sure to check them. The blue highlights are tab names and the Iframe URL's that should be updated according to your needs. In the example below I'm only refreshing 1 of my tabs. However, if you need to refresh mutliple tabs on click you can add to the script below. No changes were made to the styling that is provided by Caspio so I'm eliminating that from the example below. <div style="display:block; text-align:left;"> <div style="display:block;"> <div id="iframeRefresher"> <ul id="menu"> <li><a onclick="channel(0)">How To</a></li> <li><a onclick="channel(1)">e-Order New Entry</a></li> <li><a onclick="channel(2)">e-Order Add Vendor</a></li> <li><a onclick="channel(3)">Status</a></li> </ul> </div> <div class="content"> <iframe frameborder=0 id="viewer0" class="ChannelView" src="http://www.test.com/test1-0.html" style="display:inline"></iframe> <iframe frameborder=0 id="viewer1" class="ChannelView" src="http://www.test.com/test1-1.html"></iframe> <iframe frameborder=0 id="viewer2" class="ChannelView" src="http://www.test.com/test1-2.html"></iframe> <iframe name="test" frameborder=0 id="viewer3" class="ChannelView" src="http://www.test.com/test1-3"></iframe> </div> </div> <script> window.onload = function() { document.getElementById('iframeRefresher').addEventListener('click', function() { var ifr = document.getElementsByName('test')[0]; ifr.src = ifr.src; }); } </script> Thanks to anyone who may have been reviewing my question but not yet responded with an answer. I know that all were quite lengthy. Best, Bre
  24. I was finally able to generate the Unique Value using str. (Str([@field:Number1])+Space(1)+Str([@field:Number2]))+Space(1)+[@field:Text] The Number 1 field is and will always be a 7 digit number. The str uses a default of 10 digits. I'd like to correct the spacing of the Number 1 field to 7 digits for table formatting purposes. I'm not sure how to lessen the default number to 7 in the above formula. Thanks. Bre
  25. Good Morning, I'm using the new release 9.8 UniqueID formula field feature to get a Unique_Value for data restriction purposes. I have a field in a table where the unique value is working properly. The field datatypes are data/time and text. I used the following script to get the unique value in the table. Convert(varchar,Month([@field:TruckDate])) +'/' +Convert(varchar,Day([@field:TruckDate])) + '/' +Convert(varchar,Year([@field:TruckDate])) + [@field:Project_Name] I'm attempting to set up another Unique Value in a separate table. The field types are 2 number fields and 1 text field. The formula is verified by the caspio formula checker but the values are not showing up in the table properly. The fields are as follows. [@field:number1] (number data type), [@field:number2](number data type), [@field:Text] (text data type). The above method '[@field:Number1]' + '[@field:Number2]' adds the number fields which is not the result that's needed. It also will not allow the concatenate of the text field [@field:text] with the number data. 1000102 (result Unique Value) If I use '[@field:Number1]''[@field:Number2]' the formula is valid but the values show as the formula fields themselves. [Number1][Number2] I need for the number fields to display as the true value received in the table and not to be altered in any way. I'd like the Unique Value to display in the table as follows: [@field:Number1] [@field:Number2] [@field:Text] 1000001 101 HelpProject I'm not sure how to display the formula to get the above result. I'm certain that my formula is way off. I reviewed the formula fields help section that's linked to the 9.8 release update information; however it does not demonstrate how to concatenate fields with two different data types (number/ text) using the new method. I also reviewed the forums but the information provided is pre-release where forms were used to create the composite ID's. Thank you for taking a look. Bre
  • Create New...