How can I force users to fill in a custom field when it’s empty

Development

AI-generated summary

Jacky2 is trying to create a feature that prompts users to fill in a custom field if it’s empty. They’re looking for a way to achieve this through a Discourse plugin. pfaffman suggests exploring the User Wizard plugin or a theme component as possible solutions, and Simon_Manning provides guidance on how to retrieve users with empty custom fields using SQL. After taking their advice, Jacky2 successfully implements the Custom Wizard plugin, which works as desired.

1

Hello Discourse community!
I’m new to Discourse and trying to use my few ruby ​​knowledge. Thanks for your help !
Here is my project :
I created custom fields to get to know a new user better and now I want to update the custom field for old users.
I want to display my question at login if the field is empty.
If I understand Discourse correctly, I need to code a plugin.
Do you have a tip or an example in mind for this first challenge?
Thanks in advance !

2

In rails console, i use

UserCustomField.where.not(value: [nil])

to find users who have already replied but for the rest I dry…
How to get users who haven’t answered the question?
Guess I’ll need to figure this out later.

3

Two suggestions:

  • Consider asking how to solve your problem (getting users to fill the in the field). The user wizard plugin might be a solution?

  • Move this to Development and ask there. I think that it might be possible with a theme component if the values are in serializer.

For either, change he subject to something like “how can I force users to fill in a custom field when it’s empty”

I don’t have a very good answer, though. :person_shrugging:

4

To that specific question, assuming that an unanswered question will be NULL in the database, you can just replace where.not(value: [nil]) with where(value: nil).

You can also use where(value: [nil, ""]), which is equivalent to WHERE (something.value IS NULL OR something.value = "") in SQL, to search for an empty string or NULL. I’m not sure which it’s likely to be or if it’s likely to change (from NULL to “”) if a user submits an empty field.

5

Thanks @pfaffman. I will follow your advice. :+1:

6

Thanks @Simon_Manning for this precision. That will help me a lot !

7

This plugin is great. Thanks @pfaffman

8

Thanks again guys. Custom wizard plugin works very well :+1: