Spreadsheet and WordPress

  • Anonymous User 14711751

    (@anonymized-14711751)


    9 years, 1 month ago

    I used CMS Made Simple before WordPress and I had a web based spreadsheet. Users were able to calculate with it and the formulas were protected.

    It inculed .php-file which had html such as: input type=”submit”, {$varABC} etc.

    And then an user defined tag which included formulas such as:
    $varABC = $_POST[‘formABC’];
    $smarty->assign(‘varABC’, $_POST[‘formABC’]);
    $varABC = $varCDE + $varFGH;
    $smarty->assign(‘varABC’, $varABC);

    What would be the best and easiest way to do that in WordPress?

    Thanks
    Syreeni

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    9 years, 1 month ago

    You probably should just use Google sheets. Your sheet can be embedded on a WP page by pasting in some iframe code provided when you pick the sheet’s Publish to Web menu item. Google sheets have an API where you can remotely manipulate the sheet by script. So I imagine you could have some input fields on the page with the embedded sheet and when submitted, the data can be sent to the sheet through the API and placed in certain cells. Then the formula cells will update accordingly.

    Depending on what your sheet is actually calculating, it may make more sense to build a custom calculator app that takes user input, crunches the data, then updates the display with the results. Nowhere near as flexible as a spreadsheet, but when a sheet’s formulas are protected, it’s no longer flexible. Depending on your need, all the calculation could be handled by JavaScript. Being event driven, the resulting app could be very interactive and be just as satisfying to the user as a sheet with protected formulas.

    Thread Starter Anonymous User 14711751

    (@anonymized-14711751)

    9 years, 1 month ago

    Thank you bcworkz! Your answer gave me good image what are the possibilities with WP. I think the second option would be the best one.

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

The topic ‘Spreadsheet and WordPress’ is closed to new replies.