Greetings
I have a Table with a Column that contains a reference.
I put a valid if statement to filter that allow a select list of reference values from the "Names Table
Let say
“Names Table”
Name ID | Name |
---|---|
11 | Bob |
12 | Sue |
13 | Jim |
When I add an entry it works and I can only select from those three names.
However, I added an action on another table where the same reference is telling it to Place the Name ID into the proper column
and it works
If it is suppose to put Jim in the row when you look at the Raw table is has the value “13”
and the View displays “Jim”
But The Entry also says “The entry is invalid”
If Click the drop down to assign different name it gives me these option
Bob
Sue
Jim
Jim
Listing Jim twice (I guess the Correct Jim and my Jim)
I can remove the error by just removing the Valid if statement, But I still want that. If I add the entry without the action I still only want to get three options
And it is not just Jim. My action actually creates three new rows with these names in them and all three do the same thing.
Any Ideas on What I may be doing wrong here?
Thanks
Solved! Go to Solution.
Problem Fixed!!
That is just the shorthand I used for post for the valid if. It is actual a Select() statement.
Going Back get data for this response I noticed that my Valid if Select Statement was actually
Select(Names[Name]…) Which would return all the labels.
I changed that to
Select(Names[Name ID]…) and now the problem is fixed.
Guess I just needed a good nights sleep.
Thanks
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |