How to insert multiple files in container field by using a script with validation
I have a long list of records and each record has its own file, which i am inserting manually in container field and having a hard time with this tedious task. All file names are sharing the same name as in the Title field. Example:
Title (text field) - "The Palace" File (container field) - "The Palace.kmz." with an exception of extension (.kmz) at the end.
All the files that i am inserting are in the same folder. I need a script that should match the file name with Title in the table and insert the corresponding file from the folder into container field accordingly.
I am new to Filemaker and don't know about scripting too. Please advise how to do this?
Thank you in advance.