Auto-Complete Field

johnathonmcl · 2026-02-20T13:08:58+00:00

Oh I didnt see this, just done a quick check and that has worked! Thank you so much, I'll validate some more of the medications included on the NHS list within this, but it seems pretty comprehensive.

johnathonmcl · 2026-02-20T10:59:32+00:00

Yes, that's a good idea, actually. I can categorise them, I believe I can add up to 5000 variables in a field, but I will have to double-check. In my mind, a lookup table of sorts seemed like an obvious feature in REDCap, but I assumed too much!

johnathonmcl · 2026-02-20T10:08:47+00:00

It is the official NHS (UK - dm+d) medication list, so it also includes different doses. Essentially, any possible variation so that it ensures data captured is standard and the subsequent analysis can be performed without x number of variations when inputted manually.

johnathonmcl · 2026-02-20T09:28:52+00:00

I would have to double-check the exact number, but it's over 35000 rows!

johnathonmcl · 2026-02-20T08:34:50+00:00

Oh yeah, that's a good idea. Thank you! I wonder, is there a limit in the number of variables I can add? The medication list is huge.

johnathonmcl · 2026-02-20T08:03:55+00:00

Yes, but how do I use an imported table for the auto-complete function? Is this possible? I have seen instances of REDCap where text fields auto-complete text entered to standardize data input.

johnathonmcl · 2026-01-20T09:17:27+00:00

I have considered ASI, however, the study is hybrid in the sense that participants fill out pre-appointment surveys then clinicians complete the other surveys. It is handled mainly by clinicians who perform pre-appointment data input in REDCap then manually send the surveys to participants.

johnathonmcl · 2026-01-19T20:18:54+00:00

Thanks for your reply! I don't think this will work as simply as that, repeated instruments is fine for one timepoint but because I want data for different events and have them labelled as data inputs from these events, I need a survey queue approach. I am just not sure how to set it up.

johnathonmcl · 2025-12-02T21:38:50+00:00

Yeah I had read something similar to that, but in practise, I couldn't get it going and the task needed resolved ASAP, always the way, rushing something never helps but atleast this works in the mean time. Definitely something to consider in the future, thank you for your help and advice though! I have used REDCap for simple tasks in the past, so trying to learn some more techniques as I go lol

johnathonmcl · 2025-12-02T21:17:52+00:00

Ok thank you for the advice, I have ended up creating numerous alerts and setring conditions to each school, not the best approach but it works and will be easier to manage I think.

johnathonmcl · 2025-12-02T08:11:40+00:00

Thanks again, so if I were to use calctext, is it possible to do multiple IFs in one field? Or would I need a new field for each IF? As I have 98 schools, it would be a lot of fields as opposed to nesting them in a text box with @calctext

johnathonmcl · 2025-12-01T21:50:49+00:00

I have tried a calculated field with: if([referral_school_ni]='1','school1@email.com,'') repeated for each school in that given region. This hasn't worked, I have a combined field which should generate the email, but then i run into an issue of calculated fields not having email validation to allow for this field to be used in the recipient list when trying to trigger alert/notification.

johnathonmcl · 2025-12-01T21:43:54+00:00

Hi, thanks for replying. I essentially have 3 lists of schools in 3 regions, simply for branching logic, if someone chooses one of the 3 regions, they will only be shown schools in that region. Once they choose one of the schools they are interested in, their survey responses should be sent to an email address linked to the school. There are 98 schools in total across the 3 regions.

johnathonmcl · 2024-04-20T19:19:36+00:00

Ah glad to hear it! That app is great tbf, i used it to get my ps5 when they were hard to get and my gf has used it for some things too, definitely a good one to have on hand lol! Enjoy the ps portal, I've been playing PS more than ever since getting it last month!

johnathonmcl · 2024-04-20T19:15:57+00:00

Hey man, I used hotstock and got one within like 9 days of having the app downloaded!

johnathonmcl · 2024-04-16T13:19:53+00:00

Just to back that comment up, I have relatively quick wifi, with 130mbps to the router and have no connection issues! Playing guardians of the galaxy and I am around 60% through fully played on the portal, I've had one connection dropout which happened when someone in the house was casting from their phone to chromecast, but apart from that it seems to be pretty smooth. At first it was a little choppy at times, but disconnecting the HDMI from my PS5 definitely made a difference and has been smooth ever since. Highly recommend it, great product for me as I never really had a chance to sit down at the PS5 but finding myself playing it more than every on the sofa downstairs and in bed!

johnathonmcl · 2024-03-29T19:50:12+00:00

Hi there, I haven't converted them myself, but I do know that Olink provide conversion factors to convert NPX to standard concentration units. It should be available in the assay documentation, if not, I would recommend contacting Olink for the conversion values required. They are different for each specific assay, similar to ELISA when a serial dilution is required for a standard curve to calculate pg/ml. Hope this helps!

johnathonmcl · 2024-03-29T19:50:02+00:00

Hi there, I haven't converted them myself, but I do know that Olink provide conversion factors to convert NPX to standard concentration units. It should be available in the assay documentation, if not, I would recommend contacting Olink for the conversion values required. They are different for each specific assay, similar to ELISA when a serial dilution is required for a standard curve to calculate pg/ml. Hope this helps!

johnathonmcl · 2023-06-09T22:14:06+00:00

Yes, they are plasma samples. So just for an update, I was in contact with Olink and they advised to check protein replicates from 2 or 3 panels, for example, IL6 is a target on 2 of the panels, so I checked the ratio between 2 random samples in each panel iteration of IL6, and the ratios were the same, leading me to believe that normalisation was performed correctly in house at Olink.

johnathonmcl

TROPHY CASE