Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Agentshevy

  • Rank
  • Birthday 01/03/1991

Profile Information

  • Gender
  • Interests

FileMaker Experience

  • Skill Level
  • FM Application
    13 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

3,236 profile views

    Thanks for your reply Mike, however at the moment, upgrading to Server 16 won't be an option for me. We are still using Server 14, and it took some time to cough out that money on the budget.
  2. Do not postpone that which you can accomplish now..


    Hello everyone.. Guess I have been away for a while. Not fully back though because I am not really engaged with computer tech stuff at the moment. However, I really stumbled across a problem earlier today while going through my email logs. I observed that a server script I had set up has not been attaching the Pdf file report as supposed to. It only delivers the message while leaving out the file attachment. I did test the script when I added it but what I did not test was the result when run by the server. Allow user Abort [Off] Commit Records/Requests [No dialog] Set Variable [$FileName;Value:"Summary"&".pdf"] Set Variable [$PDFPath;Value:Get(TemporaryPath) &".pdf"] Go to Layout ["Summary_Layout] Perform Script ["Print_Page_Setup"] Save Records as PDF [Restore;No dialog;"$PDFPath";Current record] Send Mail [Send via SMTP Server;No dialog] As at the time of my writing the script, I was not observant about server-side scripts. I did go back just recently to observe that the "Save Records as PDF" script step is not server compatible. Please, is there any work around on this? Much help is appreciated.
  4. FMEasyWeb Is Now Available

    Right now, I am just concerned about setting easyweb just for it to show the records (just as the demo video) I don't really need to be able to edit records etc.. going through the comments on the thread, I can see some people have been able to at least get past the setup stage. Their help will be much appreciated at this point. I am still confused in some steps: 1. Where exactly are we to copy Easyweb folder and files? Hosting site or FileMaker server 2. I use Windows for my FileMaker server, going through C:program files - FileMaker - Httpserver - Conf. (There is no directory called Httdocs) and from people's comments, this is the folder that holds the fmeasyweb files
  5. FMEasyWeb Is Now Available

    Looks like this project is dead.. That would be a terrible loss.. I so much loved the solution though havnt been able to successfully get it working.. Especially setting it up
  6. We recently bought an Evolysis Card Printer, which prints Front and Back of the card automatically. (Current Situation: We are using a Corel Draw template, the front is on page 1, while the back side is on page 2.. when we want to print, we simply select page 1 and 2 and the printer prints the ID Card front and Back automatically) However, with filemaker, we print the front and then inserts the card back to the printer so as to print the back side. Thus, the layout design of our database has the Front Side on one layout, and then the Back side on another layout. With this new Printer, how can we leverage on its dual page printing capability in designing our layout? Is there a way to design the layout such that the printer knows which is page 1 and which is page 2?
  7. Calculated Field from Several Field Logic

    thanks Schamblee
  8. Hi All, I don't really know if the Title really explains my situation, but here it is.. I have Four Fields: Name, Gender, Class and Policy Policy Field is an Unstored Calculation with the calculation below with result set to Text If ( Gender = "Male" & Class = "Primary"; "RUNNING" ;"EXPIRED") Meaning, my intention is to Set the Policy field as Running, if the Student is Male and in Primary Class, otherwise, it should be set to Expired.. The calculation does not work, some fields are displayed correctly with the correct value while others are not. However, if I remove the Logic "&" from the calculation making it only a single criterion, If ( Gender = "Male" ; "RUNNING" ;"EXPIRED"), then it works well.. Why can't I compare several fields using "&" or "OR" with that function? Is there a better way of actualizing this?
  9. Its been Great having to be in the midst of the Greats

  10. Export and Import Same Records in a single operation

    Thanks a million for your replies..
  11. Export and Import Same Records in a single operation

    From your suggestion, this is what I have been able to do Allow user Abort (off) Set Error Capture (On) Freeze window Enter find mode Go to Layout (Table A list) Set Field (Table A list status::"INACTIVE") PERFORM FIND iF (Get(FoundCount) = 0) Beep End If iF (Get(FoundCount) not equal to 0) Go to Layout (Table B list view) Show all Records Import Records no dialogue (Source:Table A ; Target:Table B ) Go to Layout (Table A list) Go to Record/Request/Page (First) Loop Delete Record/Request (NO dialogue) Go to Record/Request/Page (Next;Exit after Last) End Loop End If Go to Layout (Original Layout) Show All Records Everything seems to work well EXCEPT the record deletion part on Table A. All the marked inactive records are imported into Table B, but not all of them are been deleted in the last part of the script step (the loop side). I don't what I am not doing right. Is there a simple way of deleting a foundset using a script step? Just as we can do from the main window.
  12. Remote Access Using Webdirect

    I have removed the second Router completely.. So my network connection is like this: Internet Modem (Router) = Switch = Server I did the port forwarding all over again, leaving out Remote Host as suggested.. (TCP/UDP Port 5003) Still havent been able to connect via FM Client nor web direct.. I have equally disabled both router firewall and that of windows on the server machine.. still no luck Using the Portforward Utility tool from portforward.com, I was able to run a port check scan, and it came out that Port 5003 on UDP is Open, while on TCP, it says its already in use by a program.. (I am guessing that should be my FM Server) Below are the observations so far from my trials: 1. With my initial network config of two routers, I used the DUC Client software from ww.noip.com , and while connected to our internet wifi network, I can access our database using web direct by imputing the address from noip.com client. example, I used http://simpledata.noip.me/fmi/web 2. If I try to access the same url when connected to any other internet wifi network, I get redirected to our Router's login page 3. With the new network config or One Router = switch = Server, I get redirected to our Router's login page while trying to access that url, even while connected to our wifi network.. I don't really know what else to do..
  13. Export and Import Same Records in a single operation

    I totally agree with you. Funny enough, i never thought about this .. this would definitely reduce the number of records on Table B, which is very good as my database size is reduced. Thanks for pointing me in this direction. Still battling with the scripting. Especially since I would be uploading my file on the server. On the Import records script step > selecting my file, how would i tell filemaker that my file is on the server and no more on the desktop? because my file is currently on my desktop, but will be uploaded to the server after i am done..
  14. Export and Import Same Records in a single operation

    I will be ticking the box for "perform script without dialogue" on the import record script step because I will love to run the process with any visual dialogue. However, since my file will be hosted on the server, guess I wouldnt need to manually locating my file to select it? The purpose of the technique is to have a decoy Recycle bin for our records. Clients get deleted from Table A when they have unscribed from the service, but sometimes, they do come back. So we wouldn't want the stress of having to re-enter their records over again. We can easily navigate to Table B, and copy the records back. I have already scripted that process. We do a lot of analysis based on table A, so we have a lot of calculation fields in that table. Initially we were using status field to indicate Active and inactive Clients, but as a result of the overhead caused when performing finds, omitting of records etc, we opted for outright deletion of inactive records. Thats just it.. Thanks for your replies..
  15. Remote Access Using Webdirect

    I will try to do that.. Thanks for your response

Important Information

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