Importing Values to a Numeric Formula Field
Any advise on how to import values from a csv file into a field with a formula or lookup? Any ideas on design change to make this work?
Forum Discussion
The easiest way is to disable app tokens and then just go to the Table home page and edit the URL like this
https://mycompany.quickbase.com/db/bnw7k1234?act=API_SetKeyField&fid=xx
where xx is the field that you want to be the Key.
Then run "enter" to run that API. It should come back with an XML success message which includes the words "no error".
I use this where is need a compound Key field composed of several fields concatenated together.
https://mycompany.quickbase.com/db/bnw7k1234?act=API_SetKeyField&fid=xx
where xx is the field that you want to be the Key.
Then run "enter" to run that API. It should come back with an XML success message which includes the words "no error".
I use this where is need a compound Key field composed of several fields concatenated together.