2 posts in this topic
Estimates - Bill To and Ship To
By Beto Boton
Let's start with the famous introduction "I'm not an expert" but I've been around filemaker for a while.
I'm on a Mac FileMaker Pro ADV 14.
I would love to know HOW can we populate automatically the Estimates Bill To and Ship To information as soon as we select the "Company" (Account) since this information is already filled in the Account Layout. Can we do exactly the same based on BillTo_Name_First or BillTo_Name_Last ? But WAIT, there is MORE:
I have Business as Clients and each Business is an represented by ACCOUNT
I have people as clients (CONTACTS) from different places
Individuals (Contacts) classified grouped under ACCOUNT "eBay Clients" Individuals (Contacts) classified grouped under ACCOUNT "Website A Clients" Individuals (Contacts) classified grouped under ACCOUNT "Website B Clients" I want to be able to autofill Estimates Bill To and Ship To information based on the CURRENT ACCOUNT (from the field labelled Company) BUT be able to choose different CONTACTS from the same company.
I believe this has to be done via a "script trigger" (something I learned from the videos) but I believe it should be 2 scripts that will execute based on whatever I have no idea !
WOW - that was a long one, SORRY about that but ANY HELP will be much appreciated.
Can I open a browser with the page currently displayed in Webviewer?
Can't seem to find this out --
If I am viewing a web page in webviewer (in Filemaker) is there any way to get that exact URL from the webviewer and open it in an external browser (i.e. Safari, Chrome)? I know the starting page already, but the user may have navigated away from that page when they want to open the external browser.
I have searched this site for an answer and also other FM resources on the web. Maybe I am using the wrong search terms? Seems like a straightforward thing -- I am viewing a page in Filemaker and I need to open that page in a stand alone browser. Click a button and voila! (?)
Any help is appreciated. Thanks!
Embed html or php in a Text Field
By Digital Life
I have a web site that is presenting data from fields in a Filemaker Database. FM 11 Server. When viewing the text in a browser it does not see the carriage returns. Is there a way to embed some html/php in the field so that the browser will add in carriage returns?
How to autofill with a script?
I have made three tables: Meetings, People, and a People-Meeting join-table. I need to create a button in the Meetings table that brings me to the People-Meeting table, create new record, and then autofill the last serial number from Meetings into the Meetings ID field of the newly created record in the People-Meeting table.
I've only managed to make a script as follows:
Go to Layout ["People Meetings"]
Go to Field ["People Meetings::Meeting ID]
But I don't know how to do the autofill part. Can anyone help please?