News | FileMaker Community

Keep Calculation Field or auto-enter calculation as minimum as possible?

Hi, I am new to filemaker. I have read few chapters of Database Design for Mere Mortals. The author told me not to use calculation field in a table. I guess what he means we could calculate the value in VIEWS or write query to display the result so it is not a must to include a formula in a field. When we apply to filemaker, should we

Like Show 1 Like1 10

jlhfbo in Discussions23 hours ago

Turn number into a writted word for printing checks

This is driving me crazy. Using the field [CalcWrittenNumberA] for numerical input, everything is flawless in calculating the written number EXCEPT when the number has 00. (i.e. 100.00, 1,000.00, 12,000.00, 123, 000.00, ect). [and] shoule be inserted (which it is) except when there are no [hundreads]. I know where the problem is but just

Like Show 0 Likes0 9

Top & Trending

user24799 in Discussions4 days ago

Does a FMS17 10 user license = 10 concurrent WebDirect connections?

I have a client that will only be accessing their server via WebDirect. Does this mean that they can have 100 traveling sales people that could log in an out of the server via a web browser so long as there were only 10 concurrent connections? If no, how does the server keep track of WebDirect users? If yes, what happens if an 11th

Like Show 0 Likes0 31

Top & Trending

donl1150 in Discussions8 hours ago

Delete one cell with input in another cell?

Can I delete the contents of one cell when I input data into a different cell? See the attached.

Like Show 0 Likes0 17

Top & Trending

zelator in Discussions2 days ago

Is there a way to convert a FM database with only one table to a relational database

I have a FM database I've been using since FM7 with only one table and I would like to convert it to a relational database. I would need also to assign multiple records in the database to a single customer ID and create a portal showing all the records for that customer.

Like Show 0 Likes0 17