Skip to main content
Question

HTML or JavaScript?

  • October 28, 2019
  • 0 replies
  • 32 views
So I am new to this whole HTML/javascript world. 

I have a button on my RFQ table "Respond to RFQ". 

This button is a formula rich text:
"<a href=\"https://louisberger.quickbase.com/db/bpa6iqgxh?a=dbpage&pageID=13\"><img src=\"https://dabuttonfactory.com/button.png?t=Respond+To+RFQ&f=Bellota-Bold&ts=24&tc=fff&tshs=1&tshc=000&hp=20&vp=8&c=round&bgt=unicolored&bgc=7e7f34\"></a>"

This button works perfectly fine.  My question is - Is there a way to include fields in this button formula that can autofill in some of my data fields on my HTML form??

For Example:
FID 121 (Unique RFQ Code) would go into the RFQ Code box on my HTML page.
FID 130 (Related Vendor) would go into the Company Name field on my HTML page.

------------------------------
Amber Polston
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Quickbase Alumni
  • October 29, 2019
Amber,

It looks like your button is taking the user to a page and not editing or creating a record that is the response to the Request for Quote.  Depending on the architecture of the application it could look like this.  I am assuming this table structure

RFQ << REQResponse

// Images

// URL HTTP GenAdd

var text RFQURL =
  URLRoot() & "db/" & [_RFQResponse] &
  "?a=API_GenAddRecordForm&_fid_8=" & URLEncode ([Record ID#])&
  "&_fid_121"= & URLEncode([Unique Code])&
  "&_fid_130"= & URLEncode([Related Vendor])&
  "&z=" & Rurl(); 
 
// Respond to RFQ

 "<a href=" & $RFQURL & "' title=\"Respond\">"  & $$ButtonIMG &  "</a>"


This would add a child record to the RFQ and pre fill fields  121 and 130.  It assumes that the Related Vendor and the Unique Code are fields in the record where the button is pushed.  It also assumes the FID 8 will set the relationship between the RFQ and the response.

Don

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
  • BabiPanjikar
  • Quickbase Alumni
  • October 29, 2019
It looks Don's response should get you what you need.

------------------------------
Babi Panjikar
------------------------------
Terms & ConditionsAccessibility statement