- Posts: 185
- Thank you received: 11
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Dynamically insert email into participants table captured from question
- bulgin
- Topic Author
- Offline
- Elite Member
We would like to send the participant a confirmation of survey taken email using the email address they give us as the first question in the survey.
Can expression manager or some other technique be used to take the email given in one question and input that into the participant's table email address for that participant?
Thank you.
- tpartner
- Offline
- LimeSurvey Community Team
- Posts: 10634
- Thank you received: 3698
Instead of using the confirmation mail, modify one of the notification mails and use the value of your "email" question in the "To" field - manual.limesurvey.org/Notifications_%26_..._notifications_email
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13935
- Thank you received: 2551
gitlab.com/SondagesPro/TokenManagement/updateTokenByResponsetpartner wrote: No, Expression Manager cannot modify the token table.
…
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
- tpartner
- Offline
- LimeSurvey Community Team
- Posts: 10634
- Thank you received: 3698
You can also use the API (I have often done this), but, again, not core functionality.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13935
- Thank you received: 2551
It usetpartner wrote: Yes, but that's not Expression Manger.
Yes .tpartner wrote: You can also use the API (I have often done this), but, again, not core functionality.
But : in my opionion : it must not be in core.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
- bulgin
- Topic Author
- Offline
- Elite Member
- Posts: 185
- Thank you received: 11
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13935
- Thank you received: 2551
Must test
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
- bulgin
- Topic Author
- Offline
- Elite Member
- Posts: 185
- Thank you received: 11
extensions.sondages.pro/about/install-an...-for-limesurvey.html
I just pull it into the plugin directory by changing into the plugin directory and doing:
sudo git clone gitlab.com/SondagesPro/TokenManagement/u...eTokenByResponse.git
then it's necessary to chown the directory and all files under that directory to the user of your apache or webserver ownership.
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13935
- Thank you received: 2551
Apache need only read access on this plugin .bulgin wrote: then it's necessary to chown the directory and all files under that directory to the user of your apache or webserver ownership.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
- bulgin
- Topic Author
- Offline
- Elite Member
- Posts: 185
- Thank you received: 11
Another way to do this without affecting core functionality would be to run a cron job that checks the lime_tokens table in mysql, attach a value to another field (emailsent) in that table say 0 for no email sent and 1 for email sent, then update that accordingly when the email entry is made into that table via the plugin, and take that value along with the URL that needs to be mailed, and send an email to the recipient and then set the emailsent value to 1.
Actually probably better to create a totally separate table and not interfere with the tokens table and do all the mysql'ing there.
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13935
- Thank you received: 2551
OK,bulgin wrote: My tests show that yes, this excellent plugin succeeds in entering the associated field into the participant's database, but after the email is already sent. And the email only get's sent if the admin template is used and it pulls the email from the input into the survey question, which does satisfy the mission.
…
Than you : please : can you report an issue gitlab.com/SondagesPro/TokenManagement/u...kenByResponse/issues
I search if i can fix it (but after doing the manual, the README and the config.xml … )
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.