Display field results in a header

haxx0r · November 8, 2019

Hi, I wanted to display the field results into my header, but as I try display it, it is only showing 1 record, but I need all the record that matches in my search field. So I have this Report DataPage that a search field for Roles. and on the results Page it is displaying a list of Names. What I wanted is that I should display all the Names in the header of the DataPage. but I can't seem to know how to do it.

AllMight · November 8, 2019

Hi haxx0r, This can be achieved within Caspio, it requires custom programming to display all the Names in to the header. You may apply this simple JavaScript code into your DataPage and see if it works on your workflow. First, Add this code inside your header, please do not forget to disable the html editor:

<div id="names"> </div>
<script>
var array = [];
</script>
This script basically creates a <div> where all the Names will be display, and also created an array where all the names will be stored.

Second, add a new HTML Block and use this code:
<script>
array.push("[@field:Name]");
</script>
This script will store the Name values in to the array that you just created.

And lastly, Add this code into your footer:
<script>
var name_from_table= '';
array.forEach(function(name) {
name_from_table += name + "<br/>";
document.getElementById("names").innerHTML = "<p>" + name_from_table + "</p>"
});
</script>

This code will now get all the values from the array that you created, and it will display the values in to the <div> that you've created in the header section.

I hope this works in your workflow.

cheonsa · February 26, 2020

Hi @haxx0r,

Here is what you can do to achieve your desired output:
(1) Add Calculated field and paste this Formula:
STUFF((SELECT ', ' + CAST (Name AS nvarchar) FROM TABLE WHERE Family_ID = target.[@field:Family_ID] FOR XML PATH ('')), 1, 2, '')

Note: Please change "TABLE" to the correct table name and Family_ID to the correct field name.

(2) Display the result of the Calculated Field in the Header. Please refer to the attached screenshot.

1191640

(3) Hide the Calculated Field. On the Header, click on the Source button first or disable HTML Editor in the Advanced Tab:
<style>
#target table:nth-of-type(1) td:nth-of-type(6) {display: none;}
#target table:nth-of-type(1) th:nth-of-type(6) {display: none;}

</style>

<div id="target">

Note: The number in td:nth-of-type(6) shows which column you want to hide. Please refer to this forum post for reference:

Then, paste it in the Footer:
</div>

Hope this helps.

Roosta · March 8, 2020

Hi @AllMight and @LittleMsGinger

I am trying to do something similar to this only with the values from the search fields in a pivot table to be displayed in the header, unfortunately in pivot tables you can't use HTML blocks so are restricted to using the Header/Footer for any code.

I want to do this so when a PDF of the results table is printed using the Caspio download options it gives some context to the results for the user e.g. Name of person searched for, date range searched etc, etc as currently you can only use Authetication Fields, APP and System parameters in the PDF generator headers & Footers and can't display any of the search field criteria such as below;

Datapage view;

PDF Generator result;

Have tried variations of getelementbyID such as;

<html>
<body>

<p id="d1"></p>

<script>
function check() {
  var x = document.getElementById("Value6_1").value;
  document.getElementById("d1").innerHTML = x;  
}
document.getElementById("searchID").onclick=check;
</script>

</body>
</html>

With "Value6_1" being the ID of the Date field "from" in a date search from/to criteria but without success and any help or suggestions that point me in the right direction would be appreciated!

Kind regards,

Roosta

Roosta · March 8, 2020

Hi all,

Not to worry figured it out using pass vaule on exit in search field then inserting that into the header and works for my purposes wothout having to utilise javascript.

Cheers, Roosta

MarkMayhrai · March 30

On 2/26/2020 at 12:37 PM, cheonsa said:

Hi @haxx0r,

Here is what you can do to achieve your desired output:
(1) Add Calculated field and paste this Formula:
STUFF((SELECT ', ' + CAST (Name AS nvarchar) FROM TABLE WHERE Family_ID = target.[@field:Family_ID] FOR XML PATH ('')), 1, 2, '')

Note: Please change "TABLE" to the correct table name and Family_ID to the correct field name.

(2) Display the result of the Calculated Field in the Header. Please refer to the attached screenshot.

(3) Hide the Calculated Field. On the Header, click on the Source button first or disable HTML Editor in the Advanced Tab:
<style>
#target table:nth-of-type(1) td:nth-of-type(6) {display: none;}
#target table:nth-of-type(1) th:nth-of-type(6) {display: none;}

</style>

<div id="target">

Note: The number in td:nth-of-type(6) shows which column you want to hide. Please refer to this forum post for reference:

Then, paste it in the Footer:
</div>

Hope this helps.

Hi Cheonsa,

I'm interested in changing the headers of a tabular page to display a calculated field. I found your post helpful, but unfortunately, the image showing how to display the calculated field result in the header seems to be missing.

Would you be able to offer any advice on how to proceed without the image?

Thanks in advance for your time and assistance!

Sincerely, Mark Mayhrai

Login

Display field results in a header

Question

haxx0r

Link to comment

Share on other sites

5 answers to this question

Recommended Posts

AllMight

Link to comment

Share on other sites

cheonsa

Link to comment

Share on other sites

Roosta

Link to comment

Share on other sites

Roosta

Link to comment

Share on other sites

MarkMayhrai

Link to comment

Share on other sites

Join the conversation

Browse