ContributionsMost RecentMost LikesSolutionsPipeline Error: " Quickbase reported an error: 2 : Invalid input : You must provide a valid choice for the field named "Requesting Business Unit" with field id 7."I am getting an Error with my Pipeline that reads, "Quickbase reported an error: 2 : Invalid input : You must provide a valid choice for the field named "Requesting Business Unit" with field id 7." From what I understand both fields options must match exactly for this pipeline to continue. With that being said, both fields are exactly the same. We think the error is created because QB is having an issue with the "&" symbol in several of the responses. Example, both fields show "Mass Markets & Distribution", but in the sample data option for fields one shows "Mass Markets & Distribution" Any ideas how to work around this? We have attempted to URLEnode the field, but we are receiving the same error ------------------------------ JASON VOSS ------------------------------ Re: Error with Pipeline that is trying to insert a text field into a text multiple choice fieldI believe we are currently having the same issue, though we have made sure both fields match. We have a theory that the "&" in the choice list is what might be throwing off the pipeline. the error reads: "Remote service reported an error: 2 : Invalid input : You must provide a valid choice for the field named "Requesting Business Unit" with field id 7.". The response that often creates the error is "Mass Markets & Distribution - Wireless". Is that a possibility or could it be something else? Thanks! ------------------------------ JASON VOSS ------------------------------ Re: ToText If Statement ErrorThis put me on the correct path with very little additional items, thanks! ------------------------------ JASON VOSS ------------------------------ ToText If Statement ErrorI am working on creating a Summary Field from Formula - Rich Text and keep getting the error "The operator "<>" can't be applied on types textlist, text". Formula = List("\n", If([Field 1]<>"", "Summary Text 1:" & [Field 1]) The below formula is nearly what I want, but I don't want to summarize the field if the field is blank and the below formula still adds the "Summary Text 1:" if the field is blank. Formula = ToText("Summary Text 1:" & [Field 1]) Thanks! ------------------------------ JASON VOSS ------------------------------