rcacciato

OK I'll review and digest this. You've been most helpful. Thanks!

Thanks for this. How does one use a script variable? I haven't found any reference to that in the FM documentation. Sorry if these are such basic questions, I'm grateful for your help.

That was it. Simple as that. Can't believe I missed that. Thanks so much!

I have a script that finds records with certain parameters in order to print them. Here's the script (I numbered the lines to make it easier): Select for printing script 1 Perform Script [ “go to live airports” ] 2 Go to Layout [ “Select Airport” (airports) ] 3 Sort Records [ Keep records in sorted order; Specified Sort Order: airports::iatacode; ascending ] [ Restore; No dialog ] 4 Pause/Resume Script [ Indefinitely ] Copy [ airports::iatacode ] [ Select ] 5 Go to Layout [ “order detail” (qrgen) ] 6 Enter Find Mode [ ] 7 Paste [ qrgen::airport_code ] [ Select ] 8 Set Field [ qrgen::unprinted; 1 ] 9 Go to Layout [ “orderlist” (qrgen) ] 10 Perform Find/Replace [ Search operation: Find Next; Search settings: Forward; Search across: All records/requests; Search within: All fields ] [ No dialog ] 11 Beep 12 Show Custom Dialog [ Title: "Print Envelope Labels"; Message: "1. Click OK then hit return to perform find 2. Select number of records to print at top of screen 13 Click on 'Print Envelope Labels' 14 Mark as printed when labels are printed"; Default Button: “OK”, Commit: “Yes” ] 15 Exit Script [ ] For some odd reason, when it gets to step 10 the find doesn't perform automatically--I have to hit return. I can't for the life of me figure out why it doesn't just do the search. Any ideas? Thanks in advance.

We've built an order management platform that uses Google Firebase as the database backend. I'm exploring using Filemaker (16) to build a front end to make data manipulation, order analysis, and report generation easier, but I'm not seeing how to connect a Filemaker database to Google Firebase. There are some plug-ins such as GManipulator which integrate with Google apps like calendar and contacts, but it's not clear whether that can connect to a Firebase database and I'd like to avoid spending $150.00 per year (more if I have more users) to use it. In the good old days, it was possible to connect Filemaker to a mySQL (or other) database using ODBC, but that seems to not be an option here. Does anybody have any experience doing this? FYI, I've been asking ChatGPT to guide me and it looked promising but I've run into a dead end since Firebase doesn't seem to accept my definition of the table name when I set the variables and "Insert from URL". Thanks in advance! Richard

Thank you! I can't believe I missed that...

I have a database of airports and have a layout where I show airport info. Here is a screenshot of the Canadian airport data: The 4th column shows enplanements, or the number of passengers boarding flights (the field name is "enp2023"). I use this formula to display the numbers as X.XM (millions to one decimal place). This is the formula for the field: Round(enp2023/1.0e+6;1)&"M" However when it is an even million the number is truncated and doesn't show 4.0M (as for Edmonton) but simply 4M. I'd like it to display as shown in the rightmost column (these have been entered manually), as 4.0M. How do I do that? Thanks in advance.

OK. Looks like there's no way to force it. Thanks.

Whenever I paste data into my Filemaker database using command-v (we use Macs), it shows up with the original formatting and not the formatting of the field. I'm attaching an example using my name. If I do command-z it wipes out the formatting and shows the formatting on the layout as in the second image. Is there a way to force the data to just use the field formatting and ignore whatever the original formatting was without having to do command-option-shift v (Paste Text Only) or command-z? I'm pretty careful about this but I'm afraid that as more people use the solution the formatting will be all over the place. Thanks in advance.

Yes, but then I'll have to reimport everything and I'm afraid I'll run into a similar problem. The FAA info is available but there is other info in the database. Let me know what you think. So I did a test which worked. I created a new file with two fields, 3 letter airport code (text) and passengers (numbers). I did an import of the airport codes and left the passenger field empty. Then I did another import of the passenger data using the airport code field as the match. It worked--the passenger data was imported correctly. So it doesn't look like an incompatibility question. I was wondering if It wasn't working because the layout I was on did not include the fields being imported so I tried it on a layout which has the relevant fields, but that didn't work. I wonder what else could be going on. Thanks.

Hi, thanks for your input. Unfortunately the database has confidential information so I'm not in a position to share it here. I'll just have to do it the old fashioned way--typing it in as I go. Thanks in any case for your help.

No, they're all 3 letters. I checked to make sure and the field types are correct, IATA code is text and the emplacements field is number. The data from the FAA had commas (as in 53,505,795 for Atlanta) which I thought might be the problem. I was hoping that eliminating the commas would fix it but it still doesn't work. FYI I'm using Filemaker 16.0.6.600 on MacOS Sonoma. Might it be some weird incompatibility? I don't think so since everything works... I hope not.

I have a database of US airports, identified by their three-letter IATA codes (e.g. JFK, ATL, ORD, LAX, etc.). The database includes enplanement information provided by the FAA. I set this up in 2021 so I included the latest year available of this data, 2019. The FAA has just published 2023 data and I want to import that, but my import doesn't work. I've set up a tab delimited file with column A = IATA code and column B = emplacements. My original database has 512 records. This is what I've tried: First Attempt: 1. I select all records. 2. I then select: File > Import Records > File 3. I select the tab delimited file and get the import field mapping dialog (screenshot attached). 4. I select Update matching records in found set. 5. I click on the arrow next to iatacode to "Match records based on this field". The two-headed arrow appears. 6. I leave the "Add remaining data as new records" box unchecked 6. I click on import. I check Perform auto-enter options while importing, then click Import. 7. I get this result: Total records added/updated: 0 Second Attempt: I do the same as above except in step 6 I check the "Add remaining data as new records" box. When I do the import I end up with 1014 records (the new file has 502 records so the original 512+502). Instead of updating the existing records with the new data, it created a whole new set, even though the match field data matches. I've done imports many times before and I've never had this issue. This seems odd. Does anyone have any idea what's going on? Thanks in advance.

Yes that's it. So I should look at the thread you pointed me to?

I think so but not sure. To clarify, the first picture shows the finished product, click-n-ship label cut in half horizontally and applied to a bubble envelope. The second picture shows the FM print layout with two records. Promo2300999 on the bottom and Promo2301000 on the top. A page printed landscape then cut in half horizontally. I'm attaching a screenshot of the FM Layout itself (the blue "back to order list" is a button that doesn't print in case the script stops).