Button To Copy Records into a new Table

[rickin21]

Hi,

I am not sure if this is possible or not, but I have a tabular report set up where all the records are grouped under each Full Name (Field name for this table). The table can be collapsed/expanded, but the grouped field will show a total count of each record. 

I am trying to create a button or something that will create a new record, based on the total count shown. I thought of using triggers for this; however, this seems to only work per record and not when they are grouped. Any suggestions or advise on this would be grateful. I am new to Javascript and CSS so my knowledge is limited on this

[Mathilda]

14 hours ago, rickin21 said:

Hi,

I am not sure if this is possible or not, but I have a tabular report set up where all the records are grouped under each Full Name (Field name for this table). The table can be collapsed/expanded, but the grouped field will show a total count of each record. 

I am trying to create a button or something that will create a new record, based on the total count shown. I thought of using triggers for this; however, this seems to only work per record and not when they are grouped. Any suggestions or advise on this would be grateful. I am new to Javascript and CSS so my knowledge is limited on this

You could get total value using sql query in a calculated field, then you may create a link (find an example here) and pass calculated value parameter in query string

Hope that helps

[rickin21]

Hi Mathilda,

 

Sure that could work, however my datapage is grouping each person's record, I would need the calculated field to show up in this grouped column and not in each individual records. How would I do this?

[Mathilda]

14 hours ago, rickin21 said:

Hi Mathilda,

 

Sure that could work, however my datapage is grouping each person's record, I would need the calculated field to show up in this grouped column and not in each individual records. How would I do this?

Hi, since we cannot create a button or link in grouping, you need to place the link in each record

If you don't want to display value of calculated field, you could hide the calculated field using css, like in this post

[rickin21]

Okay so I have tried this and it does not work:

<style>
#target table:nth-of-type(2) td:nth-of-type(3)  {display: none;}
#target table:nth-of-type(2) th:nth-of-type(3) {display: none;}
#target table:nth-of-type(2) th:nth-of-type(3) {display: none;}
</style>

<div id="target">

My table has a sticky header as well so I added another line 

[MayMusic]

If you are trying to hide column 3 then the code in the header should be 

<style>
#target table:nth-of-type(2) td:nth-of-type(3)  {display: none;}
#target table:nth-of-type(2) th:nth-of-type(3) {display: none;}
</style>

<div id="target">

If that does not work change it to

<style>
#target table:nth-of-type(1) td:nth-of-type(3)  {display: none;}
#target table:nth-of-type(1) th:nth-of-type(3) {display: none;}
</style>

<div id="target">

 

[rickin21]

Got it thank you! The 2nd one worked

6 minutes ago, MayMusic said:

If you are trying to hide column 3 then the code in the header should be 

<style>
#target table:nth-of-type(2) td:nth-of-type(3)  {display: none;}
#target table:nth-of-type(2) th:nth-of-type(3) {display: none;}
</style>

<div id="target">

If that does not work change it to

<style>
#target table:nth-of-type(1) td:nth-of-type(3)  {display: none;}
#target table:nth-of-type(1) th:nth-of-type(3) {display: none;}
</style>

<div id="target">