REDCap Dynamic SQL Drop Down
586 views
Skip to first unread message
cl17
Jul 18, 2018, 9:44:10 AM7/18/18
to Lifespan Redcap Users
I have been trying to create a dynamic dropdrown field using a SQL select query. I’ve managed to successfully query the database to be able to create the dropdown field. If I do not use the repeating instrument feature, the dropdrown field works, when saving the option on a form.
The problem arises when I try to replicate the SQL select query create from a repeating instrument record. Creating a repeating instrument allows you to see the drugs record easily. Unfortunately, when trying to save the form, it defaults to the last option in the list.
Can anyone help with this?
The problem arises when I try to replicate the SQL select query create from a repeating instrument record. Creating a repeating instrument allows you to see the drugs record easily. Unfortunately, when trying to save the form, it defaults to the last option in the list.
Can anyone help with this?
Reply all
Reply to author
Forward
0 new messages