Formula URL - Add Record fid's
Hi All, Quick question as this would really speed up some work - When creating a formula URL (button) to add a new record in another table and copy the following fields, do you need to use the ac...
Forum Discussion
QuickBaseJunkie
Qrew Legend
Qrew LegendI don't think there is a simple (or native) way to do what you're looking for.
I have two recommendations to speed up your work.
The first option would be to create a set of variables that reference all the fields you might be using in a particular table then paste use those variables in the beginning of every formula.
Example:
var text FIELDONE = [Field 1];
var text FIELDTWO = [Field 2];
...
var text FIELDFOURTWO = [Field 42];
Then you could do something like this in your formulas:
& "&_fid_42=" & $FIELDFOURTWO
Of course, without the use of numbers in variables it could get a little messy.
A second option would be to add the field number to the field's name such as [Status 62].
Then when writing the formula you could quickly add it with the CTRL+Shift+Space shortcut to access all of the fields & functions then type the field ID to quickly search and choose from the menu that pops up.
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
I have two recommendations to speed up your work.
The first option would be to create a set of variables that reference all the fields you might be using in a particular table then paste use those variables in the beginning of every formula.
Example:
var text FIELDONE = [Field 1];
var text FIELDTWO = [Field 2];
...
var text FIELDFOURTWO = [Field 42];
Then you could do something like this in your formulas:
& "&_fid_42=" & $FIELDFOURTWO
Of course, without the use of numbers in variables it could get a little messy.
A second option would be to add the field number to the field's name such as [Status 62].
Then when writing the formula you could quickly add it with the CTRL+Shift+Space shortcut to access all of the fields & functions then type the field ID to quickly search and choose from the menu that pops up.
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
What browser do you use? On Chrome 79 and ctrl+shift+space does nothing for me. I tried in many different formula fields including a formula url. I am going to guess you use a different browser as your blank lines in the formula are all numbered and at least for me in Chrome only the lines I've filled out are numbered.
Are there any steps other than the ones you mentioned? Just hit that key combination while the text cursor is in the box and something should popup?
Are there any steps other than the ones you mentioned? Just hit that key combination while the text cursor is in the box and something should popup?
- MarkShnier__YouMs. Junkie's tip worked for me on Chrome on a Mac. It was a great tip.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - QuickBaseJunkieHi Austin,
I'm also using Chrome 79 on a Mac (but have been told this works on a PC as well). If you're using a Mac it is the Control key and not the Command key, if that makes a difference. The reason you see the additional numbered lines is because I moved some of my formula down for the screenshot as it showed my app token.
I've found the menu appears when you press Ctrl+Shift+Space
- on a blank link
- after a space in a formula
- after a letter that corresponds to a function or field, where there is a space before it or it's the only item on the line
If you press the combination in the middle of a text string or directly after any item you may just see a "No matches found".
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------- I tried everything you mentioned before I had posted so I am out of ideas then. It is a PC, no idea what is causing it to not work for me. It isn't a big loss though as I didn't know about it before. Can't really lose something you didn't have lol. Thanks anyway though I appreciate the response.
