Welcome to the community, @Tyler_Curran! :grinning_face_with_big_eyes: On the surface the script looks okay, at least in terms of syntax (there are some unnecessary/redundant bits, but that won’t affect what you’re trying to accomplish). That means the data is probably to blame (at least partly).
In this case, I would closely compare the options in the relevant single-select fields. Chances are the option you’re trying to set in the target table isn’t a 100% match for the one coming from the form. They have to be exactly the same: same case, same punctuation, same use of spaces (or lack thereof), etc. For example, “First” and “first” won’t be considered the same and will throw that error you’re seeing. It’ll also throw an error if it’s “First” in one and "First " in the other (notice the space at the end of the second option). Once you’re certain that the options all match exactly, my gut says it’ll work.
Welcome to the community, @Tyler_Curran! :grinning_face_with_big_eyes: On the surface the script looks okay, at least in terms of syntax (there are some unnecessary/redundant bits, but that won’t affect what you’re trying to accomplish). That means the data is probably to blame (at least partly).
In this case, I would closely compare the options in the relevant single-select fields. Chances are the option you’re trying to set in the target table isn’t a 100% match for the one coming from the form. They have to be exactly the same: same case, same punctuation, same use of spaces (or lack thereof), etc. For example, “First” and “first” won’t be considered the same and will throw that error you’re seeing. It’ll also throw an error if it’s “First” in one and "First " in the other (notice the space at the end of the second option). Once you’re certain that the options all match exactly, my gut says it’ll work.
Wow, it was definitely a spelling error. Appreciate the insight!