Auto fill a field based on 2 other fields
I have 4 tables: "Loads Hauled", "Commercial Facilities", "On Farm Bins", and "Distance". The "Commercial Facilities" table is a list of facilities where loads can be hauled to. The "On Farm Bins" ...
Forum Discussion
Ok, so to change the Key field to be a formula field
1. Turn off Application tokens (at least temporarily). That checkbox is on Application Properties.
2. The API call is here https://help.quickbase.com/api-guide/index.html#setfieldproperties.html
so you would basically type https://mycompany.quickbase.com/db/xxxxx?a=API_SetFieldProperties&fid=7
where the xxxxx is your table ID and the 7 if the field to be set as the key field. The easiest way is to just go to that table and edit the URL.
1. Turn off Application tokens (at least temporarily). That checkbox is on Application Properties.
2. The API call is here https://help.quickbase.com/api-guide/index.html#setfieldproperties.html
so you would basically type https://mycompany.quickbase.com/db/xxxxx?a=API_SetFieldProperties&fid=7
where the xxxxx is your table ID and the 7 if the field to be set as the key field. The easiest way is to just go to that table and edit the URL.