סקרי דִּיסקורס

:discourse2: Summary Discourse Surveys plugin allows you to create surveys directly within your Discourse forum posts using simple Markdown syntax.
:hammer_and_wrench: Repository Link https://github.com/discourse/discourse-surveys
:open_book: Install Guide How to install plugins in Discourse

The Discourse Surveys Plugin allows you to create surveys directly within your Discourse forum posts using simple Markdown syntax. The plugin currently supports a variety of question types such as radio buttons, checkboxes, dropdowns, number inputs, text areas, star ratings, and thumbs up/down ratings.

Features

  • 7 Different Field Types: Radio buttons, checkboxes, dropdowns, text areas, number selection, star ratings, and thumbs up/down

  • Required/Optional Fields: Mark fields as required to ensure completion

  • Emoji Support: Use emojis in your survey options

  • HTML Support: Rich text formatting in questions and options

  • User Authentication: Automatic login prompts for anonymous users

  • Response Tracking: Prevents duplicate submissions from the same user

  • Permission Aware: Respects topic and category permissions

  • Mobile Responsive: Works seamlessly on all devices

Usage

Basic Survey Structure

All surveys must be wrapped in [survey] tags:


[survey name="my-survey" title="Customer Feedback Survey"]

<!-- Survey fields go here -->

[/survey]

Survey Attributes

  • name: Unique identifier for the survey (defaults to “survey”)

  • title: Optional title displayed at the top of the survey

  • public: Set visibility (future feature)

  • status: Survey status (future feature)

Field Types

1. Radio Buttons (Single Choice)


[radio question="What is your favorite color?"]

- Red

- Blue

- Green

- Yellow

[/radio]

2. Checkboxes (Multiple Choice)


[checkbox question="Which features do you use? (Select all that apply)"]

- Email notifications

- Mobile app

- Desktop notifications

- API access

[/checkbox]

3. Dropdown Selection


[dropdown question="What is your age group?"]

- Under 18

- 18-24

- 25-34

- 35-44

- 45-54

- 55+

[/dropdown]

4. Text Area (Long Form Text)


[textarea question="Please provide detailed feedback:" required="false"]

[/textarea]

5. Number Selection


[number question="Rate this feature from 1-10:" min="1" max="10"]

[/number]

6. Star Rating


[star question="How would you rate your overall experience?"]

[/star]

7. Thumbs Up/Down


[thumbs question="Would you recommend this to others?"]

[/thumbs]

Field Attributes

All field types support these attributes:

  • question: The question text (required)

  • required: Whether the field must be filled (true/false, defaults to true)

  • min: Minimum value for number fields

  • max: Maximum value for number fields

Complete Example

Basic Survey Markdown

Here is a basic example of survey Markdown including all available fields:

[survey name="awesome-survey-thumbs" title="Awesome Survey"]

[radio question="Choose any one option:"]
- cat
- dog
[/radio]

[checkbox question="Choose multiple options:"]
- red
- blue
- green
[/checkbox]

[dropdown question="Gender:"]
- Male
- Female
[/dropdown]

[number question="Rate this survey from 1 to 10:"]
[/number]

[textarea question="What is your feedback about xyz?" required="false"]
[/textarea]

[star question="How would you rate overall experience?"]
[/star]

[thumbs question="Were you satisfied with our services?"]
[/thumbs]

[/survey]

Survey Rendering

Below is an example of how the above Markdown renders in Discourse:

Advanced Usage

Using Emojis in Options


[radio question="Choose your favorite animal:"]

- 🐈 Cat

- 🐶 Dog

- 🐦 Bird

- 🐠 Fish

[/radio]

HTML Formatting in Questions


[radio question="Which <strong>programming language</strong> do you prefer?"]

- JavaScript

- Python

- Ruby

- Go

[/radio]

Mixed Required and Optional Fields


[survey name="mixed-survey"]

[radio question="What is your role?" required="true"]

- Developer

- Designer

- Manager

- Other

[/radio]

[textarea question="Any additional thoughts?" required="false"]

[/textarea]

[/survey]

Survey Results

Currently, this plugin does not have any backend UX to view the survey results directly. Instead, you can rely on Data Explorer queries to fetch and analyze survey responses. Here is an example query:

-- [params]
-- text :survey_name = survey

SELECT s.id, s.name, s.post_id, sf.question, COALESCE(sr.value, sfo.html) AS value, sr.user_id, sr.created_at as responded_at
FROM surveys s
JOIN survey_fields sf ON sf.survey_id = s.id
JOIN survey_responses sr ON sr.survey_field_id = sf.id
LEFT JOIN survey_field_options sfo ON sfo.id = sr.survey_field_option_id
WHERE s.name = :survey_name
ORDER BY s.id DESC

Permissions and Security

  • Login Required: Anonymous users must log in before submitting responses

  • One Response Per User: Each user can only submit one response per survey

  • Topic Permissions: Users must have read access to the topic to view surveys

  • Posting Permissions: Users must have posting permissions in the topic to submit responses

  • Archived Topics: Surveys in archived topics cannot accept new responses

  • Deleted Posts: Surveys in deleted posts are no longer accessible

Limitations

  • Only one survey is allowed per post

  • Survey structure cannot be modified after receiving responses

  • All survey field questions must be unique within a single survey

  • Survey field questions cannot be blank

Technical Details

Database Schema

The plugin creates four main database tables:

  • surveys: Main survey records

  • survey_fields: Individual fields within surveys

  • survey_field_options: Options for choice-based fields

  • survey_responses: User responses to survey fields

Styling

The plugin includes responsive CSS that adapts to your theme. Custom styling can be added by targeting these CSS classes:

  • .survey - Main survey container

  • .survey-field - Individual field wrapper

  • .field-[type] - Specific field type containers

  • .submit-response - Submit button

31 לייקים

So users can’t see results (unless they have rights to use query) and this is totally for admins/background staff?

3 לייקים

Yes, that is correct.

7 לייקים

It doesn’t feel very practical :cry:

3 לייקים

Need option to publish survey results. Otherwise better to use multiple polls.

3 לייקים

Hello

The sample Markdown renders in a new Topic as per below. My Discourse is updated to the latest version.

What could the the problem?

Regards

Hey @ppcole,

The above is what is shown in composer preview when you’re creating the survey. Once you create the topic it will render properly as expected.

Thanks Arpit. It worked. Looking forward to enhancements

לייק 1

האם אוכל לדעת אם אתם עובדים על זה אבל לא בעדיפות ממשית?

זה יהיה נהדר אם זה ימשיך להיות מפותח - יש לזה המון פוטנציאל.

I found that the SQL above did pull out the results, but it wasn’t in an easy to work with format; basically it would require a tonne of transformation at the spreadsheet level to enable useful analysis.

However, with a bit of Gen AI help, I was able to produce a very sweet Data Explorer query. Due to some limitations of Data Explorer, it isn’t possible to make it dynamic enough to cope with a variety of surveys; basically you need a bespoke query per survey.

Fortunately, Gen AI can make that pretty straight forward. Here is a sample prompt that will probably work in most Gen AI services (if you don’t have the AI plugin active) - just plugin in your survey markdown and you should be away:

Gen AI Prompt to Produce Tailored SQL Query for a Specific Survey

I have a survey defined in markdown format, and I need a SQL query to extract the survey results from a Discourse database using the Data Explorer Plugin. The survey includes various types of questions such as radio, dropdown, star, checkbox, textarea, thumbs, and number. I want the query to output results with each user having a single row and each question having its own column. For checkbox questions, multiple responses should be concatenated into a single string.

Here is the survey markdown:

Paste your survey markdown here

Here is the original query used to obtain survey results:

-- [params]
-- text :survey_name = survey

SELECT s.id, s.name, s.post_id, sf.question, COALESCE(sr.value, sfo.html) AS value, sr.user_id, sr.created_at as responded_at
FROM surveys s
JOIN survey_fields sf ON sf.survey_id = s.id
JOIN survey_responses sr ON sr.survey_field_id = sf.id
LEFT JOIN survey_field_options sfo ON sfo.id = sr.survey_field_option_id
WHERE s.name = :survey_name
ORDER BY s.id DESC

Please generate a SQL query that:

  • Hardcodes the survey name.
  • Uses conditional aggregation to pivot the data, with each question as a column.
  • Utilizes STRING_AGG for checkbox questions to handle multiple responses.
  • Ensures the output is grouped by user_id and ordered by user_id.
  • Is formatted for readability and includes comments explaining the logic where necessary.

Additional Guidance for Data Explorer Plugin:

  • The query should be compatible with the Discourse Data Explorer Plugin, which means it should not end with a semicolon.
  • Use column names like user_id to leverage automatic linking features within the Data Explorer.
  • Avoid using dynamic SQL, as the plugin does not support it.
  • Ensure the query is efficient and optimized for performance, as it may be run on large datasets.
8 לייקים

זו תוסף קטן ומצוין שהוא עשיר בתכונות באופן מפתיע.

תודה שיצרת אותו.

@nathank עבודה מצוינת על המדריך לבניית שאילתות תוצאות במהירות.

4 לייקים

התקנתי את זה באתר שלי שמומן על ידי עצמי כדי לנסות אותו, וזה באמת נחמד!

אני מבין שזה נוגד את הדיסקורס, אבל יהיה מועיל אם ניתן יהיה ליצור סקרים שניתן להשלים באופן אנונימי, ללא צורך בהתחברות. או לפחות לאנונימיזציה של התוצאות כך שהן לא יהיו משויכות למשתמשים ספציפיים.

וכמובן שכן, היכולת להסתכל על התוצאות כמו שאתה יכול עם סקרים מבלי להזדקק לחוקר הנתונים תהיה פנטסטית.

5 לייקים

כן, נתקלתי באותה בעיה. מקווה שיש פתרון.

3 לייקים