Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Multiple Checkbox Text Translation

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

58 Views

RSS

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

Looking for some help with Text Translation. I am building a form that will be used to create a Return to Work Letter. I have a section set up with the Statement "Restrictions only apply to the checked extremities: " followed by 4 separate check boxes for Left Arm, Left Leg, Right Arm and Right Leg. I did not use a listbox because I want the checkboxes to appear on one line horizontally so that it takes up less space on the form.

I want the text translation to appear as:

Restrictions only apply to these extremities: (list based on what boxes are checked separated by comma)

I have the translation working as expected with how I have it setup but would like it to leave off the comma after the last checked option.

So it would appear as

Restrictions only apply to these extremities: Left Arm, Right Arm

rather than

Restrictions only apply to these extremities: Left Arm,RightArm,

I am sure there is a better way to set up the text translation than what I have here:

{IF STR(DOCUMENT.LA,DOCUMENT.LL,DOCUMENT.RA,DOCUMENT.RL) == "" THEN "" ELSE CFMT("

Restrictions only apply to these extremities: ", "B") + (IF DOCUMENT.LA <> "" THEN DOCUMENT.LA + "," ELSE "" ENDIF) + (IF DOCUMENT.LL <> "" THEN DOCUMENT.LL + "," ELSE "" ENDIF) + (IF DOCUMENT.RA <> "" THEN DOCUMENT.RA + "," ELSE "" ENDIF) + (IF DOCUMENT.RL <> "" THEN DOCUMENT.RL + "," ELSE "" ENDIF) + HRET ENDIF}

Posted : February 27, 2018 2:52 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

you really just need a space after your commas.

IF DOCUMENT.LA “” THEN DOCUMENT.LA + “,” ELSE “” ENDIF) + (IF DOCUMENT.LL “” THEN DOCUMENT.LL + “, ” ELSE “” ENDIF) + (IF DOCUMENT.RA “” THEN DOCUMENT.RA + “, ” ELSE “” ENDIF) + (IF DOCUMENT.RL “” THEN DOCUMENT.RL + “, ” ELSE “” ENDIF)

Posted : February 27, 2018 3:14 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

you can also use this

/*Function to add commas and and to multiple selections*/
{fn CombineLastAnd()
{
local nargs = GETNARGS()
local delim
local result = ""
local index
local arg
if nargs>0 then
delim = GETARG(1)
for index = 2, index <= nargs, index = index + 1 do
arg = GETARG(index)
if arg"" then
if result"" then
if index = nargs then
result = result + " and " + STR(arg)
else
result = result + STR(delim) + STR(arg)
endif
else
result = STR(arg)
endif
endif
endfor
endif
return STR(result)
}
}

Posted : February 27, 2018 3:16 am

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

I do need to add spaces after the comma's and I realized that as I was posting this but forgot to make the changes. However, that would not get rid of the comma that populates after the last checked option. I will try out the function that you posted. Thanks for your feedback!

Posted : February 27, 2018 3:25 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

let me know how it works out

Posted : February 27, 2018 4:23 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0