army

I just tried creating separate dropdowns using this code: <select name="Combo" size=1 class="formtypesmall" > <option value="Combo"> - No Selection - [FMP-InlineAction: -db=collegelist.fp5, -lay=data, UCollege="C.T. Bauer College of Business", -find][FMP-Record] <option value="[FMP-Field:Combo]">[FMP-Field:Combo][/FMP-Record][/FMP-InlineAction] </select> -When I tried changing the drop down to allow multiple selections, it broke the code. People may contribute to more than one program in a college, so they need to be able to pick more than one. Do you know how to code that or have any other ideas? (here's the page so far) http://www.advancement.uh.edu/annualgiving/FMPro?-db=coll.fp5&-lay=data&-format=update2.htm&-view Thanks

I created a file named coll.fp5 with the field UCollege and has all the colleges. I related the files but I do not understand how you would write the code for the value list.

I want to create a form with a bunch of drop downs. There will be a dropdown list for each college, 30 of them. The drop down lists will show the different programs you can contribute money to. I want to have the drop down lists created from a related file so they are easy to update. Is there a way to combine the programs all into one database instead of having 30 different filemaker files? This would the perfect situation for a conditional dropdown, based on the college, but I could never figure out the javascript to make it work, so I am trying to find a simpler way to put the information on a form. I hope this makes sense, I'll attach my related file. Thanks. list.zip

Thanks Jeff, I can't wait to try it out!

That's realy cool! Did you use javascript to create the bar chart or can you do that with cdml?

Hi Steve, Yes, this sounds good, and I do want to keep it simple. Could you explain a little more about how you would design the database for the days/Time. And what do you need to do so duplicates are not allowed ? Thanks, Army

I think like this: http://xxx.xxx.xx.xx/FMPro?-db=Database.fp5&-lay=Web&-error=errors.htm&-OP=gte&TIME=[FMP-field: Afternoon]&-max=10&-format=list.htm

Does anyone have any suggestions on how to display a list of times and date you could sign up to use a room. It would show which times had not been signed up for yet, and would not allow you to sign up for times where it was already in use (like outlook does when you try to schedule a meeting)?

Thanks for the help Jeff!

Thanks Garry

I would like the current records to be checked and be the default, most people would only want to look at those. Right now when they select both, you get no matches found, which is not what the user would expect.

I am trying to create a field in a database called archive, where the user can check a record that is old. Then on the search page they can check the Search X-current records or X-archived records. If they click both then it should search both current & archived. I don't know how to code the check boxes so it will do search current & archived (it is just doing the or).

I have a file that has the date formatted dd/mm/yyyy, but I want the user to be able to enter the date mm/dd/yyyy from the web form. ( I tried changing the database to use system formats but it gave an 500 error when I tried submitting data from the web form this way). Got any ideas how to do this ?

Thanks Anatoli.

I appoligize for asking a non FileMaker question, but I don't know who to ask and figured you guys would have a suggestion. I am looking for a cheap web hosting service, for my personal use so that I can teach myself how to use MySQL with either PHP or ASP.