Recalculate Calculated Fields

[obregos]

Add the ability to recalculate calculated fields like the redcapDM package: https://cran.r-project.org/web/packages/REDCapDM/vignettes/REDCapDM.html#data-transformation

[spgarbet]

This looks interesting. I know that Jubilee was working on something similar. I will ask him about his progress.

[obregos]

Recalculation strategy from redcapDM:

Recalculation of REDCap calculated fields: it finds all the calculated fields and recalculates them using the REDCap logic specified in the calculation field translated into R. The recalculated variable is saved as the original name adding ’_recalc’ at the end. It can happen that the logic found contains some specific smart-variables or other complex structures which the function is not able to transcribe. With the summary found in results we can see how many calculated fields have been found, if they have been transcribed and, if that is the case, if the recalculated variable is equal to the original one.
Note: If the REDCap project is longitudinal and the event-form is not specified, this step will not be executed.

In the example, we can see how there are two REDCap calculated fields, both have been transcribed successfully and the recalculation of the age does not match the original calculated variable from REDCap.

Ideally, this enhancement will:

1. Be able to find all the calculated fields and recalculate them using the REDCap logic specified in the calculation field translated into R. The recalculated variable should be saved as the original name adding ‘_recalc’ at the end. (or something similar)
2. Be able to see how many calculated fields have been found, if their calculation logic has been transcribed and, if so, see if the recalculated variable is equal to the original one.

[spgarbet]

I read through their code and the REDCap specification. I think their approach is good, but we should see if it can be driven by a table.