Exact forms
Hi, I'm needing some help with exact forms. I'm using the "Exact forms word template" from the QB help site and telling it to show a report link from field ~152~. However, its only showing default col...
Forum Discussion
1. Do I add this code in my Word document in place of where I had ~152~?
2. For the "childtable id", do I just go into a record in the child table and copy the entire web address, or just part of it?
3. For the "childReport id", is that just he number at the end of the web address?
4. For the "childField id", is this the field named "related field" in the child table or is it ~152~?
5. For the "parentField name" is this just the field name of the ~152~?
2. For the "childtable id", do I just go into a record in the child table and copy the entire web address, or just part of it?
3. For the "childReport id", is that just he number at the end of the web address?
4. For the "childField id", is this the field named "related field" in the child table or is it ~152~?
5. For the "parentField name" is this just the field name of the ~152~?
- Yes, 100% replacement of ~152~
- It will be the part in bold: example.quickbase.com/db/childtableID?a=somemorehttpcode
- just the part after 'db/' and before the '?', if there is one.
- More on this later, but basically ignore this step -I misspoke and need to correct it-
- It is the field named 'Related field', but you're only putting the ID in that spot without the '~~'
- The actual spelled out version of the field that the "childField id" is pointing at/referencing in the parent table.
In addition to all that stuff, I have an update: referencing the 'qid="childreport ID" will override any additional filters/customization referenced in the 'query=' portion. I wanted to use this as it would have drastically reduced the complexity of the second portion, but we really do have to go 'full-fat' query to display exactly the filters you want.
Fortunately, the code that we need to write for this full query is available if you know how to find it:
- If you have the 'related child records' table report displayed on the parent record's form, click on the "Full Report" at the top-left of that report.
- This should have navigated you to a page that is just that report, filtered for that parent record.
- Click on 'more' at the top right of the page, and click on 'Show the expanded URL for this Report' (should be last option in the drop-down)
- You'll get a message that gives you a whole bunch of code that'll look like this:
- ?a=q&qt=tab&dvqid=-1000118&query={'7'.TV.'28'}AND({'59'.XEX.'1'})&clist=10.58.72.11.48.6.57.45.49.73.43.64.46&slist=41.40.74.27&opts=so-AAAA.gb-VV.nos.qws.
- Copy and paste that code into here and I'll help you re-format it for the exact form query.
------------------------------
Brad Lemke
------------------------------
?a=q&qt=tab&dvqid=-1000060&query={'7'.TV.'260'}AND({'45'.EX.'1'})&clist=20.18.14.48.16.39.45&slist=45.39&opts=so-AA.nos.qws.&showDesc=1
------------------------------
Megan Hardison
------------------------------
------------------------------
Megan Hardison
------------------------------
- First, the cleaned up version of that code to copy/paste into the exact form:
~=qdb.GetURL("childtable id","API_GenResultsTable^query={'7'.EX.'"+field["parentfield name"]+"'}AND({'45'.EX.'1'})^clist=20.18.14.48.16.39.45^slist=45.39^options=so-AA.nos.qws.ned.nvw.nfg.phd");~
- 'parentfield name' is exactly as we discussed before.
- ned.nvw.nfg.phd is purely aesthetic/optional. I assume that you're setting this up to print out, and adding these options will remove the 'pencils/eyeballs' as well as any new/updated flags. Feel free to add/remove to suit your needs, or just to experiment to see what I'm talking about.
- I also removed the 'showDesc=1' because I'm assuming that's the entry to display the description of the report. I'm not sure how that'll show up on a GenresultsTable call, but you can add it back in using: ^showDesc=1
- If nothing else, I'm curious to see if it comes up at all when referenced. I may play around with it.
------------------------------
Brad Lemke
------------------------------- It didn't give me an error this time, and it showed a report, but its still not showing all the records (not using the filters I added for that report).
------------------------------
Megan Hardison
------------------------------- So, the report that you pulled the code from earlier - did that have all of the filters you're talking about?
What are fields 7 and 45 in that table?
------------------------------
Brad Lemke
------------------------------