AyoubSalhi
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Exact form embedded report
Hi Keith, I was able to fix this, the solution was to get rid of the single quotes in my function since they get encoded to %27 in the url. and also use the Record ID# instead of the Order #. Thanks for your help. Working query looks like : ~=qdb.GetURL("bgwh72y8f","API_GenResultsTable^query={6.EX."+field["Record ID#"]+"}^clist=7.8.10.11.13.14.15.16.17.18.19.21^options=nvw.ned.phd.nfg");~ ------------------------------ Ayoub Salhi ------------------------------Re: Exact form embedded report
Hi Keith, it didn't work. I took a look at the request being made in the network tab and it looks like it's adding %27 in the url. This is what the form is requesting : https://dlas.quickbase.com/db/bgwh72y8f?act=API_GenResultsTable^query={%276%27.EX.%27231132%27}^clist=7.8.10.11.13.14.15.16.17.18.19.21^options=nvw.ned.phd.nfg This is what it should be requesting : https://dlas.quickbase.com/db/bgwh72y8f?act=API_GenResultsTable^query={%276%27.EX.1132%27}^clist=7.8.10.11.13.14.15.16.17.18.19.21^options=nvw.ned.phd.nfg Order # : 231132 My exact form function : ~=qdb.GetURL("bgwh72y8f","API_GenResultsTable^query={'6'.EX.'"+field["Order #"]+"'}^clist=7.8.10.11.13.14.15.16.17.18.19.21^options=nvw.ned.phd.nfg");~ ------------------------------ Ayoub Salhi ------------------------------Exact form embedded report
I'm trying to query the embedded report in the extract form, but for some reason no data. Looking at the network when the print page loads shows these requests, which the last one might have some URL encoding issues: ~=qdb.GetURL("bgwh72y8f","API_GenResultsTable^query={'6'.EX.'"+field["Order #"]+"'}^clist=7.8.10.11.13.14.15.16.17.18.19.21&options=nvw.ned.phd.nfg");~ How to fix this ? ------------------------------ Ayoub Salhi ------------------------------Add the new Formula for exact form to the Form
Hi, very beginner here, I'm struggling with the instructions for creating exact form , I'm at step 14, I saved a basically empty exact form and I just want to add a print button to a form I have as a proof of concept before adding variables to the exact form. But I can't seem to find what step 14 is talking about. Any help is very appreciated. ------------------------------ Ayoub Salhi ------------------------------qdbEF Error: Type mismatch
I'm trying to create a an exact form that I can use to customize printing my invoice, I follow the instructions in this article https://helpv2.quickbase.com/hc/en-us/articles/4570390477588-Creating-Exact-Forms- Step 11 - I click Sign in and I'm getting this error. Please help...thanks Word 2016 (32 bit) ------------------------------ Ayoub Salhi ------------------------------Re: How can I create a record in a table when I click in a button of another table (with conserving some values)
The Report link worked perfectly for the Requisition items. The problem with the vendor field is that I was copying it in the lookup field of vendor in 'PO' table. So I created a new field that was able to do it. Thanks a lot for the help.Re: How can I create a record in a table when I click in a button of another table (with conserving some values)
Yes I was trying to copy the report 'Requisition items' to 'PO' with this line : & "&_fid_34=" & URLEncode ([Requisition items]) What kind of procedure should I follow to copy 'Requisition items' from ''Requisition' to 'PO' along with the other fields ? I'm trying to copy the 'Vendor' to a data entry text field. Are you saying a relationship between 'Requistion' and 'PO' would solve the problem ?Re: How can I create a record in a table when I click in a button of another table (with conserving some values)
Sorry if I wasn't too clear. I don't have any error in my formula. The problem is that I'm not able to copy data from 'Requisition table' that are from other tables 'Vendor' and 'Requisition item' tables. I want to copy data from 'Requisition' form to 'PO' form with a click of a button 'Make into a PO' The requisition table has relationships with two tables which are : 'Vendor' and 'Requisition Items'. The PO table has relationships with two tables which are : 'Vendor' and 'PO items' Everything works great except : copying the 'requisition items' from 'Requisition' to 'PO' & copying the 'Vendor' data from 'Requisition' to 'PO' . No errors in my formula but these two lines don't seem to copy the data from 'Req' to 'PO': & "&_fid_34=" & URLEncode ([Requisition items]) & "&_fid_53=" & URLEncode ([Vendor]) Is it because they are data from other tables (Foreign keys), they need a certain method ?
