0

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?

Skærmbillede 2019-09-14 kl. 12.02.07 

4 replies

null
    • Sean
    • 4 yrs ago
    • Reported - view

    A View layout element might work for you. Here is the format of the formula you would use...

     

    select YourTable where YourField = "Sweden"

    • Carsten_Jespersen
    • 4 yrs ago
    • Reported - view

    Hi again.

    Yhanks but I can not make it work... Do I do something wrong?

    I do this:

    select Sponsors where Organisation = "Sweden" 

    Skærmbillede 2019-09-15 kl. 07.54.39

    • Sean
    • 4 yrs ago
    • Reported - view

    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...

     

    Screen Shot 2019-09-15 at 9.32.54 AM

    Screen Shot 2019-09-15 at 9.33.23 AM

     

    This is what it looks like on the Form...

     

    Screen Shot 2019-09-15 at 9.39.35 AM

     

    This is the code that goes in the View's formula...

     

    (select Vendor where text(State) = "TX") order by Name

    • Sean
    • 4 yrs ago
    • Reported - view

    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

  • 4 yrs agoLast active
  • 4Replies
  • 1258Views