Articles

Articles of interest to QuickBase folks

Using Key Fields

By default, each table has the built-in field called RecordID (rid), that provides the unique key for that record within the table. If you want to use another field as the key field, you may do so, provided that the field type supports the Unique property, which must be checked to insure that there are no duplicates.

If you use your own field as the key, and not the record ID field, you may be able to replace the &rid parameter in many of the API calls with the &key parameter. The following API calls are known to support this substitution:

 

API_ChangeRecordOwner
 

API_DeleteRecord
 

API_EditRecord
 

API_GetRecordAsHTML
 

API_GetRecordInfo

However, it is likely that other calls support this, so you might want to try this on other calls as well.

Comments

Delete Key Field

Hi,

I need some help please. I was trying to the 'Set Key' on a field, but it didn't work out as i expected. I thought that it will create a unique number by itself everytime I create a new ticket (using IT support Desk Template).

Now I cannot delete the field that I set a key for. is there a way to do that?

 

Thanks

Faisal

Deleting a Key Field

Hi Faisal --

The Record ID# field (which is by default the key field for a table) has a unique number for each record in the table. If you have set another field as the key field, the easiest way to delete that field is to set the Record ID# field as the key field again. Then you should be able to delete the other field.

Hope this helps,

--Sybil

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit