Record duplication from a custom widget

[Emanuele_Gissi]

Hi all,
the following is my current function to duplicate a record:

async function duplicateRecord(action, record) {
  if (!confirm(`Confirm <${action.label}>?`)) { return; }
  const cols = config.duplicateCols;
  const fields = Object.fromEntries(  
    Object.entries(record).filter(([col]) => cols.includes(col))
  );
  try {
    const res = await grist.selectedTable.create({fields: fields,});
    grist.setCursorPos({rowId: res.id});
  } catch (err) { throwErr(`Cannot execute <${action.label}>: ${err}`); }  
}

The config.duplicateCols array contains the columns that are going to be copied to the duplicated record.

When duplicating ref or ref list columns I invariably obtain a #KeyError or an #IndexError. I understand I should specify the id attribute.

A couple of questions:

1. How can I recognize ref and ref list columns and set id programmatically?
2. While at that, how can I filter out formula fields?
3. Is there a way to reuse from the custom widget the Grist record duplication function?

Thank you very much in advance for your help.

PS I am very close to releasing my process flow management custom widget.

[Emanuele_Gissi]

Just to clarify, this question is different from my previous one:

How to obtain the id of referenced records inside a custom widget?

I am developing a custom widget with a button that should duplicate a record. The record contains some reference fields and some reference list fields. The record returned by grist.onRecord(record) {} is something like: { "id": 14, "Name": "Andrea", "City": "Mi", "CalcId": 14, "Books": [ "Pride and prejudice", "Animal farm" ], "Books2": [ "La vita nuova" ], "Ref": "Convivio", "A": 14, "Addresses_City": [ "Milano", "Roma" ] } Note that Books, Books2,…

In that case I started using a formula column to obtain the ids of children records, and duplicate them.

This time I would like to code a generic record duplication function.

[Emanuele_Gissi]

Okay, rising the white flag.
I am again going to use a RECORD(rec) formula field.

There seems to be no simple programmatical way to duplicate a any kind of record.

In my use case, I will go for a specialized function, copying field by field from the RECORD(rec) formula field.

I suggest improving the Grist plugin api. It would be wonderful to have an option to obtain record values that can be directly inserted into a new or updated record.

See:

grist-plugin-api should allow more control over records and tables

Thank you once more for your great work.

[Emanuele_Gissi]

Next, I am goint to use this code to recognize formula columns:

Grist Widget API - Get column names and types?

Officially it is not supported yet. The assumption is that a custom widget should know very little about the table it is used on. The dependency is inverted here, widget should inform Grist what columns it expects and Grist should map those columns back. You can read more about column mappings here Custom - Grist Help Center But if you really need to get this information, you can use general API exposed to widgets and just query for the metdata. Here is an example how the Calendar widget is doi…

[JM_Benedetto1]

Hi!

I had the same requirement, but a little more troublesome: I needed to duplicate an hierarchy spread trough 5 tables.

The solution I found:

• create a toggle field on the main table.
• create a webhook in grist to call n8n flow.
• in n8n, do the duplications by a combination of query and inserts by using the Grist node.
• in n8n, I uncheck the toggle field.

Not the more elegant possible, but I needed something functional and OSS.

best regards