Ba2sai

Hi, Have you added a List datatype field in your table?

Hi Jon, Yes it is possible to write a custom style for your Caspio DataPages. To view all the styles in your Caspio Style, you can first create a duplicate of your default style and click edit. Inside your duplicate style, click the "Source" tab then select "All" under DataPage Elements. You will see the CSS style codes for all classes in your Caspio DataPage. You can modify the style codes and apply them to your DataPages. https://howto.caspio.com/styles/customizing-styles/

Hi Marta, Do you have custom scripts that perform your search? It might be best to have Caspio Support check your DataPage if you don't have custom scripts in your DataPage. Have you created a support ticket for this issue?

Try adding a Timestamp field based on record update in your DataSource table and in your Report DataPage, sort the report (descending) based on this field. https://howto.caspio.com/datapages/reports/interactive-reporting-options/

Hi David, You can try creating a formula field that combines the value of @field1 and @field2 then use this field as search filter for your cascading element. In your DataPage, add a virtual field with a value coming from the concatenate javascript suggested in the forums link below.

I got this same problem. How did you fix yours Wendell?

Just want to share this solution to redirect the Submission DataPage after showing the Display Message. Insert this code as source text in the Display Message html. You can change the delay by increasing or decreasing the number. <script> setTimeout(function () { window.location.href = "https://www.google.com"; }, 2000); </script> Cheers!

Try this:

Hey, I was searching for a solution to pass browser parameter into another html page inside an iframe and I stumbled on a neat code and tweaked it. It worked for me so I'm sharing this here. http://help.pardot.com/customer/portal/articles/2126647-passing-url-parameters-from-browser-to-iframe <noscript> <iframe src="ParamCatch.html" width="100%" height="500" type="text/html" frameborder="0" style="border: 0"> </iframe> </noscript> <script type="text/javascript"> var form = 'ParamCatch.html'; var params = window.location.search; var thisScript = document.scripts[document.scripts.length - 1]; var iframe = document.createElement('iframe'); iframe.setAttribute('src', form + params); iframe.setAttribute('width', '100%'); iframe.setAttribute('height', 500); iframe.setAttribute('type', 'text/html'); iframe.setAttribute('frameborder', 0); iframe.setAttribute('allowTransparency', 'true'); iframe.style.border = '0'; thisScript.parentElement.replaceChild(iframe, thisScript); </script> My Test: - Two HTML pages, Main.html and ParamCatch.html ParamCatch.html contains the embedded DataPage set to receive parameter as filter for Tabular Report Main.html > contains the script above > tested using Main.html?paramname=paramvalue > ParamCatch.html got the parameters and displayed the correct data Cheers!

Sharing this in case you need to show the text instead of ID value in report datapage. Steps: 1) Make sure you have a table that has your lookup values 2) Add a Calculated Field in your Tabular Report DataPage and insert the code below SELECT LookUpTableDisplayText FROM LookUpTable where LookUpTableIDvalue='[@field:IDFieldInDataPage]' 3) If you want to hide the ID column, you can use the steps below.

Sharing my solution for adding an image to your Submission Form email notification. For this to work, you need 2 deployed DataPages, 1 Submission Form and 1 Report DataPage both using the same table containing the image path as DataSource. Copy the code below inside the message body of your email notification and don't forget to click "Source" before inserting the code. <img src="[@cbBridgeServer!]/dpImages.aspx?appkey=InsertYourDeployedReportDatapageAppkeyHere&amp;file=[@field:YourImageFieldName]" /> http://howto.caspio.com/files-and-images/referencing-your-files/ Cheers!

Hi ohsusan429, I don't think it's possible to add your 4th criteria in this same report because it sounds more like you're looking to implement an "IF > Else" conditional statement as oppose to just telling the Filter which records to include or to disregard. If I understand you correctly, you want the criteria to give you this logic >> ("IF CruiseLine.Criteria4 Contains Viking THEN SailDate.NextXDays.=60, ELSE SailDate.NextXDays=14"). I don't believe the Report Filter logic will allow you to do this. What is possible though is to have a submission form with virtual fields then insert a footer javascript that will monitor the value of the criteria fields and will redirect the user to the correct report DataPage based on the chosen criteria. So if they selected Viking, the submission form will direct the user to your Report DataPage where SailDate.NextDays=60 and CruiseLine.Criteria.Contains.Vikings. Hope this helps.

Try the code in the attached test page I use for testing. Test.html

Hi Jeffs88keys, Do you have a sample webpage we can inspect? Are the DataPages deployed using the Embed deploy method?

You can use this to put a check on a virtual checkbox on window.load: <script> window.onload = function(){ document.getElementById('cbParamVirtual1').checked=true; } </script>

Hi JoennAquilinio, Here's how I created my running balance form and report. One Submit Form with pass parameter based on JS calculation to update Single Record Update Form2. Update Form https://c3cmr752.caspio.com/dp.asp?AppKey=1870500049f88ce789144b34b4c1 Report View https://c3cmr752.caspio.com/dp.asp?AppKey=1870500050225f0ac5394288a3f1

Do you have a sample Datapage for this Pulford?

Hi hrdickinson, You need to check the exact id name assigned to the Client_ID field. In the Search form of a Report Datapage, a field can be assigned with id like "Value3_1". Do you have a sample Datapage? Try this: <script> function setSearch(){ if("[@authfield:Level#]" == 3){ document.getElementById('ValueX_X').value=document.getElementById('cbParamVirtual1').value; } else { document.getElementById('ValueX_X').value=document.getElementById('cbParamVirtual2').value; } } document.getElementById("searchID").onmouseover = setSearch; </script>

Hi Blarney, Try this: If your fieldname is "lineitemsku" and you want to focus on this Inline Insert field, try the code below. <script> { document.getElementsByName('InlineAddlineItemsku')[0].focus(); } </script>

Hi EDG28, Try this: Get two virtual fields in your submit form then add the script in your footer. <SCRIPT LANGUAGE="JavaScript"> function dateLastYear(){ var currentDate= new Date(); var MonthNow = currentDate.getMonth(); var DayNow = currentDate.getDate(); var YearNow = currentDate.getFullYear(); var currentYear = currentDate.getFullYear(); var previousYear = currentYear - 1; document.getElementById('cbParamVirtual1').value = (MonthNow+1) + "/" + DayNow + "/" + YearNow; document.getElementById('cbParamVirtual2').value = (MonthNow+1) + "/" + DayNow + "/" + previousYear; } document.getElementById("Submit").onmouseover=dateLastYear; </SCRIPT>

Hi VLE33, Just wondering why you would use a Submission Form for search? Are you trying to implement something like this? > http://howto.caspio.com/tech-tips-and-articles/tech-parameters/add-a-search-interface-to-results-sets-page/. If you are, you can use two virtual fields from your Submit Form as start and end value that you can pass as parameter for your Report DataPage. You can enable New criteria to add Criteria 1 and Criteria 2 for your Search Field Filter. Make sure you assign the matching parameter names for your Submit and Report DataPage.

See if this helps.. <script> function HideButton(){ if (document.getElementById("cbParamVirtual10").checked) { document.getElementById("Submit").style.display = 'initial'; } else if (document.getElementById("cbParamVirtual11").checked) { document.getElementById("Submit").style.display = 'none'; } else if (document.getElementById("cbParamVirtual12").checked) { document.getElementById("Submit").style.display = 'none'; } else if (document.getElementById("cbParamVirtual13").checked) { document.getElementById("Submit").style.display = 'initial'; } else { document.getElementById("Submit").style.display = "visible"; } } document.getElementById('caspioform').onmousemove = HideButton; </script> ** cbParamVirtual10 to cbParamVirtual13 represents the id's of each radio button for Virtual1. Run inspect to see the exact ID assigned to your radio buttons.

Hi Caspians, Does anyone know of a javascript I can use in my Submission Form text field, so I can force the content to be submitted as lowercase in my database table?