Action script behaves differently than Extension script

Hi,

What’s the output of output.set(‘clientRename’, clientRename); ?

I think you should also check duplicatesCounter

upd: yes, counter was 0 and the reason : record.name ='Unnamed record' inside loop.

with record.getCellValueAsString(‘your_primary_field’) it works OK.

interesting case.

btw, it works ok with record.name, when for loop not used

let {clientID,clientName} = input.config();

let table = base.getTable('Clientes');

let view = table.getView('Clientes Duplicados');

let query = await view.selectRecordsAsync({fields: []});

let val=x=>x.toLowerCase().replace(/\[+\d+\]/g,'').trim()

let dupes=query.records.filter(r=>val(r.name)==val(clientName))

let update={'Nombre':clientName+'['+dupes.length+']'}

if (dupes.length>1) await table.updateRecordAsync(clientID,update)

Hi Alexey,

First of all, thanks for your excellent contribution and quick response, unfortunately it still doesn’t work when fired from the trigger (action script), but it works fine when run from the extension script (same as my code).

The record is executed from an Airtable interface and, in theory, the record should be created only when the Submit button is pressed, or so I have interpreted from the documentation.

Once the submit button is pressed, the automation should be triggered, which has this structure:

TRIGGER

• When a record is created in Client

ACTIONS

• Run a script (my code or yours) [Output.clientRename]


• Create record
  
  TABLE: Journal Client (historical)
  
  FIELDS: Origin = Record for step 1->Airtable record id
  
  Name = clientRename
  
  …

I suspect that the ACTUAL write operation to the table occurs when the automation completes and therefore it is the update in the script that fails, but I am new to Airtable and I am probably wrong and there is another reason why that the script does not work, in any case, I really appreciate the interest and the time you have dedicated to trying to help me, thank you very much.

Best regards,

PS: I really liked the elegance of your code and the economy of resources used :winking_face:

Yes, such automation behavior happens for some users, you can search here to read more. I never encountered such issue, but remember that solution included some additional field(s) with ‘Date created’ and view with some delay (5 minutes?) and trigger changed to “When record enters view”.

You can dig into run history to be sure. Like this

Maybe you can install script step before your actual script, with some delay and avoid extra fields. No timeout/sleep/delay command, but you can, for example

try {const responce = await fetch('https://somesite.com')

  console.log(responce.status===200? 'ok':'not ok')}

  catch {console.log('not ok')}

But then, in your actual step, you cannot rely on input.config().clientName, because it’s value defined at the automation start. Instead, you should query it using ID (which does not change after creation)

query.records.getrecord(id).name //or query.records.getrecord(id).getcellvalue('field')

Hi Alexey,

I’ve finally gotten it to work, although I’m not quite sure how since I’ve changed so many things that now I have no idea which one has produced the miracle.

I changed the approach in relation to the trigger that fired the event and it didn’t work either, I changed the code and introduced the following modifications (that I remember):

1. Nominate the field to work with the data collection:
   
   let query = await view.selectRecordsAsync({fields: ['Name']});
   


2. Take the “cleanup” out of the filter’s clientName variable to optimize performance:
   
   let clientClean = val(clientName)
   


3. I used CellValue to get the cell value:
   
   r=>val(r.getCellValue('Name')
   

I’m sure I’ve made a lot more changes and gone back to the origin several times so I may have changed something else, the end result is that it now works although I had to do some tweaking to get the duplicate numbering to work as expected. (the same way Windows File Explorer works with duplicate files)

Again, thank you for the enormous and selfless help you have given me.

Best regards,