ContributionsMost RecentMost LikesSolutionsRe: Printing New Forms I tried the new form design today after being hesitant to use it after their release. After all the formatting is done i went to create a button for printing the form and I came to know that this feature to print is not yet available in the new form design. I wanted to express my disappointment as this resulted in a significant loss of time on my end. I would like to kindly suggest that future updates be more comprehensive in terms of functionality before being rolled out to users. ------------------------------ Winss ------------------------------ Re: Restful API how to update multiple records? In documentation it says as multiple record(s). But Not able to do after trying with different syntax. ------------------------------ Winss ------------------------------ Re: Quickbase Developer Needed Interested. Please email me the details at winss101201@gmail.com . ------------------------------ Winss ------------------------------ Re: QuickBase inbox!!! How did you build it ? Which pipeline channels did you use ? ------------------------------ Aswin Babu ------------------------------ Re: Quickbase Code page to query a table and display records This worked very well. Thank you so much Simon!. Anyone looking for same solution here is the summary. 1. Create a API gen results link for eg. https://Domain.quickbase.com/db/iddbdbdbid?a=API_GenResultsTable&apptoken=tokn123 t=1&query={'29'.CT.'TYCU700'}OR{'29'.CT.'TYRD60'}OR{'29'.CT.'TYTG8580'}&clist=29.17.7.9.8.38.44.49&slist=17 Let the field name for this link be [test temp inventory query] 2. Create a code page link that has in parameter the value of field [test temp inventory query] (Let the code page that we going to create have page id 150) "https://Domain.quickbase.com/db/bdadad5?a=dbpage&pageID=150&qrytext=" & URLEncode([test temp inventory query]) parameter is value in qrytext This formula URL should have embed as iframe in form options checked. (In field settings) 3. Create code page with page id 150 as <html> <head> <script> let urlParams = new URLSearchParams(window.location.search); let qrytext = urlParams.get('qrytext'); var s = document.createElement("script"); s.type = "text/javascript"; s.src =qrytext ; document.head.appendChild(s); window.addEventListener("load", function(){ qdbWrite(); }); </script> <style> td.m { font-family:verdana; font-size:70%; } td.hd { font-family:verdana; font-size:70%; font-weight:bold; color:white;} </style> </head> <body></body> </head> </html> ------------------------------ Aswin Babu ------------------------------ Re: Quickbase Code page to query a table and display recordsApi Query is now passed as a parameter for code page. Like shown below. ------------------------------------ var text embedurl="https://jewelry.quickbase.com/db/be4uqew75?a=dbpage&pageID=151&qrytext=" & URLEncode([test temp inventory query]); //test using parameter passing $embedurl ------------------------------------- [test temp inventory query] is the API Genresults API link which looks like https://Domain.quickbase.com/db/iddbdbdbid?a=API_GenResultsTable&apptoken=tokn123 t=1&query={'29'.CT.'TYCU700'}OR{'29'.CT.'TYRD60'}OR{'29'.CT.'TYTG8580'}&clist=29.17.7.9.8.38.44.49&slist=17 Code page is updated like as shown below. ------------------------------------------------------------ <html> <head> <script lang="text/javascript"> let urlParams = new URLSearchParams(window.location.search); let qrytext = urlParams.get('qrytext'); </script> <style> td.m { font-family:verdana; font-size:70%; } td.hd { font-family:verdana; font-size:70%; font-weight:bold; color:white;} </style> </head> <body> <table cellpadding=5 bgcolor=lightgreen> <tr> <td> <script lang="text/javascript"> qdbWrite(); </script> </td> </tr> </table> </body> </head> </html> --------------------------------------------------------------------- Still not working ------------------------------ Aswin Babu ------------------------------ Re: Quickbase Code page to query a table and display recordsHello Simon, If i modify the 3rd line to shown below its going to pull out the records and display in code page. What I am confused is passing the value in a formula text to the code page and display that code page at a record level using embedding technique of URL fields. <script src= "https://domain.quickbase.com/db/iddbdbdbid?a=API_GenResultsTable&apptoken=tokn123%20t=1&query={%2729%27.CT.%27TYCU700%27}OR{%2729%27.CT.%27TYRD60%27}OR{%2729%27.CT.%a27TYTG8580%27}&clist=29.17.7.9.8.38.44.49&slist=17" lang="text/javascript"> ------------------------------ Aswin Babu ------------------------------ Quickbase Code page to query a table and display records I have created a code page which should query a table and display certain records using API -GenResults table. I am going to embed this code page in forms. Based on value in each record(in field - test temp inventory query) the contents in the table changes. Below is the code page code <html> <head> <script src= ~test temp inventory query~ lang="text/javascript"> </script> <style> td.m { font-family:verdana; font-size:70%; } td.hd { font-family:verdana; font-size:70%; font-weight:bold; color:white;} </style> </head> <body> <h1>Example</h1> <table cellpadding=5 bgcolor=lightgreen> <tr> <td> <script lang="text/javascript"> qdbWrite(); </script> </td> </tr> </table> </body> </head> </html> The third line, value of src determines the query. ~test temp inventory query~ is the field where query is created as a formula text . The value in formula text looks something like this https://Domain.quickbase.com/db/iddbdbdbid?a=API_GenResultsTable&apptoken=tokn123 t=1&query={'29'.CT.'TYCU700'}OR{'29'.CT.'TYRD60'}OR{'29'.CT.'TYTG8580'}&clist=29.17.7.9.8.38.44.49&slist=17 But the contents are not getting pulled correctly. Which is best way to pass value in field to the QuickBase code page and display the link to code page as embedded in the same form. ? Re: Quickbase function for getting the quotientThanks Don. For anyone having the same problem you can find this also using ( [Numerator] - Rem(Numerator, Denominator) )/ [Numerator] Rem is QuickBase function to return the Reminder of a division operation. ------------------------------ Winss Albo ------------------------------ Quickbase function for getting the quotientWhat is the quickbase function for getting value of quotient in division. Eg. 16//3 should give 5. 18//3 gives 6. 21//2 gives 10 ------------------------------ Winss Albo ------------------------------