Quickbase is returning the following error message "The argument list of the function API must begin with a left parenthesis." But I don't see where the left parenthesis needs to be. Also not sure about the quotes around "&_fld_6=", are they in the right place?
Are your FIDs 6,8 and 11 numeric reference fields or text reference fields?
They are numeric reference fields. Further by removing the URLRoot()... as suggested below I get nothing. Thanks!
Don't convert your reference fields to text - leave them as they are... and you will need the URLRoot().. it doesn't work without it.
Dan - unfortunately without "URLRoot() & "db/" &", these formula's do not work.
All this does is create an absolute URL when your browser will automatically resolve the relative URL generated without the front part..
I don't believe this is true. Clear the other errors first and the formula will work without. Web sites are generally constructed using relative URLs for hyperlinks within the same domain. This is true for QuicKBase as well although a tradition has grow up in the QuickBase user community to construct absolute URLs. Always use relative URLs for links within QuicKBase.
Dan - have you tried your method with a working formula like this?
Using relative URLs for internal links in a web site is a rock solid practice and it applies to QuickBase as well. You only need absolute URLs if you are linking to an external URL or to a QuickBase link on another subdomain. For some odd reason the practice of writing absolute URLs for QuickBase has spread when it is quite unnecessary. If you have an example to the contrary send me the info.
You are using "_fld_6" with an "l" instead of "_fid_6" with an "i". QuickBase is simply ignoring the parameters it does not understand so no fields are populated and no error is generated.
Rookie mistake (or I need better glasses!) Thanks, that did it and working great!
and post the results of your test.
Using the URL Root()... did not work. If you would like me to test something else, let me know.
Robert - is your formula working?
Sorry for the confusion... yes my formula is working WITH the URLRoot()... it does not work without it.