Hello!
POST /api/docs/{docId}/tables
# with payload :
{"columns": [{ "id": "bdc", "fields": { "type": `Ref:BDC`, "label": "Bon de commande", "visibleCol": 28} } }
ignores visibleCol which is still 0. When looking at server logs we see that indeed _doApplyUserActions AddTable does not contain visibleCol But it displays BDC[1] and if we change the display column to name with the UI it works as it is recommended: Reference columns - Grist Help Center
PATCH /api/docs/{docId}/tables/${tableId}/columns
# with payload :
{"columns": [{ "id": "bdc", "fields": { "type": `Ref:BDC`, "label": "Bon de Commande", "visibleCol": 28} } }
ignores visibleCol which is still 0. When looking at server logs we see that indeed ModifyColumn does not contain visibleCol
BUT :
POST /api/docs/{docId}/tables/${tableId}/columns
# with payload :
{"columns": [{ "id": "bdc", "fields": { "type": `Ref:BDC`, "label": "Bon de Commande", "visibleCol": 28} } }
works but it displays rowId and not the name (colRef: 28) when I add a record:
POST /api/docs/{docId}/tables/${tableId}/records
# with payload
{"records": [{"fields": {"bdc": 1}}]}
How can I create (with API) a table with a reference column that does not display the id that is added in record but the name (colRef=28) of that record ?
Maybe it is not featured: Reference columns - Grist Help Center