megalomania

I'm really struggling how to run .command file with passing parameter. My FM version is FileMaker 18 and MacOS(Mojave). What I have tried is running Perform AppleScript, in its calculation part I coded this "do shell script \"/Users/admin/Desktop/OrderBook.command PARAMETER\"" If I run this script, it keeps saying this error message /Users/admin/Desktop/OrderBook.command: line 1: OrderBook.csv: Permission denied Is there anyway to solve this? For your information, in my situation, I wanted to run command directly within PerformAppleScript but I gave up because it was really hard to solve syntax error with that. Thanks in advance

Hello, everyone. I have a question. I have web viewer object named "web". If I start a script running, Every 5 seconds, it fetches the string from the HTML that is shown in the web viewer, and keeps creating new records. Just like this GetLayoutObjectAttribute ( "web" ; "content" ) Then the target value always get refreshed every 5 seconds. javascript is just like this function updateLastvalue(new_last_value){ var current_last_value = $('.last-value').text(); var fixed_last_value = Number(new_last_value).toFixed(8); $('.last-value').text(fixed_last_value); // update document.title = fixed_last_value"; } and the number that I want to fetch but it changes every 5 seconds is just like this <td><span class="last-value”>297</a></td> How can I take out this 297 and another numbers that continues changing? GetLayoutObjectAttribute ( "web" ; "content" ) takes out only the number that was shown first. Can anyone help me with this?

Thanks for introducing the custom function!!! This is what I wanted!!! Thanks so much! This SQL also looks useful!! Thanks for the advanced technique!!

I'm using FileMakerPro Adv 13 Considering There are records like these below 1 Orange 2 Apple 3 Strawberry 4 Apple 5 Lemon 6 Apple 7 Orange 8 Melon I have a value lists called "TypeOfFruits" then If I execute this function Substitute(Substitute ( ValueListItems ( Get ( FileName ); "TypeOfFruits"); "¶"; "n") ;" ";"") I get this output OrangenApplenStrawberrynLemonnMelon It is shown on a page just like this Orange Apple Strawberry Lemon Melon If I want to count all of them and want an output like this, how can I change my function above? (sorted by the number of count) 3...Apple 2...Orange 1...Strawberry 1...Lemon 1...Melon

Thanks! That was it!

I' have a container field in my filemaker solution file. I can go to camera mode if I click it and chose camera when the container is empty. It allows me to take a picture within FileMaker solution but it won't let me switch to video mode even if i click on "video" while it's camera mode. Do I always need to take a video first before launching Filemaker solution then I have to chose "import > file" to insert video into the container field? Can't I do that all at once within FileMaker solution?

I'm accessing Oracle Database Server via ODBC. Then I added three tables to FileMaker from Oracle DB. These tables are related such as below 1. Customer (customer_id) 2. Receipt (customer_id, receipt_id) 3. Item (receipt_id, item_id, item_name) note: Items belong to Recept, and Receipts belong to Customer. I built a portal in order to show the detail about when, and what a customer bought by reffering purchase history. Then here's a question. I'm on Customer Layout(showing all Customer records) In spite of the fact that the customer has purchased something before, nothing appears in portal It should show the date of purchase, and the name of the item, though! Another additional weird thing. If I go to Receipt Layout(showing all Receipt records), and load record(Suppose customer_id="12345678") then go to Customer Layout and find a customer by customer_id="12345678" Now, It shows actual result in portal. Why is that!? Is it something related to index? Does it automatically add index to a record when after load a record?? Do I need to do something special to show actual result in portal as default? Any solution?

I'm calling Oracle's Database through ODBC. It's working fine except speed. One table has over 100 million records. When I'm seeing this table in FileMaker, it takes forever to load its layout. How does everyone handle this kind of problem? note: Oracle Database Server is located at different location(500 miles away from this client)

Thanks so much. You are right! I could access to ODBC by setting up 32-bit ODBC control panel! I didn't know that there are actually two control panels for both 32bit and 64bit. Thanks for an answer

Now, I'm trying to connect to External Oracle DB Server via ODBC within LAN network. Everthing about setup is pretty much done, and I can see the full list of tables name when I try to add External database in relationship window. I'm almost there! I thought I'm fine so I w-clicked on the target table name but it shows just "ODBC error" It doesn't even describe any detail about what kind of the error is. WIth my SQL Plus, indeed I can connect to the Server. Is there anything that I'm still missing??? or Do I have to do something with Server side?? As long as I can access to Server with SQL Plus, I thought I should succeed. Does anybody know any about this case? Any idea? This is my oracle setting tnsnames.ora TESTDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TESTDB) ) )