• Resolved mstang67

    (@mstang67)


    Hello,

    I’ve built a website for my gaming group using WordPress, and I’m trying to integrate a Google Spreadsheet program that I have built to buy the resources that they have acquired. Spreadsheet located at https://docs.google.com/spreadsheets/d/1Q3sAAMhT_K7s3V9FoGCdBcrX2wB1G0Zn_DibDWKE3QA/edit#gid=229196428

    If you look at the spreadsheet, there is a data page that pulls pricing data from the in-game market and automatically updates every 90 minutes. So the user inputs how much of a material they have, which is multiplied by the in-game price, and a tax rate is applied, giving them their total. There are 3 pages of non-related goods, each page showing a page total, first page has a total for all page totals combined.

    I’m trying to integrate this into my website, but there’s no functionality. I’ve tried 8 different plugins at this point, but none of them give me the functionality I’m looking for. One was close but I’m not going to pay $130 for a program for a game that will be used once. Inline Google Spreadsheet Viewer gives me the exact look I like, but no functions.

    What I’d like is to show the spreadsheet on my website and have the users be able to input the amounts they have, and they get their prices, just like on the actual spreadsheet. The problem with the spreadsheet is that only one person can use it at a time. I’d like to set it up so User 1 inputting data is not seen by User 2 inputting data, it’s completely unique to the user.

    Is this a pipedream, or is there a way to make this happen? Thanks for your time!

    https://ww.wp.xz.cn/plugins/inline-google-spreadsheet-viewer/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Meitar

    (@meitar)

    What you are trying to do is possible with a Google Apps Script. See Google’s Apps Script documentation. This plugin supports output from Apps Scripts, although I’m not certain of exactly how you mean to integrate the data with your site, so I’m not 100% sure that this plugin will do what you want on its own. Either way, an Apps Script will let you at least link to a page that will do what you want and that is backed by a Google Spreadsheet with custom data.

    Thread Starter mstang67

    (@mstang67)

    Ah excellent. I’m very new to this stuff, no coding knowledge and really stumbling my way through, but this has been the only real hangup. I’ll definitely look more into the Apps Scripts.

    Basically I want to take this large, complicated calculator I’ve built in google spreadsheets, put it on my website with the same functionality (API data pulls and calcualtions), and have more than 1 person be able to use it at one time.

    Plugin Author Meitar

    (@meitar)

    Yeah, you have to write some additional code for that. Maybe a Google Apps Script, maybe a custom JavaScript function on your page. Not exactly hard, but not something any plugin can do because you’re trying to build a custom calculator.

    Thread Starter mstang67

    (@mstang67)

    Think I’ve gotten a little too ambitious, this stuff is WAY over my head. Probably shouldn’t be trying to learn at 2 A.M. either. Thanks for you help!

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

The topic ‘Google Spreadsheet issue’ is closed to new replies.