Looking for the best way to accomplish the following.
I am using quickfield to import a bunch of images, One of my field is whether this image is the Primary Image. The field has a dropdown list associated with it, with values of Yes or No. Each image is named with the ParcelID associated with the image, there could be multiple images for a Parcel ID, in this case a (X) where X is the index of the image.
example
9876541.jpg
9876541 (1).jpg
I would like the first image to have the Primary Image field set to Yes and the second image to have the Primary Image set to No.
Basically any image the has a (X) in the name should be set to No in the primary image field.
Is the only way to accomplish this with a custom process?