Title: Recipes
Last modified: March 29, 2018

---

# Recipes

 *  [jgruberman](https://wordpress.org/support/users/jgruberman/)
 * (@jgruberman)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/question-advice-on-functionality/)
 * Hello! I am trying to see if WordPress is capable of doing an idea that I have,
   so figured I’d ask here to see if anyone had suggestions or advice on a direction.
   Here’s my scenario:
 * I have a gaming website and in the game, someone can make certain items of they’ve
   learned the recipe. I also have a Google Sheet that lists ALL of the items in
   the game as well as who can make what item.
 * Is there some sort of way to integrate the Google Sheet on the backend and tie
   it to a dropdown option on the front end(the wordpress site) where if someone
   selects “Chair” on frontend, a text table will “VLOOKUP” the Chair value on the
   spreadsheet and return the text value in another section that shows WHO can make
   that Chair? Let’s say for example, column A is the item and column B is the list
   of what players can make said item.
 * Right off the bat, I think of using a small database with a SELECT statement 
   to return the value of “Chair” but I feel like there are much easier options…
   thanks in advance for helping stir my creative juices!

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [jgruberman](https://wordpress.org/support/users/jgruberman/)
 * (@jgruberman)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/question-advice-on-functionality/#post-10134886)
 * Anyone have any suggestions to this?
 *  [RossMitchell](https://wordpress.org/support/users/rossmitchell/)
 * (@rossmitchell)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/question-advice-on-functionality/#post-10159216)
 * I have made some websites a little like this.
    (One is a family tree wiki, people
   can search on names and dates, view displays of parents + grandparents + sibblings
   + partners + children + grandchildren. Logged in users can edit data and relationships.)
   You write a plugin that creates various shortcodes, some of the website pages
   use these shortcodes to create that page display. You probably could interface
   with google docs, but I have always created custom database tables and done it
   in SQL in the plugin.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Recipes’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [RossMitchell](https://wordpress.org/support/users/rossmitchell/)
 * Last activity: [8 years, 1 month ago](https://wordpress.org/support/topic/question-advice-on-functionality/#post-10159216)
 * Status: not a support question

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics