Form Data to HTML Page

Joshua,

As Don mentioned, this sort of thing can get complicated fast. I've listed some options below that answer your specific question, but you may want to consider Option 3. It would allow you to stay in the native QuickBase features without having to build a code page.

1. Create a Formula URL button to link to the code page

• The URL Link would be something like "https://YOURREALM.quickbase.com/db/APPID?a=dbpage&PageID=YOURCODEPAGEID#[Record ID#]".
  • Underlined items are things you would update based on your app
  • The key item here is that you put a payload after a "#" in the URL for the page to use. This payload is what you'd feed to API_DoQuery
  • You could place this button on the ticket record
• On the code page, use the browser's window functions to extract everything after the # (in this case [Record ID#])
• Use the extracted [Record ID#] in API_DoQuery to get the remaining info you need

2. Create a template HTML Page populated with API_GenResultsTable

• Write a custom HTML page in the format of your invoice.
• Use API_GenResultsTable to inject a table with the necessary information into this HTML page template

3. Use API_GenAddRecordForm

• API_GenAddRecordForm allows you to click a button that goes to a new record form pre-populated with data from an existing record
• You could click the button from the ticket record, generate an invoice record, and print the new invoice record's form

4. QB Solutions Provider
Many QuickBase Solutions Providers offer template engines for purchase.

------------------------------
Evan Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------