Formula URL - Add Record fid's

Chris,

An interesting idea. 

I tested it inside of the same table with an API_EditRecord and it would not write the value from one FID to another FID using  just the field ID.

Perhaps someone else knows a syntax where it will work without using the field name.

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

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
------------------------------

There is no native way to do this within QB that I could find.  Sharon's CTRL+Shift+Space tip is the best option on time savings when writing the formulas. Another option is to use Automations as well, it takes away most of the typing in formula writing in creating new records. I have replaced almost all of my buttons to create new records with automations.

------------------------------
jason johnson
------------------------------