Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Link to section #2

Closed
garcianna opened this issue Feb 20, 2023 · 1 comment
Closed

Link to section #2

garcianna opened this issue Feb 20, 2023 · 1 comment
Assignees

Comments

@garcianna
Copy link

Link to section

I find it interesting to be able to include in the query file the link to the field to be modified. In this way the center will be able to access more efficiently.

Any section of a REDCap project have REDCap version, project id, event id and record id
https://redcap.fls-rs.com/redcap_v**13.3.0**/DataEntry/record_home.php?pid=**929**&arm=1&id=**1**

#PYTHON sintax
#To add the links to the IDs cell.value=1

for sheet in wb:
if sheet['B2'].value == 'record_id':
sheet['B1'].value = sheet['A1'].value
sheet.delete_cols(idx=1, amount=1)
colC = sheet['A']
for row in sheet:
for cell in colC:
cell.hyperlink = "https://redcap.fls-rs.com/redcap_v13.3.0/DataEntry/record_home.php?pid=929&arm=1&id=" + str(cell.value)
cell.style = "Hyperlink"

@jcarmezim
Copy link
Collaborator

jcarmezim commented Feb 24, 2023

Dear Anna,
First of all, thank you very much for your input.
Your idea seems very interesting. We will explore how to incorporate this to the function as we have to take in account that every institution and every project has its own link. Our first thought is to create a new argument that will let you input this specific link.

Best regards.

jcarmezim added a commit that referenced this issue Mar 3, 2023
- New _link_ argument of the functions _rd_query()_ and _rd_event()_ to generate the link where the query can be found in REDCap. [Solves Issue #2 in github]

- Bug resolved in the summary of queries, when the data did not present events (non-longitudinal projects).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants