Skip to main content

How to Delete a Row from an Interface Table via a Script Button

  • January 11, 2023
  • 3 replies
  • 124 views
L
Forum|alt.badge.img+5

Hi all, 

I am trying to allow a user to click a button on a row within an interface to quickly delete that record. I have successfully created a script using online help to delete a row from the base view. 

 
let tableId = cursor.activeTableId;
let table = base.getTable(tableId);
let record = await input.recordAsync('Select a record to use', table);
if (record) {
   await table.deleteRecordAsync(record);
} else {
    console.log('No record was selected');
}
 
This has worked perfectly in the base view, I tested it and the buttons show active. 

 

However, I cannot get it to work in the interface view (buttons show grayed out).

 

Does anyone know how I can get it to work on the interface view? 

3 replies

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • January 11, 2023

Button fields that run scripts do not work in interfaces. You need to rework the script so that it can run as an automation. Then you can use a button element in the interface to trigger the automation. Note that it will take slightly longer for the automation to delete the record versus the button field.

There will have to be several changes to the script to make it run as an automation. For example, you will not be able to use cursor.activeTableId or input.recordAsync

If you don't want to figure out the automation script yourself, my Automation Helper Scripts on my Gumroad store includes an automation script for deleting a triggering record.

TheTimeSavingCo
A
L
Forum|alt.badge.img+5
  • Lizbeth_Pena_Fl
  • Author
  • Participating Frequently
  • January 11, 2023

So are there equivalents to  cursor.activeTableId or input.recordAsync to run a script through a button in a cell in an interface?

Elyes80
Forum|alt.badge.img+6
  • Elyes80
  • Inspiring
  • February 18, 2023

So are there equivalents to  cursor.activeTableId or input.recordAsync to run a script through a button in a cell in an interface?


You can use a checkbox instead and it will work in the interface view 

So in my example above, when you check both checkboxes you trigger an automation that will run a script and delete the record. 

I am using the following script : 

let table = base.getTable("💰📝 Lignes de commandes");
let inputConfig = input.config();
let recordId = inputConfig['recordId']
await table.deleteRecordAsync(recordId);
 
Hope it helps.
 
 

 

D
Terms & ConditionsAccessibility statement