Search the Community
Showing results for tags 'fmp18'.
-
I have users on FM18 advanced. Have not upgraded since they use runtimes and 18 is the last version for which runtimes are available. I use the SMTP server for sending email and the process, which has worked for years, suddenly stopped working for their outlook accounts. It used to be that...
-
I have parent records and related children records. If I want to put, say, all the first names of the children into the parent I can use the List function. I want to put each name into a separate field in the parent record. Is there any way to do that? Thanks. Michael
-
FMS doesn't Find/Attach External FileMaker Data Source
gczychi posted a topic in FileMaker Server 18
I’m quite a bit puzzled: There is a FileMaker database A hosted on a FMS 18 (Mac mini), 10.13.0.10 Working with database A using a FM Pro client as well as running FMS Script Schedules (SSS) or Perform Script on Server (PSoS), everything works fine. Database A has an external FileMake... -
Hi. I found a post on this forum for the creation of a news ticker, and it works very well - thankyou to all those that made this possible. Can anybody please suggest what changes that could be made to it that would allow it to be a continuous loop of all items, rather than resetting after...
-
I have just experienced the Gray Menus of Death. All of my keyboard shortcuts are grayed out ... I can't even use the standard cut, copy, paste keyboard shortcuts. I was using Big Sur, so I upgraded to Monterey ... This upgrade did not solve the issue. It was on FM 18 Advanced, so I upgraded to FM 1...
-
I have a database of 185 records. The record numbers are currently in a text field 'record no', Indexed, Auto-enter Serial, Required Value and Unique. When I sort on record no, the order result is not serial but reads the first digit, so record no 3 is followed by record no 30, then 31, etc, 39 is...
-
As of this morning the following stopped working. I updated chrome (as the error message said) but it didn't make a difference. I'm using FM18. "http://local.google.com/maps?" & "q=" & /*Address=*/ Parents::Address & "," & /*City=*/ Parents::City & "," & /*State=*/ Parents::State & "," & /*Zip...
-
I am trying to help a friend, and don't have exact details at hand, but I'm hoping a description of the situation is enough to get clues which way to go. As far as I know he purchased FM Pro preinstalled on his Mac Mini. Recently there was an upgrade available. Apparently he renamed the ol...
-
Hello Mavens, I have a complex database and I have to export some of it into a spreadsheet. After some experimenting I created the right export order. Now I can reuse it and export from each record individually but now I'd like to automate it in the form of a script. Is there a way to sort of "...
-
Hi brains trust, I want to be able to create an Edit Box field where the field will "pop open" when selected, to show all it's contents (to a certain line limit), similarly to the Pop-up Menu but without a pre-entered value list. Is this possible? Thanks!
-
I am trying to merge two databases together. Because fields are in portal, no idea how to accomplish. Adding to Table LineItems layout is no problem. Both dBs have same fields, of which the below are relevant. (These are samples. Actual dB1 goes from year 2000 to 2021 with several thousand records a...
-
I've read to open my previous fmp5 files, I need to first get them to fmp7 format. I run FileMaker Pro 18 Advance currently on MacOS 10.15. I found site that says I can download Filemaker 11 <https://filemaker-pro-advanced.software.informer.com/11.0/> but will that not overwrite my current installa...
-
I have a old database that in the past I've turned into a runtime without issue. I think the last version of FM I used to make a runtime of this DB was v16. I've been trying to use FM 18.03 to gen the runtime this time. It's working fine on the runtime build process but when I run the runtime dat...
-
Fields: ACTIVE = YES value DATE STARTED DATE ENDED gDATE_TODAY = global Get(Current_Date) YEARS OF SERVICE (calculated result) If the ACTIVE field is "yes" then I want to see current YEARS OF SERVICE from today. Else, I want to see YEARS OF SERVICE from start to end...
-
I've never understood why the age of a forum post, in general, anywhere on the internet, about anything at all, matters with regard to anything besides it being a record of the date the post was made. I laugh when I see posters say things like "Sorry about commenting so late on this really old thre...
-
I have table A that has list of pharmacies with phone numbers addresses etc , linked to table B that has patient's info, from B I want to populate the chosen pharmacy of a patient from A through the relation, the pharmacy name in B is value list driven from A through the link, it does pull the list...
-
I added two container fields in my database. I put a picture in each and set it as global. Worked fine. Went to a second computer and opened the file and they're not there. Closed my file and reopened it and they're not there. I put them in originally with copy paste. Any idea what I'm missing? Than...
-
I was wondering if the following is possible and, if yes, how to do it. I have a parent/student database. I created a script where I can send an email with information from the parent record out to the parent. It works fine. I want to set off a script to choose certain records (like those that...
-
Here's a strange question. I have a parents table and a student table. I have a field in the student table that creates the student name concatenated with their grade. In the parent table I have a field that puts all the parents children and their grades in one line for a printout. I use the substit...
-
Hi, Where can I find the installer files for the Mac version of FileMaker 18 Server? All that's available on the Claris website now is version 19. Cheers
-
Is there a way to format a number into dollars and cents with dollar sign, not in the layout, but in the database or email message, where I ultimately need it? TIA