How to submit data from CheckBox and then retrieve it?

[polarbearcus]

Greetings,

What dataType am I suppose to submit my checkbox to? and What TYPE should my checkbox be? Currently I have around 10 choices of a checkbox. So What i want to achieve is to be able to retrieve what the user chooses.

To explain in further detail, lets say the user checks choices 1,5,10. How can I save this data and retrieve it later to show that the user clicked 1,5,10?

Cheers,
Polarbearcus

[mikeallenbrown]

Re: How to submit data from CheckBox and then retrieve it?

SQL backend? ...In my UX's I use INT datatype in SQL, make the checkbox numeric, and then check "treat field as a logical field".

ScreenShot_2014.12.08_001_.png

[Steve Wood]

Re: How to submit data from CheckBox and then retrieve it?

If your checkbox has multiple options, then the target field has to be a character field large enough to hold ALL selections plus 1 character for each (for the comma), and the results will be stored as "1,2,5" or "North,South,West", etc. How you extract the value from that is hardly documented, but it is the .dump() function. This method works for both multi-select checkboxes and mult-select dropdowns. The exact syntax depends on whether you are using a UX or Grid:

Grid Example - Did they select a specific value? This line looks at a Search Field named sceName to see if the value "CRD" was selected:
if is_one_of("CRD",e.SearchDataSubmitted.sceName.dump()) = .t.
<do something>
end if

UX example - Another method to see if the field includes a value. This gets all the values from service_request, converts from CRLF to comma and then looks for the value "DA":
dim service_req as c = crlf_to_comma(e.dataSubmitted.service_req.dump())
if inlist2("DA",service_req)=.f.
<do something>
end if

Get all values and run through each:
dim service_req as c = e.dataSubmitted.service_req.dump()
for each foo in service_req
<do something>
next

[polarbearcus]

Re: How to submit data from CheckBox and then retrieve it?

SQL backend? ...In my UX's I use INT datatype in SQL, make the checkbox numeric, and then check "treat field as a logical field".

[ATTACH=CONFIG]39336[/ATTACH]

Thank you for using your time to reply! But I'm looking for the solution for a multi-select checkbox! Thank you!

[polarbearcus]

Re: How to submit data from CheckBox and then retrieve it?

If your checkbox has multiple options, then the target field has to be a character field large enough to hold ALL selections plus 1 character for each (for the comma), and the results will be stored as "1,2,5" or "North,South,West", etc. How you extract the value from that is hardly documented, but it is the .dump() function. This method works for both multi-select checkboxes and mult-select dropdowns. The exact syntax depends on whether you are using a UX or Grid:

Grid Example - Did they select a specific value? This line looks at a Search Field named sceName to see if the value "CRD" was selected:
if is_one_of("CRD",e.SearchDataSubmitted.sceName.dump()) = .t.
<do something>
end if

UX example - Another method to see if the field includes a value. This gets all the values from service_request, converts from CRLF to comma and then looks for the value "DA":
dim service_req as c = crlf_to_comma(e.dataSubmitted.service_req.dump())
if inlist2("DA",service_req)=.f.
<do something>
end if

Get all values and run through each:
dim service_req as c = e.dataSubmitted.service_req.dump()
for each foo in service_req
<do something>
next

Thank you so much for understanding and using your precious time to reply this thread. What am I suppose to insert in the "<do something>" you have stated?

[Steve Wood]

Re: How to submit data from CheckBox and then retrieve it?

You didn't say what you wanted to do with the retrieved values, just that you wanted to get them. What do you want to do with those retrieved values?

[polarbearcus]

Re: How to submit data from CheckBox and then retrieve it?

So the checklist values are stored in the SQL database table right?

My list data source type is connected to that SQL database table. So right now when i tap on that particular row with the values, it would populate unbounded controls from the table.

How do i do this? do i just simply {dialog.object}.runAction("populateControls"); in the <do something> stated above?

Thank you so much for using your time to reply.