Google Sheet Integration

  • Resolved zoey

    (@zoeyisyoung)


    5 years, 9 months ago

    HI, I want to know if and when you can add direct Google sheet integration to pipe data immediately upon test submission by each user in realtime so I can trigger some complex calculation in Google sheet.

    Also if and when you can add direct update the calculated results from Google sheet back to a result page so we can present to the user on the web.

    This is for a research project so we will have a lot of users testing to be done.

    Thanks in advance.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor ustimenko

    (@ustimenko)

    @zoeyisyoung, I’m not planning such feature.

    Can you provide and example of complex calculation?

    Currently there is export addon for exporting results. Then you can apply to those data any calculations you need.

    Thread Starter zoey

    (@zoeyisyoung)

    HI thanks for the prompt reply! This is my research project and we need to do statistical measures of the outcome of an individual’s scores to see how it correlates with the norm. Type of stats functions include mean, standard dev, correlation, coefficient alpha, etc. Would you be able to add these functions?

    Also you Export Results add-on is a manual one that admin goes into panel to click download?

    I have these tests that have the same set of answers but their values differ depends on the question:
    e.g. I am interested in people – has five possible answers:”Very Inaccurate”, “Moderately Inaccurate”, “Neither Accurate Nor Inaccurate”, “Moderately Accurate” and “Very Accurate” value as 1, 2, 3, 4, 5.

    Another question: I enjoy parties – has the same five possible answers, but the value of the answers would be of value 5,4,3,2,1 in that order.

    It means the questions have 2 perspectives – positive vs. negative. How to implement these answers to allow different values base on the questions?

    Lastly, what is the COUNT column for in Answers?
    Thanks

    Plugin Contributor ustimenko

    (@ustimenko)

    Would you be able to add these functions?

    No, as it’s not test’s responsibility. To analyse data you should use R for example.

    Export Results add-on is a manual one that admin goes into panel to click download?

    Yes.

    How to implement these answers to allow different values base on the questions?

    Don’t understand your issue completely. You can order paid support for your complex test logic.

    what is the COUNT column for in Answers?

    Dont’ understand what do you mean.

    Thread Starter zoey

    (@zoeyisyoung)

    Hi, Thanks for your reply.

    1. what do you mean by use R to analyse data?

    2. ok, I can do the formulas on Googlesheet as long as I can export the data. So I will connect with your via your add-on page.

    3. Count – this is a column show on the Test Result and Scale page, look far right it has name, description, slug and Count. What is this Count column for and the meaning of the 1s or 2s etc.?

    4. Can I purchase customized work like automate the exporting of test results?

    Plugin Contributor ustimenko

    (@ustimenko)

    @zoeyisyoung

    1. what do you mean by use R to analyse data?

    my research project

    Are you really researcher? https://www.r-project.org/

    3. Count – this is a column show on the Test Result and Scale page, look far right it has name, description, slug and Count. What is this Count column for and the meaning of the 1s or 2s etc.?

    It’s a wordpress’s column. It means hopw many this thing was used in tests.

    4. Can I purchase customized work like automate the exporting of test results?

    No, because I don’t have it and don’t plan to implement as export targets are infinite.

    Thread Starter zoey

    (@zoeyisyoung)

    Thanks for all the answers.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Google Sheet Integration’ is closed to new replies.