Forum Discussion
DonLarson
Qrew Commander
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
// 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
------------------------------
ChrisSwirtz2
5 years agoQrew Cadet
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
------------------------------
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
------------------------------
- Quick_BaseJunki5 years agoQrew CaptainHi 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
------------------------------ - DonLarson5 years agoQrew CommanderChris,
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
------------------------------