My aim was to use a select query to select from a list where a value was equal to a value in another column as well as add the option to create a “New Entry”, similar to an enum list. Then autofill some following columns. Since this is not possible what is the best workaround?
At the moment I have a select query that is the list and a “New Entry” as below.
=Select(TableA[Column1], [Column2] = [_ThisRow].[Column3]) + {“New Entry”} This also helps when an existing record is accidentally chosen and the user wants to go back to create a new record without doing the form again.
Then I have a group of columns for a new entry to manually fill in when "New entry is selected and another group of columns of the same value types for the autofill if a record exists and selected. Dependent if a new record or existing record is chosen the alternate group of columns are then hidden.
Although what is in place is functional. The problem is the complexity it is causing and the displayed data is inconsistent. For example in a related record inline view, "New Entry is displayed instead of a Name though I can not refer to the other column to show the correct name. Also existing entries need to be referred from another table and new entries need to be referred from the current table which now limits my functionality for future development improvements.
LinkedIn
Twitter
