Jump to content


  • Content count

  • Joined

  • Last visited

  1. 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?
  2. Refreshing IFrames

    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?
  3. 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
  4. Hi Mathilda, Thanks for the response!! That worked perfectly.
  5. 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.
  6. Deploy Report that receives parameters on custom Wordpress page

    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>
  7. 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!
  8. 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!