Jump to content

Button To Copy Records into a new Table


Recommended Posts

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

Link to post
Share on other sites
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

Link to post
Share on other sites
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

Link to post
Share on other sites

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 

Link to post
Share on other sites

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">

 

Link to post
Share on other sites

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">

 

 

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...