Support

    You are here:  
  1. Home
  2. Support
  3. Already checked checkbox for new & existing users
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (11)

Resolved Already checked checkbox for new & existing users

  1. cgeorge
    cgeorge
  2. Support
  3. Tuesday, October 26 2021, 12:15 PM
Dear JSN Project team,

I try to integrate a new checkbox that should already be checked ad default (and should also be checked by default for the existing users). Unfortunately it doesn`t work with following values:

Field type: checkbox
standard value: 0
options: 0|25.06.2022 FRANKFURT

Am I doing something wrong?
Best regards and thanks in advance, Christopher
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
please try with this query to fill field of existing users:
UPDATE #__jsn_users SET anmeldung_erfolgreich_fuer=' ["1"]' WHERE anmeldung_erfolgreich_fuer <> '' OR anmeldung_erfolgreich_fuer IS NULL
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (11)
admin
admin Accepted Answer
Admin
Hi,
try to use another value instead "0", for checkboxes the 0 value can be intended as empty.
  1. more than a month ago
  2. Support
  3. # 1
cgeorge
cgeorge Accepted Answer
I tried, but unfortunately it doesn`t work - it`s still unchecked -
Field type: checkbox
standard value: 1
options:1|25.06.2022 FRANKFURT
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
Can you please post me your registration link to check this?
  1. more than a month ago
  2. Support
  3. # 3
cgeorge
cgeorge Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 4
cgeorge
cgeorge Accepted Answer
here we go...
  1. more than a month ago
  2. Support
  3. # 5
admin
admin Accepted Answer
Admin
Hi,
Hi, the checkbox is only shown in user profiles, not in the registration process. I could give you admin access to the site if you want.
The default value only for registration process. If you want to fill the field for all existing users then you may think to fill user via SQL query like this 
UPDATE #__jsn_users SET anmeldung_erfolgreich_fuer=' ["1"]' WHERE anmeldung_erfolgreich_fuer <> ''


NOTE: the checkbox allow you multiple values, so the stored value is in JSON mode; ["1"] mean value 1, for multiple value you can use a value like ["1","2","3"]
  1. more than a month ago
  2. Support
  3. # 6
cgeorge
cgeorge Accepted Answer
Thank you!
  1. more than a month ago
  2. Support
  3. # 7
cgeorge
cgeorge Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 8
cgeorge
cgeorge Accepted Answer
hereby the screenshots
  1. more than a month ago
  2. Support
  3. # 9
cgeorge
cgeorge Accepted Answer
Content Protected
  1. more than a month ago
  2. Support
  3. # 10
cgeorge
cgeorge Accepted Answer
That worked! Thank you very much!!
  1. more than a month ago
  2. Support
  3. # 11
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Request Support

Support is currently Online
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.