Forum Discussion
_anomDiebolt_
10 years agoQrew Elite
Yes this is possible with script. I added it to my Reframe With Router Demo on the query named "Flank ball tip pork chop swine tail sausage pork loin porchetta pastrami filet mignon alcatra shoulder beef." That's a mouthful!
Just visit the following page and (1) navigate to the the Clients table, (2) click "REPORTS & CHARTS" and finally (3) click on the query "Flank ball tip pork chop swine tail sausage pork loin porchetta pastrami filet mignon alcatra shoulder beef." aka qid=14:
Reframe With Router
https://haversineconsulting.quickbase.com/db/bj3pggjdg
For demonstration purposes I fade the first column out over three seconds but it could be immediately hidden using $(...).hide() instead of $(...).fadeOut(3000). Here is the relevant code the parent frame uses to detect when the above query is loaded into the <iframe> so the first column can be removed:
if (props.dbid == dbidClients && props.a == "q" && props.qid== "14") {
$("#myIframe").contents().find("#VR_bj3pggjd6_14 thead tr td:first").fadeOut(3000); $("#myIframe").contents().find("#VR_bj3pggjd6_14 tbody tr td.icr").fadeOut(3000);
}
See attached screenshot after fadeOut completes.
If you find this answer confusing you might want to read this post first:
What is the Reframing Technique?
https://quickbase-community.intuit.com/questions/1184283
If you are still confused ask a question.

Just visit the following page and (1) navigate to the the Clients table, (2) click "REPORTS & CHARTS" and finally (3) click on the query "Flank ball tip pork chop swine tail sausage pork loin porchetta pastrami filet mignon alcatra shoulder beef." aka qid=14:
Reframe With Router
https://haversineconsulting.quickbase.com/db/bj3pggjdg
For demonstration purposes I fade the first column out over three seconds but it could be immediately hidden using $(...).hide() instead of $(...).fadeOut(3000). Here is the relevant code the parent frame uses to detect when the above query is loaded into the <iframe> so the first column can be removed:
if (props.dbid == dbidClients && props.a == "q" && props.qid== "14") {
$("#myIframe").contents().find("#VR_bj3pggjd6_14 thead tr td:first").fadeOut(3000); $("#myIframe").contents().find("#VR_bj3pggjd6_14 tbody tr td.icr").fadeOut(3000);
}
See attached screenshot after fadeOut completes.
If you find this answer confusing you might want to read this post first:
What is the Reframing Technique?
https://quickbase-community.intuit.com/questions/1184283
If you are still confused ask a question.
