wattmhite

I have several users and passwords set up for sending automated SMTP emails but I am concerned of script failure if a user happens to change his or her password. Therefore, I am building a daily script for the management team that tests each SMTP email and password and reports errors before the script is performed later in the day. Any advice on how to collect and test/report SMTP send errors? Thank you

Is there a way within filemaker to limit the decimal places in a number field to 0? I'm trying to create a field where in if a user enters 100.4 it will set the value to 100 and not allow any decimal places. I see you can do this in the inspector but I don't think it actually changes the data within the field. Thanks

What is the best way to extract a website as a pdf from a web viewer window? I have read some suggestions of creating a separate layout with the full screen as the web viewer window, changing to preview mode and printing/saving the screen as a pdf.

Just a few questions: my database is now 85 gb and growing every day. What is the best way to back this up, is there a cloud service you would recommend? also, I have a table with a container field and it holds all of our companies pdf copies of documents. I’m considering storing that fields data on an external drive since it makes up the bulk of the 85 gigabytes. Is this a good idea or do you all have any recommendations? thank you!

Thank you OlderDiekstra. But how would you implement the " (Quotation Marks) every time I write a script with those it thinks what follows is comments?

I'm working on a script that sends an email to a customer with a custom link. Is there a way to create the name of the link (what the customer sees) as Name (for example) but have the address actually different IE the real address? The problem I',m having is my custom URL is very long and I would like to make it easy and simple for the customer and for them only to see a blue line with the title "Click here" Thoughts? Many thanks in advance

Not sure if there is a location feature within filemaker or a list I can build into a table but I am trying to set up system where if I type in a zip code (92881) for example, the 10 closest zip codes in that area are shown. Any ideas? Thank you in advance!

I am trying to create a script that sets a global field with a certain value so all users connected to the server can see this value in the global field. Is there a way or script that tells the server to set a field rather than the connected user?

Is there a script to detect when other users are currently in a particular layout? I have a layout I use to bind accounts but I only want one user at a time to be able to access that layout. When the first person leaves the layout then another person can enter. Can this be done? Thanks

Does anyone know if this is supported in filemaker go or support soon to come? It would completely change my business if this were possible. Thanks

I have a portal within my main layout that I use for all phone log comments and documents. Is there an example or a (best practice) way to create a search field that searches within that portal only and shows the correct records searched?

Hi All, I'm familiar with the middle words function but I'm looking to separate individual letters. I have a table with values the first 2 letters of which I do not need. I'm looking to create a field or function that skips the first 2 letters and displays everything after the first 2 letters. Is this possible or is the middle words the only way?

We're using Macs here at the office (not sure if it matters) but I have a search field that you can type search terms into and currently the user has to exit the field then click on a separate search button. Is there a way to perform the search script when enter is pressed? Thanks

Hi All, Happy Sunday! I'm trying to build a layout that contains 5 containers so my employees can drag and drop XML files into each container and then I can run a script to export those XML files and import them into my filemaker database. I'm struggling to get the data exported from the containers and imported back. What is the best way to do this? Export container via $path then import $path file? Thank you so much in advance.

Hi All, I have a data set that includes about 300k records. Each record includes 3 fields: Year, make, Model. I'm looking to set up the 3 fields in my main database so I can start selecting the year, which will limit what makes are displayed. Select the make and based on the year and make show the available model options. What is the best way to set up tables and or relationships so this is sorted properly? Thank you!