Heineperson

@BaySunshine - Thank you so much! This worked perfectly!!!

Hello, I have been using the following code in the footer of a details data page. It previously worked to concatenate an autocompleted value from a virtual field with a text area field called "associatedSpecies." This is based on the javascript solution from Caspio below, but I'm not sure if this is no longer supported by more recent browsers? Does anyone have any insight on how I might make this work again? <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var x0 = document.getElementsByName("EditRecordassociatedSpecies")[0].value; var x1 = document.getElementsByName("cbParamVirtual2")[0].value; if (x0 && x1) { document.getElementsByName("EditRecordassociatedSpecies")[0].value = x0+"; "+x1; } else { document.getElementsByName("EditRecordassociatedSpecies")[0].value = x0 + x1; } } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT>

Thank you @perland for this post!! It's exactly what I needed.

THANK YOU @Vitalikssssss! This worked perfectly!!!

Thanks for your help @Vitalikssssss! I'm so sorry for the slow reply-I was moved to another project for a few months, and am now getting back to this. Do you mean I should replace document.write with innerHTML in the code above?

Hello, I'm currently using document.write in a report datapage to create conditional formatting in an HTML block column. (See last column of this link). I am having an error wherein the second page of the report omits the last column. I asked caspio support and they said it is may be because I am using document.write, which is no longer supported in the new upgrade. They suggested using innerHTML, alert(), but I'm not sure how to modify the code. Any advice? Also, Is it possible that document.write is not the problem? <script> if ("[@field:tblRareTaxonTable_ProfileStatus]" == "Active") { document.write("<div style='background:#A0CE4E;border:1px solid #000000;padding:5px 10px;'><span style='font-size:16px;'><strong><a href='https://saveplants.org/national-collection/plant-search/plant-profile/?CPCNum=[@field:tblRareTaxonTable_CPCNumber]' <span style='color:#482441;'>Go To Profile</span></a></strong></span></div>"); } else { document.write("<div style='background:#482441;border:1px solid #000000;padding:5px 10px;'><span style='font-size:16px;'><span style='color:#FFFFFF;'><strong>Profile In Progress</strong></span></span></div>"); } </script> Thanks so much for your help! Katie

Hello, I would like to create a calculated field in tabular report datapage that displays a column in related table as a concatenated string. For Example, many of my apps use the tblPlants as a data source. This is a table of plant species that has a one-to-many relationship with many other tables. I would like to present a field in the report that lists the the botanical gardens for each plant is found in from the tblBG as a string. SELECT STRING_AGG(tblBG.Garden,",") FROM tblBG WHERE tblBG.PlantID = [@field:PlantID]; I get an error that say there is a syntax error near "(", which I take to meant hat the STRING_AGG function does not exist. Is there another function I could use to accomplish this?

Hi, I'm running across the same issue as the @flashcz. However, the below code is not doing the trick. It's been a few years since this question was answered, so I am curious if there is a different solution now?

Hello,I have created a tabbed HTML data page with 5 channels. In one channel, I have a wordpress page with many data pages embedded. I would like to use anchor tags so that when the user submits a form or updates a table - they are redirected to the same part of the page (which is within the tabbed HTML iframe). In the past, I have addressed the problem by adding the following code to the header of data pages embedded in weebly or wordpress pages: <script>window.location.href ="#AnchorTag";</script>However, this method does not seem to work in the case (I suspect because the page is inside of an iframe?). Do you have any suggestions on how I might fix this problem?Thanks,Katie

Hi Mathilda, Thanks for the response!! That worked perfectly.

Hello, I would like to use HTML blocks to organize my fields on a list report embedded in a Wordpress site: http://dev-saveplants.pantheonsite.io/national-collection/plant-search/plant-profile/?CPCNum=3 I would like to reduce the space between the HTML blocks and the data fields (see the words "nomenclature" and "Conservation Status" in top section under "Plant Profile"). I have tried to create a custom Caspio Style with altered the padding and margins, but I am unsure exactly what layout parameters I should be changing, and I also wonder if my wordpress theme might overwrite these changes. Any advice you have for a novice would be greatly appreciated.

Turns out I misunderstood my problem. I could use an iframe. However, I needed to do a few extra steps: 1) Request the query string from the URL and define it as a variable: <?php $strCode = $_REQUEST['CPCNum'];?> 2) Add a query string to the "src" URL in the iframe deployment code and paste the variable defined above ($strCode) as the parameter value <iframe width="500" height = "300" name="AppName" title="AppTitle" src="https://c4axadsf0.caspio.com/?AppKey=MyAppKey&ParameterName=<?php echo $strCode; ?>">Sorry, but your browser does not support frames.</iframe>

Hello! I am trying to deploy a tabular report data page filtered by an external parameter on my wordpress webpage. I have downloaded the caspio plugin for wordpress, and I have had success embedding data pages in code blocks on "normal" wordpress pages built with the GUI web builder. However, the webpage I am modifying in this case is a custom .php file that is edited under Appearance->Editor in an Avada theme (I'm not sure exactly how to explain this). My report appears on this page if I use an iframe, however, this method prevents me from receiving parameters. Does anyone have advice for embedding a data page for wordpress directly into a customized wordpress file? I have tried the following and nothing showed up on the page: <?php do_shortcode('[caspio method="embed" subdomain="true" url="URL" appkey="APPKEY"]'); ?> I also tried the following, which appeared as text on my page [caspio method="embed" subdomain="true" url="URL" appkey="APPKEY"] Thanks in advance for your help!

Thank you so much @Mathilda!!! That worked perfectly!

Hi! This is my first question on this forum, so I apologize if this question is not in the scope of the board I followed this thread to concatenate values from four virtual fields onto an existing field on a details page upon "update". I added the code below to the footer of my details page, and it worked when my virtual fields were text fields. However, this code did no longer worked when I changed my virtual fields to autocomplete fields. Is there another step I need to convert the autocomplete to text? <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var x0 = document.getElementById("EditRecordOtherCollectors").value; var x1 = document.getElementById("cbParamVirtual2").value; var x2 = document.getElementById("cbParamVirtual3").value; var x3 = document.getElementById("cbParamVirtual4").value; var x4 = document.getElementById("cbParamVirtual5").value; document.getElementById("EditRecordOtherCollectors").value = x0+" "+x1+" "+x2+" "+x3+" "+x4; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT> Thanks!