multiple lookup values for 1 field...memo field?

[hov333]

Hi all,

I'm looking for a way to provide the user with a checklist of options, which upon checking will copy that value into a field. My challenge is that I need to be able to send the values of more than 1 checkbox/choice into that field (not a typical look-up which only replaces the field with the look-up).

Seems that variables may come into play here, but any light shed on this topic will be much appreciated.

Thanks!

[Keith Hubert]

Re: multiple lookup values for 1 field...memo field?

Hi John,

Seems that variables may come into play here

Yep, you got that one right.

Need more info about your app and how you want to use the values from the variable/s.

[Peter.Greulich]

Re: multiple lookup values for 1 field...memo field?

Look at the ui_get_list..() functions. Several of them allow you to collect multiple items in your lookup which get put into a crlf() string. You can then dump the string into your memo field.

[Stan Mathews]

Re: multiple lookup values for 1 field...memo field?

You might consider displaying an xdialog with a multi select list box.

[hov333]

Re: multiple lookup values for 1 field...memo field?

thanks guys, yes I'm looking into displaying an X-dialog with multi select list box.

Basically I want to have different "actions" choices:

cleaned
replaced components
tested
etc

So say the user checks off "cleaned" and replaced components.

I want my action field to display: cleaned, replaced components. Essentially I want the actions to be pre-set, not user typed. But it would also be nice to be able to have the option to type in a "custom action" in case there is an extraordinary case for which the action is not listed.

[Stan Mathews]

Re: multiple lookup values for 1 field...memo field?

Sorry, is there a question there?

[hov333]

Re: multiple lookup values for 1 field...memo field?

not really, just replying to Keith's post.

Aside from that, do I need to make my "action" field a memo field to do this?

[Peter.Greulich]

Re: multiple lookup values for 1 field...memo field?

Aside from that, do I need to make my "action" field a memo field to do this?

Nope.

[MikeC]

Re: multiple lookup values for 1 field...memo field?

John,

do I need to make my "action" field a memo field

This would be contingent upon whether all the choices combined would exceed a character limit of 255, how you want to display or use the choices, or....? Most likely a memo field though I would think---you will have to add either a comma or crlf between each entry though when writing to whichever field type you want to use in order to distinguish the entries.

[hov333]

Re: multiple lookup values for 1 field...memo field?

John,

This would be contingent upon whether all the choices combined would exceed a character limit of 255, how you want to display or use the choices, or....? Most likely a memo field though I would think---you will have to add either a comma or crlf between each entry though when writing to whichever field type you want to use in order to distinguish the entries.

I don't think I would exceed the 255 limit since my choices will be very short. But you do have a good point about the comma between each entry.

Would someone be able to upload an example they created using x-dialog choices. I'm curious as to how this would work.

[Keith Hubert]

Re: multiple lookup values for 1 field...memo field?

Hi John,

Check out the choices of dialog boxes in Action Scripts.

[Stan Mathews]

Re: multiple lookup values for 1 field...memo field?

The genie makes the definition of the xdialog about as simple as possible.

[hov333]

Re: multiple lookup values for 1 field...memo field?

Thanks folks,
I've been swamped with office tasks, haven't had a minute to look at the xdialog. I'll let you guys know how it goes!

[Mike Wilson]

Re: multiple lookup values for 1 field...memo field?

Is this something like you want? This is an xdialog example. Just cut and paste this code into the Interactive Window, highlight all and run.

'make the list for the multiselect
dim vLactions as C
vLactions=<<%a%
Cleaned
Replaced components
Tested
Rotated
Painted
Oil and Lube
%a%

'generate the xDialog ===================

	' dialog structure variables
	dim dlg_title as C="Action"
	dim dlg_body as C

	'dialog field variables
	dim vLpicks as C
	dim vwrite_in as C
	dim vall_acts as C
	
	dlg_body = <<%dlg%
	{background=#155,175,165}{xmargin=2,2}
	{font=Arial,9,b}{frame=1,1:Multiple Choice Actions}{font=Arial,9,n}
	{region}
	[%m%.30,8vLpicks^#vLactions];
	{lf};
	{endregion};
	{font=Arial,9,b}{frame=1,1:Write in Extras}{font=Arial,9,n}
	{region}
	[.40vwrite_in]  ;
	{endregion};
	{lf};
	{line=1,0}
	{lf};
	<10OK> <10Cancel>
	{endregion};
	%dlg%
	
	'build dialog
	dim vresult as C 
	vresult=ui_dlg_box(dlg_title,dlg_body)
		if vresult="cancel"
			end 
		end if
	
	'combine the multiselect and the write in
	vall_acts=crlf_to_comma(vLpicks)+","+alltrim(vwrite_in)
	
	'report the result
	ui_modeless_dlg_box("report",<<%dlg%
	{background=light yellow}{font=Arial,10,b}{nocaption}
	{lf};
	{Text=60,3vall_acts};
	{lf};
	%dlg%)
	sleep(3)
	ui_modeless_dlg_close("report")

[hov333]

Re: multiple lookup values for 1 field...memo field?

hey guys,
thanks for all the help so far. And mike, thanks for posting this.
I actually just finished created the xdialog window with check boxes. Here is the xbasic code:

'Create an XDialog dialog box to prompt for parameters.
DIM SHARED Actions as C
DIM SHARED varC_result as C
auto_list_Actions = table.external_record_content_get("repair actions","Repair_Action","","")

temp_count = w_count(auto_list_Actions,crlf())
DELETE a_Actions
DIM a_Actions[temp_count] as c
a_Actions.initialize(auto_list_Actions)
ok_button_label = "&OK"
cancel_button_label = "&Cancel"
varC_result = ui_dlg_box("Actions",<<%dlg%
{region}
{Region}
;
{Endregion};
{Region}
Select repair actions:| [.100,10Actions^$$a_Actions];
{Endregion};
{Region}
;
{Endregion};
{line=1,0};
<*15=ok_button_label!OK> <15=cancel_button_label!CANCEL>;
{endregion};
%dlg%)

Could someone help me by adding the code that Mike has which allows the user to add additional comments/action manually. Its at the bottom of Mike's dialog box, I would love to have that in addition to what I made.

One more questions: after creating the xdialog, how do I get my options to be transferred into my action field? Right now the dialog pops up when the user Arrives onto the action field in my form. Upon selecting and hitting OK I would like those selections to be copied to the action field.

Thanks!