schmegol

I have a small database and in a portal I have data from a related table. I have tried many ways to dynamically sort the portal column (customer_name) by having the field name passed along to a global field (g_sort) via set field script (get Script Parameter) and then a calculation of getfield("g_sort") by to pass the field name to the Portal Sorting engine. All seems to work up to the getfield("g_sort") is not passed to the portal sorting. the portal is set up to sort via the result of the getfield("g_sort") calculation, unstored and text result, and then refreshed via the script.. No matter how I do it, it will not sort. my conclusion is the field "name" I would like to sort by is not being passed to the sorting portal although all calculations and script debug tools and data viewer show the fields are being set properly. So my script parameter is the name of the field I want to sort by, Ie "customer_name" The set field script grabs that parameter and sets it to the g_sort global field. The portal is sorted by the result of "sort_field=GetField("g_sort")" calculation, IE portal setup, Sort by field ascending "sort_field". This Should work, but does not. What the hell am I doing wrong? I got this generic method from many similar solutions on various forums.

is there a way to do this in osx and filemaker go? so far, testing it in FMP 14 on OSX does not work....

I have done a lot of research and don't see a solution. What I want to do is send and existing record atttached as a PDF via email in Filemaker go to wherever. everything I read says I have to save the record as PDF first? Then create a file path to the specific record. But that will clutter up the IOS too much. Kinda like print to pdf with email attachment and name the pdf a value from a field. I know this is probably possible, but I can't get it to work. So I'm reaching out to you Genius' if there is a solution that just creates an email attachment of the current layout and current record as a pdf . Make sense? Thank you in advance for reading

I have looked but I cannot find much documentation on it. BTW, you replied to a previous post as to parsing a pdf via PHP server solution, and I acomplished that from your idea. Thank you... It works great. I also read your docs about base-64.

From what I read, this probably cannot be done. I would like to pass either an attachment or the contents of an email subject line to a Filemaker Go solution automatically. Easy to do with AppleScript and Filemaker, but I need a Go solution. I know you can manually "Open in Filemaker Go" with an attachment. Any ideas pointing me in a direction to research would be helpful. Thanks.

Where would this server be? Do you know someone that can write that for me for a fee?

Right now, it needs to be run entirely on the Ipad Fielmaker Go platform and not server. The PDF's do have consistency as I can do the parsing in Filemaker pro with AppleScript. I have the solution working on the desktop and now I need it to work in the field on the iPad. But no luck with getting the text from the pdf.

I am creating a database solution that needs to read the text from a pdf in a container field and put it into another calculation or field for parsing. I have read many articles and can't seem to find a solution to something that a simple Mac Automator Action can do. I have done this in Filemaker for Mac (not Go) via AppleScripts. I need to do this native to Filemaker without plugins or external scripts as this will end up being on Filemaker Go residing on the tablet/phone. Is this possible?

I have a need for a value list that updates when I update the master list of values in another related table but does not globally update all records where the list is used. For example, I have "customer" table with radio buttons of various subscription rates that are populated by a value list in another table of "subscription rates". What I'm trying to do is when I update the table of subscription rates it will NOT affect individual customer table records and update them. It only affects new customer records created and rates from when the "subscription rates" table is updated. So every previous record before the subscription rates table is updated to new rates will reflect the subscription rates the customer originally signed up for. Right now my customer table is related to the subscription rates table with a global field that is the same for all records in both. My rates value list uses the related values from the subscription rates table but If I change a subscription rate it updates all the customer records.

I have a table with field 1, field 2, field 3. I am trying to figure out a calculation to return either field 1, 2, or 3 based on other field values in another table. This is kind of like picking values out of matrix where the vertical is the records and the horizontal is the field 1, 2, 3 in each record. Does anybody have any experience with this?

I know this has been addressed but I cannot find the answer to this. If somebody has a link, I would appreciate it. I have been reading every portal post on this forum.... I have a typical job_ID table with a one-to-may relationship to a line_items table with a many-to-one relationship to a items_id table. I would like to be able to summarize the following: Job ID: XYZ has a portal with separate line_items in it consisting of items_id: Qty Location item 1 front window 2 back window 1 side window 3 back door 2 front door 1 bedroom door 1 bathroom door How do I show just the total of doors or windows in either a layout or portal without separate lines for each. This would not be shown in the same portal they are created in above. Perhaps a separate portal with: Example: Job ID: XYZ 4 window 6 door and be able to use those summary numbers elsewhere. IE on a purchase order table to: Order: 3 windows Order: 6 doors

I'm not bad at FMP, but I created an invoice table that has "items" field that is related to a "items" field in a table called "Line items" that is related to the field "items" in an Inventory table. My question is how when I create records in my invoice portal showing "line items" to update my inventory as each line is created. There are some summary calculations missing here. I have something sort of working but the inventory does not update instantly with each portal record being created or deleted.

That solution will not really accomplish what I'm trying to do. If my phrase is "dish tv satelllite" and I search It would find reslults of "satellite tv dish" and also "dish satellite tv cable box" if that phrase was there. I am only interested in exact matches of the phrase words including the count of the phrase words and omitting extra words in the match.

That solution will not really accomplish what I'm trying to do. If my phrase is "dish tv satelllite" and I search It would find reslults of "satellite tv dish" and also "dish satellite tv cable box" if that phrase was there. I am only interested in exact matches of the phrase words including the count of the phrase words and omitting extra words in the match.

I have a complex problem. I have a database of records with a text field that contains a 1 to 5 word phrase such as "winner circle post horse laptop" I want to search through each record's text field to find and compare another text field for a match of all of the words in the field regardless of the order they are in such as "circle winner laptop post horse" would be a match because the field contains all the words. I would like to reject matches that only contain a partial match of less than the complete word count. Anybody ever done this or have any ideas?