-
Posts
15 -
Joined
-
Last visited
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
Heineperson's Achievements
Newbie (1/14)
0
Reputation
-
Heineperson reacted to a post in a topic: Fixing concatenate function in JS code
-
Fixing concatenate function in JS code
Heineperson replied to Heineperson's topic in User JavaScript and CSS Discussions
@BaySunshine - Thank you so much! This worked perfectly!!!- 3 replies
-
- js
- concatenate
-
(and 1 more)
Tagged with:
-
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>
- 3 replies
-
- js
- concatenate
-
(and 1 more)
Tagged with:
-
Heineperson changed their profile photo
-
Thank you @perland for this post!! It's exactly what I needed.
-
Heineperson reacted to a post in a topic: Print Button
-
Heineperson reacted to a post in a topic: Replace document.write with innerHTML
-
Replace document.write with innerHTML
Heineperson replied to Heineperson's topic in User JavaScript and CSS Discussions
THANK YOU @Vitalikssssss! This worked perfectly!!! -
Replace document.write with innerHTML
Heineperson replied to Heineperson's topic in User JavaScript and CSS Discussions
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? -
Heineperson reacted to a post in a topic: Replace document.write with innerHTML
-
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?
- 6 replies
-
- concatenate
- sql
-
(and 2 more)
Tagged with:
-
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
-
Reduce space between HTML blocks and Fields in List Report
Heineperson replied to Heineperson's question in Styles and Localizations
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.
-
Deploy Report that receives parameters on custom Wordpress page
Heineperson replied to Heineperson's question in Deployment
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> -
Deploy Report that receives parameters on custom Wordpress page
Heineperson posted a question in Deployment
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!
- 3 replies
-
- virtual fields
- autocomplete
-
(and 2 more)
Tagged with:
-
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!
- 3 replies
-
- virtual fields
- autocomplete
-
(and 2 more)
Tagged with: