MCFNeilQrew Captain8 years agoRe: Need to separate text into two fields. How?Evan,You will want to use a combination of "Left" and "NotLeft" in a formula to separate out the first from the last. It will look something like this:NotLeft([Full Name], " ")&", "&Left([Full Name], " ")Let me know if that works for you.
1 ReplyReplies sorted by Most LikedSort ByMost LikedOldestNewestEvanBohanQrew Cadet to MCFNeil8 years agoThank you!
Related ContentAn API(?) button to copy fields from the form, to other fieldsLookup a value with multiple conditions into a field in a separate tableMultiple reference proxy fields helpPipeline Make Request - Return Make Request JSON Output into fieldsSeparate Multi select text for Bar graph
Recent DiscussionsMobile WebUI HelpWhat is the matter with my API Button formula?Live Chat with Others in The Qrew in DiscordFilter out some records on related tableSolvedNew Form - Show Create Record button