Forum Discussion
ChrisSwirtz2
Qrew 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_BaseJunki
5 years agoQrew Captain
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...
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
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
------------------------------