Hi DRay ,
Yes - essentially I am looking for something similar in principle to the dashboard filter menu - it I want to filter by a text field, I can pre-select from any of the existing values, but I can also specific specific text that may not (yet) be in the data.
My use case is that I use security rules to restrict access to individuals to certain retail stores based off the store ID. If a new store enters circulation but is not in the data, instead of adding a rule, selecting the user and the value, I have to find the user's user ID via the REST api, create a file of IDs and intended values, then POST the file via the API. The API is great for bulk-edits but I am looking for the ability to make these one-off edits via the GUI where I have to specify the value. It's clearly possible for the rules to exist but they can't be made 'natively'. Thanks.