Links¶

Add link¶

Add links, link other table records

base.addLink(link_id, table_name, other_table_name, row_id, other_row_id)

link_id: link_id in the data attribute of the link column
table_name: the name of the link table
other_table_name: the name of the linked table
row_id: id of link row
other_row_id: id of the linked row

Example¶

await base.addLink('5WeC', 'real-img-files', 'contact', 'CGtoJB1oQM60RiKT-c5J-g', 'PALm2wPKTCy-jdJNv_UWaQ')

Update link¶

Modify the info of link-type column

base.updateLink(link_id, table_id, other_table_id, row_id, other_rows_ids)

link_id: link_id in the data attribute of the link column
table_id: the id of the link table
other_table_id: the id of the linked table
row_id: id of link row
other_rows_ids: ids of the linked row

Example¶

await base.updateLink(
        link_id='r4IJ',
        table_id='0000',
        other_table_id='kFoO',
        row_id='BXhEm9ucTNu3FjupIk7Xug',
        other_rows_ids=[
          'exkb56fAT66j8R0w6wD9Qg',
          'DjHjwmlRRB6WgU9uPnrWeA'
        ]
    )

Batch update links¶

Batch update infos of link-type columns

base.batchUpdateLinks(link_id, table_id, other_table_id, row_id_list, other_rows_ids_map)

Example¶

link_id = "WaW5"
table_id ="0000"
other_table_id = "jtsf"
row_id_list = ["fRLglslWQYSGmkU7o6KyHw","eSQe9OpPQxih8A9zPXdMVA","FseN8ygVTzq1CHDqI4NjjQ"]
other_rows_ids_map = {
        "FseN8ygVTzq1CHDqI4NjjQ":["OcCE8aX8T7a4dvJr-qNh3g","JckTyhN0TeS8yvH8D3EN7g"],
        "eSQe9OpPQxih8A9zPXdMVA":["cWHbzQiTR8uHHzH_gVSKIg","X56gE7BrRF-i61YlE4oTcw"],
        "fRLglslWQYSGmkU7o6KyHw":["MdfUQiWcTL--uMlrGtqqgw","E7Sh3FboSPmfBlDsrj_Fhg","UcZ7w9wDT-uVq4Ohtwgy9w"]
}

await base.batchUpdateLinks(link_id, table_id, other_table_id, row_id_list, other_rows_ids_map)

Remove link¶

Delete the link row

base.removeLink(link_id, table_name, other_table_name, row_id, other_row_id)

Example¶

await base.removeLink('5WeC', 'real-img-files', 'contact', 'CGtoJB1oQM60RiKT-c5J-g', 'PALm2wPKTCy-jdJNv_UWaQ')

Get link id¶

Get the link id by column name

base.getColumnLinkId(columns, column_name)

Example¶

const columns = await base.listColumns('Table1'); // return table's columns
const linkId = await base.getColumnLinkId(columns, 'Record') // return the link id such as 'aHL2'