How to synthesis data from involve.me submission into number data for QuickChart?

Hi there @Cben,

Welcome to the Community! 🎉

I understand that you're looking to convert text responses from involve.me into numerical data, which will then be used in Quickchart. To assist you better, I need a bit more information:

Could you please provide more details about the 17 categories? What kind of questions are included in these categories? For the 11 categories that are the sum of 3 specific questions, could you clarify how you want to convert the text responses into numerical data?

Similarly, for the 6 categories with single questions, how do you plan to convert these text responses into numbers? Could you also elaborate on how you plan to use this numerical data in Quickchart?

Please keep us posted! 😊

Hi @Cben! 👋

Looking at the helptext for a QuickChart Create Pie Chart action it needs you to supply a “Comma-separated numbers with each number representing a pie slice” then supply the labels for each pie slice in a separate field.

How does the data for involve.me submissions look in the Zap? Specifically do we get a series of separate question fields with the name of the selected answer or do they have an ID number or point value instead? If you could share a screenshot of the test sample from Involve.me trigger showing how what values we receive for the question fields that would be much appreciated.

It may be that you’ll need to use a Formatter (Utilities > Lookup Table) action to convert the value for each question field that’s received into the corresponding point value so you can supply that to the QuickChart action. But I’d like to see how those question fields are being sent over to be sure. Please remember to remove or hide any private information from it first (like names, email addresses etc.).

Looking forward to hearing from you!

Thanks for sending those screenshots over, @Cben. 🙂

It’s still a little hard to see how the question fields are coming over, it looks like you might be getting the name of the answer that’s been selected e.g. “No” instead of the point value. Is that correct? If so, I also noticed a Run Javascript Code action in the Zap. Is that assigning a value based on the answer that’s selected for each question?

If that’s the case, in the Create Chart action it looks as though a list of data values ([4, 9, 7, 3, 4, 2...etc]) has been typed in instead of being selected from the involve.me trigger. So if the points are being assigned by that Run Javascript Code action, then you’d want to select the points values it outputs for those manually typed data values instead.

And looking at the documentation for Chart.js it seems like the labels are missing from the code in the Chart.js configuration field. It appears that it’s expecting to receive a list of the labels above the datasets section, for example:

So you’d need to update the code in the Chart.js configuration field to include the relevant label names.

If that’s not the case, please can you share a screenshot of the fields as they appear within the Test section of the Involve.me trigger step (step 1 of the Zap)? For example, if the trigger was Google Sheets the screenshot would look something like this:


Thanks for your assistance here, we’ll be keeping an eye out for your reply!