1. msreyes
  2. Presales Question
  3. Thursday, June 04 2020, 02:56 PM
I know with the paid version I can select fields which are drop downs and populate the values. What I will be doing is filling them with locations. I will have about 80 locations :p What I will be doing is getting my members to sign up, and select the correct location.

After that I would like to have an "admin" who can only see users who selected that location.
admin Accepted Answer
Admin
Hi,
with location you mean Country and Cities (2 drop downs fields)? if yes then you can fill the dropdown (select) fields with values from DB. Try to see this reply https://www.easy-profile.com/support/conditional-drop-downs.html#reply-11318

After that I would like to have an "admin" who can only see users who selected that location.
There are different ways to make this, you can create a user lists menu item only available for admin (in the menu item you can set "Access" parameter) with a static filter (the parameter is called Custom SQL Where) like
country_field_alias LIKE "_%"
(this is sql to filter only fields with at least 1 char in the value)
  1. more than a month ago
  2. Presales Question
  3. # 1
msreyes Accepted Answer
Pro
Perfect! Works as expected
  1. more than a month ago
  2. Presales Question
  3. # 2
msreyes Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Presales Question
  3. # 3
admin Accepted Answer
Admin
Hi,
If you want to show all users with a same value of logged in user then you can use Custom SQL Where with Content Plugin.

So you can use a syntax like this:
alias = "{user alias raw}"


Our Content Plugin will replace the code {user alias raw} with the value of current logged in user.

Docs:
Custom SQL Where: http://docs.easy-profile.com/index.php/article/sql-custom-where
Content Plugin: http://docs.easy-profile.com/index.php/article/content-plugin
  1. more than a month ago
  2. Presales Question
  3. # 4
msreyes Accepted Answer
Pro
That's cool... thanks!!!
  1. more than a month ago
  2. Presales Question
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.