• Content count

  • Joined

  • Last visited

  • Days Won


rwoods last won the day on November 11 2016

rwoods had the most liked content!

Community Reputation

7 Neutral

About rwoods

  • Rank
  • Birthday 07/09/1973

Profile Information

  • Gender
  • Location
    Nottingham, UK

Contact Methods

  • Website URL

FIleMaker Profile

  • Profile Updated
  • FM Application
    15 Advanced
  • Platform
    Mac OS Sierra
  • Skill Level
  • Certification
  • Membership
    FIleMaker Platinum Member
  • Title

Recent Profile Visitors

1,551 profile views
  1. Hi Freesia I'm sure the idea is that you learn how to do it yourself, rather than getting someone else to do it for you (at least that's how I remember school, though it was 28 years ago!) If you have the start of a database then we could give you some guidance on the last few steps if you have given it a go. You could post the database here. I'd start with just one table, with maybe an primary key (ID), a date field for the invoice date, and a value (number) field for the invoice value. You could then add a simple script that does a find on a date range, and then sorts the results.
  2. Hi Adrian You can't have two column portals I'm afraid, and it would be fairly complex to achieve that. I would suggest working with the single column, and just add a vertical scroll bar to the portal, and make each row smaller. You could duplicate the portal and do something crude like filter the first portal to show only people who's surname begins A-M, and the second portal to show N-Z. I've enclosed an example of that. Checksys.fmp12
  3. Hi Adrian I tweaked your file to give it the functionality you are after. One way of doing it is to have a table of 'Staff', and that need to be related in some way to your 'Menu' table with the global where you select staff names. Have a look for the following in the enclosed file :- New Staff Table Two relationships from the 'Menu' table to that staff table. One that matches whatever you have selected in the global popup menu, and one that shows all staff (using a cartesian join) Changed your value list to show the list of all staff in the staff table Added a new script that toggles whether a staff member is in or out Replaced your two buttons with one, that changes it's meaning, text and colour depending on whether the chosen staff member is in or out Added a portal to your 'Status' tab to show all staff and their current status. Hope it helps move you along! Checksys.fmp12
  4. Hello You could get the values from your value list using GetValueListItems and then go through a loop creating new records and taking the next value from the list of values to set for each new record. This way, it would be more flexible in the future as you could just change the value list if your appointment slots changed, and the script would continue to work without modification. I've done a little sample file to show you what I mean. Try running the script within, and it will create new records from the value list. Value
  5. Hello When your customers raise a new ticket some PHP is being executed which creates the corresponding record in your FileMaker database. The easiest thing to do to send your customer an email at this time would be to add a few lines of PHP code that runs a FileMaker script, which sends the email using the built-in SMTP features of FileMaker Server. The PHP code would look something like :- $appointmentID = "123456"; // you would get this from the context of your PHP to this point $layoutName = 'SendEmailLayout'; // a valid layout name in your database which your script would run from the context of $scriptName = 'SendEmailScript'; // the name of your FileMaker script that sends an email when on the layout named above $arguementToPass = $appointmentID; // this will pass the correct appointment ID to FileMaker so that it emails the correct customer $myScript = $fm->newPerformScriptCommand($layoutName,$scriptName,$arguementToPass); // this script will use the appointmentID to find the correct customer and email them $result = $myScript->execute(); // this tells the web browser to run the FileMaker script If you would like some local professional help with this PHP please DM me, we are a UK-based Platinum certified developer.
  6. According to the documentation, value lists, if they are created from a field that is of type 'Text', then :- 9. If you want to display the values that are in a text field in a specific language’s dictionary sort order, select Re-sort values based on and choose a language. Otherwise, the values are sorted in the index order of the field’s default language. This setting is ignored for other types of fields. See If the value list is based on a field that is not of type 'Text', then the documentation is non-specific. You can also choose to show a second field, and sort based on either the second or first field. Perhaps you need to manipulate the field upon which your value list is defined to be of type text, and make sure the values will sort in the order you require based on the English language?
  7. Hi Barry Please find enclosed a sample file. The way it works is :- Count the number of values in the search list Go round a loop that many times, and for each value, use PatternCount to see how many times it appears, and add the result to the 'answer' field. It runs as a script, rather than it being a calculation field, hope that is OK?
  8. There is an button in the 'Specify Calculation' dialog called 'Storage Options'. Within that you can select 'Do not store calculation results - - recalculate when needed'. This may reduce performance, since you are telling FileMaker not to store the results, but it will force recalculation of your field whenever FileMaker needs to reference it. Try choosing that and see if it resolves your problem.
  9. If you cannot sort on the 'A' field, then using sub-summaries won't be possible, and you may have to use my original suggestion. Comment, yes, I may be referring to a very old version! Comment, I tend to avoid un-stored calculation fields unless they are only ever going to be used on simple form views, since summarising unstored calcs is slow, particularly if you are using a list view with lots of found records. In this situation it may make very little difference to performance, as FileMaker could store the calculation results anyway, it was just a general point for good design.
  10. Ah yes, I had forgotten that FileMaker will now show sub-summaries in Browse Mode, it only used to be possible in Preview Mode. If it is acceptable to have the records sorted by 'A' in your use-case, then I wholeheartedly agree with comment, that it would be more elegant that way!
  11. Hi Balooka I'm not sure there is a very elegant way of doing this, but here is the inelegant way. Create some number fields with an Auto Enter Calculation (NOT a calculation field to improve performance) that says :- Field Name: OneifOne If (A = "One" ; 1 ; 0 ) Field Name: OneifTwo If (A = "Two" ; 1 ; 0 ) Field Name: OneifThree If (A = "Three" ; 1 ; 0 ) Then create summary fields :- FieldName: TotalOfOnes Summary ( Total of OneifOne) FieldName: TotalOfTwos Summary ( Total of OneifTwo) FieldName: TotalOfThrees Summary ( Total of OneifThree) This would get very boring if you had 100 different value options in the field A. Maybe someone else has a more elegant solution?
  12. Hi there If I were doing this, I would Perform a Script that exists in the Mutual Aid database, from the Townships database, and pass the information as a Script parameter, separated by carriage returns. So in the Townships database you do something like :- Perform Script (External Database: Mutual Aid DB ; Add Record Script ; ScriptParameter "Time¶Type Of Event¶Full Address¶Township¶ICS Officer ") and then in the Mutual Aid DB, you would have a script like this :- Add Record Script Go To Layout (Data Entry) New Record/Request Set Field ( Township ; GetValue ( Get ( ScriptParameter ) ; 4 ) ) Set Field ( Address ; GetValue ( Get ( ScriptParameter ) ; 3 ) ) Set Field ( Time Start ; GetValue ( Get ( ScriptParameter ) ; 1 ) ) etc This should give you a new record with all the data copied across. Does that help?
  13. Sorry, when I replied I hadn't noticed all the interim replies! Wim beat me to it!
  14. Ah yes, that only originated in FileMaker Pro 14, sorry! You could just change it to the following, and in line 1, edit the path to match the location of your folder. My code below assumes it is on the desktop. All that has changed is the old line 1 is deleted, and the new line 1 is modified. The other three lines are unchanged. Set Variable [ $path; Get ( DesktopPath) & "EXPORTS/serial_number.php" ] Show All Records Sort Records [ Keep records in sorted order; Specified Sort Order: Export::serialNumber; ascending ] [ Restore; No dialog ] Export Records [ File Name: “$path”; Character Set: “Macintosh”; Field Order: Export::export ] [ No dialog ]
  15. Hi Philip Your requirement seems very simple, so excuse me if I have missed something. Enclosed are some steps that would do the job, but there would be other ways to achieve the same thing. The first line asks the user to select their output directory, they would choose the EXPORTS directory, wherever that is held. You don't need to do anything special to skip the deleted records. Since they are not there, they will not be exported! Get Directory [ Allow Folder Creation; $path; Dialog Title: "Choose a directory"; Default Location: Get ( DesktopPath ) ] Set Variable [ $path; Value:$path & "serial_number.php" ] Show All Records Sort Records [ Keep records in sorted order; Specified Sort Order: Export::serialNumber; ascending ] [ Restore; No dialog ] Export Records [ File Name: “$path”; Character Set: “Macintosh”; Field Order: Export::export ] [ No dialog ] I tested this on a simple file (enclosed) and I got the file requested. I would note that the file is not a valid PHP file, you would need to do some work to add HTML headers, PHP tags and all the rest of it depending on what you actually wanted to use the data for. Export.fmp12