Forum Discussion

ChrisSwirtz2's avatar
ChrisSwirtz2
Qrew Cadet
6 years ago

Utilizing a different form when clicking the "Add Record" button

I'm looking to have a user utilize a different form to add a record to a table depending on which table they are adding the record from. I assume this can be done via some sort of URL Report field ...
Button
Formulas and functions
ChrisSwirtz2's avatar
ChrisSwirtz2
Qrew Cadet
6 years ago
Oh, that might be the problem, I am using a URL Formula type field, not a Rich Text Formula field. The formula I pasted above is exactly what I have in there now.

------------------------------
Chris Swirtz
------------------------------
DonLarson's avatar
DonLarson
Qrew Elite
6 years ago

Chris,

That is it.  Change the field type.


// Images
var text IMGLock  =     "<img src=https://images.quickbase.com/si/48/045-lock.png>"; 

// URL
var text URLGenAdd=
URLRoot() & "db/" & [_DBID_PERIPHERALS] &
"?a=API_GenAddRecordForm&_fid_15=" & URLEncode ([Record ID#]) &
"&dfid=11" & "&z=" & Rurl();

// UI
 "<a href=" & $URLGenAdd & "' title=\"Click Me\">"  & $IMGLock &  "</a>"


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    Chris,

    By the way, change the image at the top to something that makes sense for your user base.  I use that lock as default for status changes to records.   It is probably nonsensical for your business case.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
  • ChrisSwirtz2's avatar
    ChrisSwirtz2
    Qrew Cadet
    6 years ago
    Well Don, that worked, thank you. Couple things though...

    1. Is there way to show a button instead of that lock picture?
    2. this type of field does not have the option to open in a new window like others do (unless you right click and select that from the menu, which they won't want to do). This is something my boss is definitely going to ask for.

    ------------------------------
    Chris Swirtz
    ------------------------------
    • QuickBaseJunkie's avatar
      QuickBaseJunkie
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      Hi Chris,

      I came across this thread in the Quick Base Newsletter and thought I'd chime in.

      You can still use the Formula URL field as you desired (shown as a button and open in a new window). Just drop the variable portion of the formula you're using such as this...
      URLRoot() & "db/" & [_DBID_PERIPHERALS] &
"?a=API_GenAddRecordForm&_fid_15" &
URLEncode ([Record ID#])&"&dfid=11" & "&z=" & Rurl()ā€‹


      There are also ways to format the rich text formula to open in a new window and show as a button, but it's likely not worth the extra coding if you just simplify the formula and use the Formula URL button.

      Let me know if this helps šŸ˜ŠšŸ‘



      ------------------------------
      Sharon Faust (QuickBaseJunkie.com)
      Founder, Quick Base Junkie
      https://quickbasejunkie.com
      ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Elite
      6 years ago
      Chris,

      Images hosted by Quick Base
      https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=160  

      Custom Built but you have to put on a web server
      https://dabuttonfactory.com/


      To open in a new tab you need to insert the HTML code for it.
      "<a href=" & $URLGenAdd & "' target=\"_blank\">"  & $IMGLock &  "</a>"

      This is all HTML.  The concept is simple but the syntax and quote marks get tricky.

      Spend some time on W3 and you will be able to do amazing stuff
      https://www.w3schools.com


      ------------------------------
      Don Larson
      Paasporter
      Westlake OH
      ------------------------------