I 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------------------------------
Original Message:
Sent: 12-29-2019 22:10
From: Chris Faye
Subject: 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 actual field name for the source data in the code or can you go from fid to fid?
Ex (that isn't working):
Question: & "&_fid_123=fid_62"
VS
Standard: & "&_fid_123=" & [Name]
Thanks!
------------------------------
Chris
------------------------------