Ampersand messing up formula/form rule
I think having an '&' in my field is messing things up. Help I have a formula text field 'Department Formula' that works great: If(Contains([Employee/Contractor - Department],"Inflight Services"),...
Forum Discussion
Most likely, the ampersand is causing an issue, though I would suggest an alternative approach.
It looks like you've already setup the Department as a Lookup from the Employee record. If you haven't already, I would set that Department field on the Employee table as its own table. Then, in the Departments table, add a new field for "Short Name", where you would enter the values that you're having the formula currently create. Once you have that done, you can simply bring the "Short Name" field down as a lookup as well and replace the current Formula / Multiple Choice Drop-down setup with the new lookup field.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
It looks like you've already setup the Department as a Lookup from the Employee record. If you haven't already, I would set that Department field on the Employee table as its own table. Then, in the Departments table, add a new field for "Short Name", where you would enter the values that you're having the formula currently create. Once you have that done, you can simply bring the "Short Name" field down as a lookup as well and replace the current Formula / Multiple Choice Drop-down setup with the new lookup field.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------