Can Acrobat Pro create a simple look-up form?

SzczerbiakManiac · 02-09-2012, 03:24 PM

I'd like to configure a very long list of items (over 200) which could be selected from a drop-down and have it tell me what category the item belongs to. Here’s a simple example of the type of list I have:

Code:

Item		Category
Apple		Fruit
Banana		Fruit
Carrot		Vegetable
Durian		Fruit
Eggplant	Vegetable

I'd like to have a drop-down list with all the Items in it and after selecting one, have it tell me if it’s a fruit or vegetable.

Does that make sense?
Is it possible?

blueerica · 02-10-2012, 09:23 AM

Hmmm, I have really only used forms for collecting information from people, not taking information and applying a formula-slash-sorting it, which seems to me to be almost an Excel-type of thing.

I have a couple of people I could ask around work to see if they have an idea of what to do.

SzczerbiakManiac · 03-01-2012, 12:26 PM

If Acrobat can't do the job, does anyone know of an inexpensive (or free!) web-based solution?

Ghoulish Delight · 03-01-2012, 12:27 PM

Google doc spreadsheet?

SzczerbiakManiac · 03-01-2012, 12:58 PM

The job has become more complicated since I originally posted it. Now it it needs to be able to do multiple queries, so think it will have to be some kind of database. The source data will look something like this (though a LOT more detailed):

Code:

Item		Category	Seeds		Color		Finish	
Apple		Fruit		yes		red		glossy
Banana		Fruit		no		yellow		matte
Carrot		Vegetable	no		orange		matte
Durian		Fruit		yes		brown		matte
Eggplant	Vegetable	no		purple		glossy

The user would need to be able to say something like, show me all the glossy fruits with no seeds.

I'm in over my head...

Ghoulish Delight · 03-01-2012, 02:13 PM

Base (OpenOffice).

SzczerbiakManiac · 03-01-2012, 02:24 PM

And I can "publish" (for lack of a better term) the database to the web and let people do their queries without installing additional software?

Gn2Dlnd · 03-05-2012, 11:12 AM

I now know more about durian than I used to.

SzczerbiakManiac · 03-05-2012, 11:40 AM

As long as you never inhale near one, you'll be okay.

Alex · 03-05-2012, 02:48 PM

Durian is an example where my nasal defenses are valuable (I am not a super smeller and my nose acclimates to strong odors quickly, which made some organic chemistry labs difficult).

It was very pungent when first cut but, for me, that didn't last and while it wasn't something that tasted good enough for me to ever seek out, I didn't think it was awful tasting.

This was at an outdoor food stall in Singapore. Indoor experiences would probably be different.

02-09-2012, 03:24 PM	#1
SzczerbiakManiac "ZER-bee-ak" Join Date: Jan 2005 Posts: 4,409	Can Acrobat Pro create a simple look-up form? I'd like to configure a very long list of items (over 200) which could be selected from a drop-down and have it tell me what category the item belongs to. Here’s a simple example of the type of list I have: Code: Item Category Apple Fruit Banana Fruit Carrot Vegetable Durian Fruit Eggplant Vegetable I'd like to have a drop-down list with all the Items in it and after selecting one, have it tell me if it’s a fruit or vegetable. Does that make sense? Is it possible? __________________
	Submit to Quotes

02-10-2012, 09:23 AM	#2
blueerica Nueve Join Date: Jan 2005 Posts: 6,497	Hmmm, I have really only used forms for collecting information from people, not taking information and applying a formula-slash-sorting it, which seems to me to be almost an Excel-type of thing. I have a couple of people I could ask around work to see if they have an idea of what to do. __________________ Tomorrow is the day for you and me
	Submit to Quotes

03-01-2012, 12:26 PM	#3
SzczerbiakManiac "ZER-bee-ak" Join Date: Jan 2005 Posts: 4,409	If Acrobat can't do the job, does anyone know of an inexpensive (or free!) web-based solution? __________________
	Submit to Quotes

03-01-2012, 12:27 PM	#4
Ghoulish Delight I Floop the Pig Join Date: Jan 2005 Location: Alternative Swankstyle Posts: 19,348	Google doc spreadsheet? __________________ 'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ
	Submit to Quotes

03-01-2012, 12:58 PM	#5
SzczerbiakManiac "ZER-bee-ak" Join Date: Jan 2005 Posts: 4,409	The job has become more complicated since I originally posted it. Now it it needs to be able to do multiple queries, so think it will have to be some kind of database. The source data will look something like this (though a LOT more detailed): Code: Item Category Seeds Color Finish Apple Fruit yes red glossy Banana Fruit no yellow matte Carrot Vegetable no orange matte Durian Fruit yes brown matte Eggplant Vegetable no purple glossy The user would need to be able to say something like, show me all the glossy fruits with no seeds. I'm in over my head... __________________
	Submit to Quotes

03-01-2012, 02:13 PM	#6
Ghoulish Delight I Floop the Pig Join Date: Jan 2005 Location: Alternative Swankstyle Posts: 19,348	Base (OpenOffice). __________________ 'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ
	Submit to Quotes

03-01-2012, 02:24 PM	#7
SzczerbiakManiac "ZER-bee-ak" Join Date: Jan 2005 Posts: 4,409	And I can "publish" (for lack of a better term) the database to the web and let people do their queries without installing additional software? __________________
	Submit to Quotes

03-05-2012, 11:12 AM	#8
Gn2Dlnd Parmmadore Jim Join Date: Jan 2005 Location: Casita del Queso Posts: 3,810	I now know more about durian than I used to. __________________ Does anyone still wear a hat?
	Submit to Quotes

03-05-2012, 11:40 AM	#9
SzczerbiakManiac "ZER-bee-ak" Join Date: Jan 2005 Posts: 4,409	As long as you never inhale near one, you'll be okay. __________________
	Submit to Quotes

03-05-2012, 02:48 PM	#10
Alex . Join Date: Feb 2005 Posts: 13,354	Durian is an example where my nasal defenses are valuable (I am not a super smeller and my nose acclimates to strong odors quickly, which made some organic chemistry labs difficult). It was very pungent when first cut but, for me, that didn't last and while it wasn't something that tasted good enough for me to ever seek out, I didn't think it was awful tasting. This was at an outdoor food stall in Singapore. Indoor experiences would probably be different.
	Submit to Quotes