Miscellaneous Issues - Scroll Bars, Large Text Fields, Data Validation, Web View, Cumulative Stats
I am hoping this forum will be able to offer some advice as I put some polish on a large database project I'm finishing up. I've gotten the user interface mostly finished, and the underlying structure of the database is working great. I was never able to resolve the issue I had Two Tables, One Layout so the entire database has been redesigned to accomodate FileMaker's limitations, at the cost of reduced functionality and indexing.
Hopefully, the members of this forum will be able to help out with these final issues.
Problem #1 - Scroll Bars and Portals
I have a portal that pulls records from a related field. Everything is working well, except there is no scroll bar. All my other portals have scroll bars. It's still possible to scroll through records using the mouse wheel, but my users will be confused by the lack of a scroll bar. I've checked the boxes to "show vertical scroll bar" and "reset scroll bar when exiting record" under the Portal Setup window, but there still isn't a scroll bar. I've tried creating new portals and they don't have scroll bars either. What can I do to force a scroll bar to appear? Are there any tricks that I'm missing?
Problem #2 - Large Text Field
I have a large text container that is mostly free form data entry. What resources are available for formatting it? I can paste in bold text, different fonts, etc. from MS Word, but can I let users format text as they enter it? It would be great if they could bold, italicize, and underline text without changing the font. Also, more importantly, is there a way to display a vertical line from top to bottom? I know horizontal lines sometimes are displayed in other databases (like lined notebook paper). I'd like to display a vertical line 2.5 inches from the left of the field to remind users how far over to tab before entering certain lines of information.
Problem #3 - Time
Will FileMaker accept a time without the colon? My users are accustomed to typing four-number times. However, if 1500 is entered into FileMaker instead of 15:00, calculations don't work. I haven't found a workaround, but is FileMaker smart enough to convert 1500 into 15:00?
Problem #4 - Pulling data from web page
I've got a web view panel that displays the current weather forecast. It's incredibly useful to have that information available next to the data entry page. However, would it be possible to go a step further and automatically insert text from a web page into my text area? I can create a simple web page that extracts data from the full formatted site and returns a string. Would it be possible to take this text and append it to a large FileMaker text area? It would be great to press a button and have a string of data appended to one of my text areas.
Problem #5 - Cumulative Statistics
I'm trying to do some statistics on records, and am having trouble with cumulative and aggregate statistics.
Pie Chart - Right now, my pie chart has a separate slice for each record. I'm running it on a data field that pulls from a value list, and is strictly one of 4 options. The goal is to display a pie chart of the percentage of each option in the database. The field name is "Code" and for the Label Data settings, it is configured "MyTable::Code" and the value data is "ValueCount ( MyTable::Code )" I have the box "Show data points for groups of records when sorted" checked.
Bar Chart - Same deal, this time for days of the week. Each record has a date, and I need to view a bar graph of which days of the week have the most records.
I'd appreciate help with these issues. Thanks!