I have a form with two fields, or at least 2 of interest. One (Facility_Name) is a text field that the user inputs the facility name (i.e. Place's Name). I have another field in which I am trying to create a file name of sorts (FileName). This field needs to take the Facility_Name information and put it into the file name without spaces or special characters (i.e. PlacesName). The names are not consistent format, so I can't use something like the substr function. Is there a formula or other way to do this? I haven't been able to find one. Thanks.
Hi Brandon,
There isn't a built-in XLSForm function that would do what you are asking; however, there is a feature (custom JS functions) in beta on the Early Adopter Community that could address this.
Okay, thank you for the info. Glad I’m not going crazy. ☺