# Setup lookup keys for user

**URL:** <https://community.dreamfactory.com/t/setup-lookup-keys-for-user/1169>\
**Category:** Server-Side Scripting\
**Created:** [June 8, 2015, 9:50am UTC](https://community.dreamfactory.com/t/setup-lookup-keys-for-user/1169 "2015-06-08T09:50:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@Boris](https://community.dreamfactory.com/u/Boris)\
**Post date:** [June 8, 2015, 9:50am UTC](https://community.dreamfactory.com/t/setup-lookup-keys-for-user/1169/1 "2015-06-08T09:50:55Z")

</div>

I want to setup lookup keys for each user. When i do this by DreamFactory admin interface, i’m adding a new lookup key, indicate its name (for exmple, “Key1”) and value (for example, “1”). And its working.

But, i need to create this key automatically for each user, when user registers. I think, i can do it by SQL trigger in database layer and the result, there is not need to change DreamFactory php-scripts. But when i see lookup keys in database table, which where created by DreamFactory admin interface, i see values like “3BoL5oV75bzrHKdLSyU8Tm75DhA79ScGr9I1l1jIa9o=” and i realise, that value was encrypted.

How can i generate lookup keys automatically for each user?

---

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [June 8, 2015, 2:06pm UTC](https://community.dreamfactory.com/t/setup-lookup-keys-for-user/1169/2 "2015-06-08T14:06:05Z")

</div>

I moved a post to an existing topic: [Lookup Key Value in database](https://community.dreamfactory.com/t/lookup-key-value-in-database/1157)

---

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [June 8, 2015, 2:06pm UTC](https://community.dreamfactory.com/t/setup-lookup-keys-for-user/1169/3 "2015-06-08T14:06:29Z")

</div>


