Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 09/19/2020 in all areas

  1. The simplest solution I was able to come up with is to define the active segment as "" and refresh the button bar object after each button click.
    1 point
  2. The Microsoft OneDrive API can allow you to edit files without downloading and re-uploading to FileMaker. Integrate FileMaker with Microsoft OneDrive to store documents in the cloud and improve sharing while keeping your database lean and mean. Be sure to check out the full article: https://dbservices.com/articles/filemaker-onedrive-integration/ Includes free sample database and tutorial video dbservices.com
    1 point
  3. If it's important to have exactly 15 digits, then you should validate the field using a calculation = Length ( Filter ( Self ; "0123456789" ) ) = 15 In addition, you can use a script trigger to check the field before it is validated; this allows you to provide a nicer user experience compared to the built-in validation error message.
    1 point
  4. The question is not quite clear. If i am guessing correctly, you want to make the field auto-enter calculated value (replacing existing value) = Let ( digits = Filter ( Self ; "0123456789" ) ; Replace ( Replace ( Replace ( digits ; 15 ; 0 ; "-" ) ; 8 ; 0 ; "-" ) ; 4 ; 0 ; "-" ) ) This would allow you to enter the ID as digits only or already formatted and have the auto-entry re/format it to the pattern you show. The field itself should be of type Text, of course.
    1 point
  5. Here: Enter Find Mode [ ] Set Field [ Employees::DateOfBirth; «CALCULATION GOES HERE» ] Perform Find [ ] Not sure what you mean by that. Yesterday was not February 28 in a non-leap year.
    1 point
  6. If you intend to run this daily, then you need to make sure that if today is February 28 in a non-leap year, the search will find people born on February 28 as well as people born on February 29. That means setting the searched date field to something like: Let ( today = Get (CurrentDate) ; If ( DayOfYear ( today ) = 59 and Month ( today + 1 ) = 3 ; Substitute ( Date ( 11 ; 22 ; 3333 ) ; [ "11" ; "2" ] ; [ "22" ; "{28..29}" ] ; [ "3333" ; "*" ] ) ; Substitute ( today ; Year ( today ) ; "*" ) ) ) --- P.S. Do people still appreciate getting an automated birthday greeting?
    1 point
  7. Two side notes: 1. You can find people whose birthday is today, regardless of the date format in use, by: Enter Find Mode [ ] Set Field [ Employees::DateOfBirth; Substitute ( Get (CurrentDate) ; Year ( Get (CurrentDate) ) ; "*" ) ] Perform Find [ ] 2. If you run such script on a daily basis, you will miss people whose birthday falls on a weekend or holiday. In addition, people born on February 29 will be skipped in 3 out of 4 years.
    1 point
  8. Yes, I saw that. That's because your summary field is placed in a sub-summary by Item(I think?) part. What I suggested is to place it in a sub-summary by unit part. It also seems your summary field is defined as a running total, which makes no sense to me. --- If you want to show separate subtotals for each unit type in a higher sub-summary, consider the attached demo. SummarizeMultipleUnitsR.fmp12
    1 point
  9. This makes the assumption that the field "Birthday::C_Birthday" has a format of mm/dd/year: Allow User Abort [ Off ] Set Error Capture [ On ] Go to Layout [ Birthday List ] Set Variable [ $bdate_find; Value: Let ( [ ~bday = Day ( Get (CurrentDate)); ~bmonth = Month ( Get (CurrentDate)) ];~bmonth&"/"&~bday&"/*" ) ] Perform Find [ Specified Find Requests: Find Records; Criteria: Birthday::C_Birthday: “$bdate_find” ][ Restore ] If [ Get (LastError)=401 ] Exit Script [ ] Else Go to Record/Request/Page[ Firs
    1 point
  10. When you are writing a script that is intended to be performed on server, you might want to turn on the View > Compatibility > Server option. In addition, the help file has a compatibility chart for every script step, where you can check which products can execute the step, with what limitations. Neither Insert File nor Insert PDF are supported with FileMaker Server. As a workaround, you can use the Insert From URL step - see: https://fmforums.com/topic/106459-insert-from-url-to-insert-pdf-on-fm-server/
    1 point
  11. Hey Eric, The Rich Text Editor Addon by Claris uses HTML tags to create the rich text features, much like a WYSIWYG text editor (eg, QuillJS). If you look at the raw contents of the field you're editing with the addon, you'll see html tags everywhere you make any formatting changes. It's still entirely compatible with our Email Plugin, you would just want to make sure to switch the body-type from plaintext to html in any plugin calls. For instance, assuming you're using EmailSetBody to attach your body text while generating an e-mail, make sure to switch from the first step to th
    1 point
  12. Thank you!! after importing his custom functions, JSONGetElementDots ( $jsonFormatted ; "Global Quote.05\. price" ) worked!
    1 point
  13. You could use the Photo Gallery Add-on that was just released in FM19.1.2.219.
    1 point
  14. Thank you for the advice. I was able to get this to work now. It required me to change the format of my excel file that I was inputing the data from and create an "Inspection item" and assign an ID to each inspection item as well as tie it to each part number via a "part number ID". Once I changed how the data was input from my original excel file this worked like a charm. Thank you again
    1 point
  15. First, sort by the Item field (or whatever the field you want to group by is called). Then, in the 'Specify Field Order for Export', dialog, check the Group by [Item] option and add the Item field and the summary field to the field export order. At this point, the dialog will display: Now select the summary field only (leaving the 'sCount by Item' pseudo-field in place) and remove it from the field export order.
    1 point
  16. I don't see why you need the other checkbox. If someone is checked as Active, then clearly they are not Inactive - and vice versa. Having two objects display the same thing can only be confusing, IMHO. Still, if you want, you could simply use two buttons to toggle the active status and have them show the check mark conditionally - see the attached demo. MutuallyExclusiveCheck.fmp12
    1 point
  17. Perform Find [ Restore ] can only be used for literal text. Instead use: Enter Find Mode [ ] ... uncheck Pause Set Field [ ContactRShip::PatientID.fk ; $y ] Perform Find [ ] And, by the way, there is no need to find all records before performing a find ... a find searches all records. Neither is an unsort necessary first; for similar reasons. LaRetta :wink2:
    1 point
  18. Hi Jim, "On my main page of the db, I have a button attached to a script to open a popup window..." Start your script (which opens the popup window) with a Commit Records/Requests BEFORE opening the new window. What happens is that, if the User leaves their cursor in a field on the main layout, they retain possession of that record. This will stop modification in another window. Sometimes you WANT to maintain possession but usually not. So just consider where your User's cursor might be as you open various windows. LaRetta
    1 point
This leaderboard is set to Los Angeles/GMT-07:00
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.