another way that filtering
Is there a code I can use instead of the filter so the swedish only can see the swedish organisation? It can work with the filter but if the swedish remove the filter they can also see everything and thats not so good.
What to do? and where to paste in the code?
4 replies
-
A View layout element might work for you. Here is the format of the formula you would use...
select YourTable where YourField = "Sweden" -
Hi again.
Yhanks but I can not make it work... Do I do something wrong?
I do this:
select Sponsors where Organisation = "Sweden"
-
Hello,
My suggestion was to use a View layout element, but you might find that it won't work for your needs. The View layout element is added to the Form view just like a field and you will only see it in Form view. You will find it here...
This is what it looks like on the Form...
This is the code that goes in the View's formula...
(select Vendor where text(State) = "TX") order by Name -
You can omit the "order by" part of the formula because it doesn't have any affect on the order of the View. You can set the order in the View like you would a Table.
Content aside
- 5 yrs agoLast active
- 4Replies
- 1258Views