• Content count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About muzz

  • Rank
    keen observer

Profile Information

  • Gender
  • Location
    Mandurah W.Aust

FIleMaker Profile

  • FM Application
    15 Advanced
  • Platform
    Mac OS X El Capitan
  • Skill Level
  • Membership
  1. I have a simple multiplication table solution ("times tables") that I have made for my daughter and I'd like to improve it and would appreciate some guidance with the strategy to implement it. Currently the records are presented in the format a*b=c, with a*b presented and the input is made into the answer field "c". Currently the times tables to be tested are selected (e.g. for 7 times tables b=7), then the number of questions desired for the test are selected. The records for the table are then created by scripting in a loop from 1*b to 12*b then sorted randomly and the appropriate number of records omitted to show the desired number of records for the test. I would like to make two improvements - firstly to present the equation as 2 known values and one unknown, with either a or b or c requiring the input. Secondly I would like the option to extend the learning by introducing multiplication by 10, 100 or 1000 to the values in the equation. My initial thoughts for the first part were to create a table with all of the possible combinations of 2 knowns and 1 unknown, and find related records (e.g. for 7 times table all the records where a=7 or b=7). This strategy would require a lot of records and the same strategy would be impractical for the second part of the improvement. I'm thinking that a combination of calculation and scripting would be necessary but was hoping for some early suggestions before continuing as I'm not even sure that my current strategy for creating the records is the best way so building on that may be undesirable. Any help will be greatly appreciated.
  2. Thanks rwoods. I probably didn't give as much information as I should have. The appointment calendar is not integrated into Filemaker, we are using Apple Calendars on a Mac. The current workflow would be to manually create one reminder record at a time, enter the appointment time and enter the client code which would then pull the mobile number in and create the message to be sent. Not all clients have a mobile or wish to receive a reminder, or an appointment slot may not be filled so not all time slots will be used. Sometimes the appointments may start later in the day or vary for some other reason. I just thought it would be easier to select an appointment closer to the last appointment made in the drop down value list rather than defaulting to the start time or any other time for that matter if entering the field if it is necessary to change the time. Thanks for your solution though - I may have use for it in another table and appreciate your effort.
  3. I am just working on an appointment reminder system and I would like to create a set of records each day for the next day's appointments. In general, appointments are half hourly and mostly only one for each timeslot. I'd like each new record to auto-enter the appointment time 1 slot (30mins) later than the time slot in the previous record. At the moment the timeslots are in a value list from 8.00AM to 5.00PM in 30min intervals. Once I've created the record for the 10.30AM slot I'd like the next record to auto-enter as 11.00AM etc. My current method is to do it by calculation from the time data in the timeslot field from the previous record by using the value of the n-1th record (where n is the total number of records) and adding 30 mins but this feels more complicated than perhaps it might need to be. If ( Get ( RecordNumber ) =1; "8:00 AM" ;GetAsTime (GetNthRecord ( Time ; Get ( RecordNumber ) -1 )) + GetAsTime ("00:30:00")) Is it simpler (or possible) just to select from the values in a value list? Thanks.
  4. I tried pausing up to 5 seconds but still no joy. When I tested the file opening with export it was almost immediate and I presume that means that it has reached it's destination ($path) before opening. I made another test file (PathTest) and tried that at home with the same script steps and it worked perfectly on my local machine transferring an internally stored file in Container 1 into an externally stored Container 2. Set Variable [ $path; Value:"file:" & Get(TemporaryPath) & PathTest::Container 1 ] Export Field Contents [ PathTest::Container 1; “$path” ] Go to Field [ PathTest::Container 2 [ Select/perform ] Insert File [ “$path” ] Commit Records/Requests [ No dialog ] The solution I am trying is hosted with FMS15 and I am using Apple Remote Desktop to screen share on the Mac with the server and running everything from there with FMP14 on the same machine but still opening it as a hosted file. The script is the same except for the names of the containers. I can leave it as is without using this script but I'm just confused as to why it doesn't work.
  5. Thank you both, I now have it working. I di have one problem though which is when I script to export the container ("file.pdf") to a temp path defined by a variable ("$path"), then insert "$path" into a new container setup with external storage, I get the message that "file.pdf cannot be found. If I select automatically open when defining the export, it opens as expected so I believe the problem must be with the insert step and I haven't solved it. In the meantime I have been able to export a copy to a folder and insert from there. I can delete the few thousand files once done but I'd like to know where the insert step is going wrong. I don't have a strong understanding of these things. I wondered if it could be permissions that are the problem but repairing these with a utility hasn't changed the result. I seem to be following the basics of Wim's script although they are all PDFs so I didn't bother trying to differentiate file types and just used the Insert File script step alone. Thanks again for your help with this. Regards, Murray
  6. Thanks for that comment. I've set up a test file but I think I have my syntax wrong as I'm still getting "The file cannot be found". I created the test file and a folder of scans (MyTestFolder) at the root level of the original Macintosh HD. I then uploaded the test file to the server on the other Mac and copied the folder of scans to the root level of the server Mac (also Macintosh HD), so in the end the file paths were the same, however that didn't work. I wasn't sure if the filewin path would work as they were both Macs but couldn't get it to work either - I tried server name but wasn't sure what shareName was on the Mac. Could you help me with the syntax of the substitution if the server's hard disk is "Macintosh HD", the folder at the root level is "MyTestFolder" the server is called "MyServer". I hope that is enough information. Thanks again. Thanks Wim, I will work through that solution if I can't get the above working. Cheers.
  7. I'm trying to sort out container storage in a solution that originally started on a single machine running FMPro and serving to one other. At that time, containers were used to store PDFs of accounts which were stored by reference and were located elsewhere on the same host machine. Since then, the solution has been moved to FMServer on a dedicated machine on the same network (all Mac). Unfortunately the referenced files were not moved and the files could no longer be accessed remotely from the served solution. At that time, I attempted to import the referenced file to internal storage and then export to another container set up as remote storage but was unsuccessful as the file references could not find the files. To move forward I changed the existing containers to external storage so that subsequent PDFs could be accessed. I would like to relink the previous PDFs and save them into externally stored containers to restore the functionality of the database. The original scans are still in the same place on the original machine. My thoughts include: possibly copying the database file back to the original location (or use a backup pre-dating the change from reference to external storage), change to store internally, copy back to the server and then change to external storage; copy the original scans to a folder on the server that restores the relative reference location to the original database file; open the original folder of scans on the server machine by file sharing the old volume and change the file path so the containers can see it again; some combination of the above; something entirely different. Any thoughts would be greatly appreciated. I'm sure there may be some of my ideas that will ring alarm bells with experienced users so ruling them out quickly would be great. Another point worth mentioning is that some of the folders have been named with a "/" character (e.g. Invoices 2006/2007) and I'm not sure if that impacts on FileMaker's identification of the file path i.e. if it sees 2007 as a subfolder - I thought this may have been the problem with my early failure to import the referenced PDFs into internally stored files. Thanks in anticipation of any help that can be given.
  8. Filemaker have downloaded me to FMAdv14 without a problem and the solution is working fine. Thanks for everyone's input.
  9. Thanks Josh - I already had their number up on my screen. That would be a good solution for the time being.
  10. Thanks Josh. I will just work around by generating the vCards on my laptop and transferring them to my main computer from there. I had already upgraded to FM15 but had to downgrade again due to FM15 generating corrupt PDFs, a problem not yet sorted but I'm assuming that an update will fix that and I can start using 15 on my main computer again. Thanks for your help and I will bear it in mind.
  11. Perhaps I should have said that the example allowed me to adapt it to my use without having to learn other languages or research techniques beyond standard Filemaker functions which I have been able to fumble through with occasional help, usually non-judgemental and always gratefully received. The presence or absence of the above mentioned "tools" in version 13 is debatable as the example file intended for use in FM14 works perfectly in FM13, suggesting that at least in this particular case version 13 does support encoding text in Base64 format. It does not however work in my implementation which is what I would like to resolve if I can.
  12. Hi Kris, I had read Base64 Encode/Decode originated in FM13 (I created the calcs in FM13 and the functions were available there) however I think the documentation refers to "specified container fields" in FM13 and "specified fields" in FM14, a nuance I had missed.
  13. Thanks for your reply comment. The last time I looked at that post other than to quote it today was before those last posts were there at which time I had read it to the end - the end is just in a different place now. However the example file provided works perfectly with FM13 despite the assertion that support for encoding text in Base64 format was only added in version 14. The advantage that this technique brings to me is that someone (Joe Simpson) kindly provided an example as to how to do it with tools that I already have. I'm not a developer and have no understanding of XML/XSLT but am just trying to get something to work that helps me get on with my core business.
  14. I recently tried to implement a Base64 Encode/Decode approach to create a vCard from FMPro as previously described in this post The file resides on an iMac at my front office desk running FMPAdv13. When opening the file and running the Base64 script to export the vCard on this Mac, I get an empty card however if I run the file from from FMPAdv15 from my laptop on the same network (hosted on the FMPAdv13 Mac) the vCard is exported as expected. I looked at the encode function and found that in the FM13 file the field has a single "?" however in the FM15 view it is filled with data (screenshots attached). Can anyone shed light on how to implement this correctly from the FM13 client? I have changed the vCard format to suit my needs but nevertheless the 2 different versions do perform differently. Using FM14 behaves as expected (i.e. the same as FM15). Thanks, Murray
  15. Yes, apparently there is a known issue.