Hm for the RecordID field, try using 'RECORD_ID()' instead of 'RIGHT("000000" & RECORD_ID(), 6)'?  Think that should help

would i need to change the field in the "Generate" tab?

i did change the record id field but still had the 404

Ah sorry about that, yeap, you need to update the button formula to be the following:

@dancarl 

Some top Make tips for you here:

While it is often desired to trigger a Make automation through a button in Airtable, that always opens up an extra browser tab that you need to close afterwards, either manually or through a JavaScript.

Now the advantage to this is that you can control the contents of that browser tab by using Make’s webhook response module.

But if you just want the automation to run without taking the user out of Airtable, you can trigger your Make automation using Airtable’s automations. I discuss how to use this technique in this thread.

I’ve also assembled a bunch of additional Make training resources in this thread.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

now i don't get my unique "RecordID" in the row i just get ( RECORD_ID() ) in each row and still get the 404 error.

thank you

Hmm, weird!  I tried it out and it seems to be working fine.  Could you have a look at the base and try to see what's different from your own set up?

To do that, you'll need to duplicate the base into your own workspace with instructions on how to do that here: https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-bases-in-airtable

your example it's passing on the unique Record id in the webhook formula. I need it to pass on the Main Keyword. 

so I must be missing something simple? So will go over what I'm trying to do again. 

so airtable has 3 columns so far, first one is RecordID then Main keyword and the last is Generate.

When I click a new row it automatically generates a new unique RecordID of 6 characters  and the blue generate button appears. I manually add in the Keyword and hit generate and it sends the keyword to the Make.com workflow. 

my formula in the "RecordID" looks fine it generates a unique code and the formula is 

RIGHT("000000" & RECORD_ID(), 6)

The Generate formula is 

Hmm, yeah, I reckon it might be faster if we get on a call to do this.  I do free half hour calls and we should be able to get you sorted within that time and you can grab a time here!  https://calendly.com/adamc_airtable/30min