Type alias QuickBaseRequestUpdateRelationship

QuickBaseRequestUpdateRelationship: QuickBaseRequest & {
    childTableId: string;
    lookupFieldIds?: number[];
    relationshipId: number;
    summaryFields?: {
        accumulationType: "AVG" | "SUM" | "MAX" | "MIN" | "STD-DEV" | "COUNT" | "COMBINED-TEXT" | "DISTINCT-COUNT";
        label?: string;
        summaryFid?: number;
        where?: string;
    }[];
}

Type declaration

  • childTableId: string

    The unique identifier (dbid) of the table. This will be the child table.

  • Optional lookupFieldIds?: number[]

    An array of field ids on the parent table that will become lookup fields on the child table.

  • relationshipId: number

    The relationship id. This is the field id of the reference field on the child table.

  • Optional summaryFields?: {
        accumulationType: "AVG" | "SUM" | "MAX" | "MIN" | "STD-DEV" | "COUNT" | "COMBINED-TEXT" | "DISTINCT-COUNT";
        label?: string;
        summaryFid?: number;
        where?: string;
    }[]

    An array of objects, each representing a configuration of one field from the child table, that will become summary fields on the parent table. When you specify the 'COUNT' accumulation type, you have to specify 0 as the summaryFid (or not set it in the request). 'DISTINCT-COUNT' requires that summaryFid be set to an actual fid.

Settings

Member Visibility

Theme