Formula Question

Aaron_Bowen

Hi, 

I was wondering if there is a way to pull all values from a field into a formula. For instance: [FIELD] IN ("[ALL VALUES]"). i want to use an app with a textbox, but if the textbox is empty I want to pass all of the values. Otherwise, I would use the textbox value to replace the "[ALL VALUES" portion of the formula. 

Thanks, 

Aaron

griffinwelsh

You can use a summarize tool to create an all values field by concatenating the field to form a single string. Then you can append this field to your data set and use your in function with the [all values] field that you created.