Help

Extension scripting error : Error: No field matching

Topic Labels: Extensions
453 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Les_Gros_Becs
6 - Interface Innovator
6 - Interface Innovator

Hi all!

I'm currently encountering a problem when I run a script (it is a script that was already made in another base that I tried to adjust to a new base). 

The script allows me to import data from a third-party excel sheet into my base. I mapped all the fields I needed from the excel sheet into my base (I don't need them all). 

Here is the info from the excel sheet that is supposed to be created into my base :

Capture d’écran, le 2023-08-17 à 10.19.04.png

And here is the error I am receiving while running the script :

Capture d’écran, le 2023-08-17 à 10.25.43.png

Here is my script at lines 91 and 114 :

Capture d’écran, le 2023-08-17 à 10.30.14.png

Capture d’écran, le 2023-08-17 à 10.31.08.png

I created the field -NBxajiiiCAqstlW9O7- just to see what the script what doing. It is putting ''Création du donateur'', which appears at line 91, into the field. What I need is for the id numbers that are shown in the excel sheet to appear in the corresponding fields in my base (idContact and idFundraisingDonation).

Thanks for the help!

David 

2 Replies 2

Sorry, I don't know scripting so I can't help you there.

However, you can do this with no scripting at all by using Make.

I discuss a similar solution in this episode of the BuiltOnAir podcast:

https://youtu.be/cMA4GPj4iNE

I watched it and I might go with that solution. Thank you!