API_EditRecord

rid or key

The record ID of the record to be edited. You can obtain the recordID of any record in a query. (See API_DoQuery).

If you use a key field OTHER than the record id (rid), you should use the key parameter rather than rid.

yes

update_id

Specifies the latest record state.

Note that, if another user makes changes before you issue this call,  the update ID in Quickbase will change, which will render invalid the update ID that you have. In this case, you should get the latest version of the record and its new update ID, and then make your changes.

You can obtain the update ID for a record using the API_GetRecordInfo for the record you are editing.

no

field

Specify values for the fields that make up the record you want to add using either the fid attribute or name attribute of the <field> element.

For example:

<field fid=”18”>Hi!</field>
<field name=”Message”>Hi!</field>

You must specify all required fields.

The values you enter here will vary, depending on field type. See How to specify values for different field types for more information.

yes

disprec

Set this parameter to 1 to specify that the new record should be displayed within the Quickbase application. An application login is required before the record can be displayed. If you use this parameter, Quickbase returns the normal Quickbase HTML page that displays the record.

Omit this property if you don't want the new record to display within the Quickbase application.

no

fform

Set this parameter to 1 if you are invoking API_EditRecord from within an HTML form that has checkboxes and want those checkboxes to set Quickbase checkbox fields.

Omit this property if you don't need Quickbase to set Checkbox fields based on your HTML page.

no

ignoreError

Set this parameter to 1 to specify that no error should be returned when a built-in field (for example, Record ID#) is written-to in an API_EditRecord call.

If you do not set this parameter, Quickbase returns an error when API_EditRecord writes to a built-in field.

ticket

Specifies valid authentication ticket. You obtain a valid ticket from API_Authenticate. A ticket is also returned in the various API responses. See API Overview for more information on the authentication ticket.

yes, one of:

• ticket
• username/password
• user token

usertoken

The user token is an alternative means of authentication, used for API access. User tokens cannot be used to access the Quickbase UI.

yes, one of:

• ticket
• username/password
• user token

apptoken

Specifies a valid application token. See API Overview for more information on application tokens.

yes, if the application requires application tokens

udata

A string value that you want returned. It will not be handled by Quickbase but it will be returned in the response.

no

msInUTC

Allows you to specify that Quickbase should interpret all date/time stamps passed in as milliseconds using Coordinated Universal Time (UTC) rather than using the local application time.

Set this parameter to 1 if you want to use Coordinated Universal Time. See usage example.

no

clist

A period-delimited list of field IDs to be returned. Quickbase will return values for these field IDs in the order in which you enter them here.

To return all fields in a table, set this parameter to the value a.

Allows you to return the state of dynamic fields like formulas, lookups or summaries without combining with API_DoQuery.

no