carlosnorvik

Any thoughts / ideas about this? Comments will be very welcome! 😃😃

Hi: More by accident than knowledge, I created an unmodifiable field, I inverted a lookup to populate a field, and forgot to delete the corresponding lookup on the other field . Functionally this "accident" is great for me, it prevents unintended changes, but I wonder if it may create other (not good) consequences. I made a simplified file which recreates the "accident", you will see that the fields on the panel cannot be modified (they can be deleted by clicking on the red button). Any comments are welcome, file is attached below. Non_Modifiable_invoice (1).fmp12

Hi: I have SC on a W7 Profesional machine and Tomcat. FMS 11. Any recommendations on how to restrict WAN access to the files hosted by SC w/o having to use passwords ? ideally I would like to restrict it to the users computers MAC addresses, but I have read that is not possible. Could it be done by restricting it to the IP’s? Any other suggestions ? thanks and regards Carlos

Thanks Win!

Hi Wim: thanks for your answer. Licensing: Maybe my question was not well made. I already have 4 standalone lifetime FMPA 17 licenses. So I wonder if users of those licenses can connect to the server? Bottlenecks: No real bottlenecks in the current system. Thanks Carlos

Hi: I am planning the upgrade to 18, I have 3 questions 1- I will host my own server, as I do now with 11. We are 9 users, normally not more than 5 are connected. I don’t want to install a Windows server so I will go with a Mac. I am thinking of the basic Mac Mini upgrading memory to 16 GB, is it OK? 2- Of the above 9 users, 4 are occasional. I have 4 FMPA 17 individual licenses. If I buy 5 user licenses, can these 4 occasional users connect to the server with the individual FMPA 17 licenses, or do I have to buy the 9 user licenses? 3 - I will keep using Super Container, no point in using time to move to remote containers (tons of files) I will leave the computer that hosts SC as is, I guess that will be no problem (it is the same that currently hosts FMS 11, since load is light, it has not been an issue. it is a Windows 7 Pro machine. thanks Carlos

Hi: I want to share a good cloud backup alternative, Hubic, it gives 25 GB free, and you can schedule backup to happen "x" hours or minutes after a file has changed. So just add a backup schedule to the "Hubic"folder of your PC or MAC where you have your server and instruct Hubic to sync 1 hour after, that way you make sure the upload will happen after your backup has completed. Neat and free. I was using Onedrive, but with the recent decrease in free capacity I looked for alternatives, I specially like the delay before upload. Carlos

OK, thanks for the info. Carlos

Hi Josh: What got me wondering was this: Great when you want FileMaker users to directly read and/or write data to a SQL data source. You will need to have an ODBC driver for the SQL source configured on each client machine. Which appears at External SQL Data Source Overview Carlos

Hi Wim: I don't know if I understood correctly, but from FMI website it does seem to be now possible to use FMPro as as from end to a SQL database w/o even using FM server (using the appropriate connector) Is that correct? Best regards Carlos

Hi Wim: There are a lot of CAL discussions all over the Internet, and the licensing terms seem to have a lot of gray areas. I have been reading about it because I was thinking about upgrading to a Windows server and FM server 14 (currently FMS server 11 on a Win 7 Pro, which does not require CAL and allows up to 20 connections). Filemaker updated its knowledge base about this on Feb 3, 2016, and it now says: FileMaker Server connectivity may require CALs, depending on the hosted environment you are running your software in. Contact Microsoft for further questions or concerns regarding the use of CALs specific to your environment. ( http://help.filemaker.com/app/answers/detail/a_id/13342/~/does-filemaker-server-require-a-client-access-license-(cal)%3F ) So even FM seems not to be sure. I guess for the time being I will stay with my current setup and wait for FM 15, hoping they will release a Linux based server (or host it on an Apple when I finally upgrade). Happy Easter Carlos

Hi LaRetta and Bruce: Thanks for your replies. I will upload a simplified sample so you can take a look, it will take a few days because I'll translate it from Spanish and simplify it to show only this issue, otherwise it can be overwhelming to figure out, it has slowly grown into a spiderweb of relationships, both within the fp7 itself and to separate fp7's used in common with other fp7's ('shared fp7's are for contacts, exchange rates, Incoterms, etc.). Thanks again Carlos

Hi Bruce & LaRetta: I don't have a problem with the value list itself, it works as intended. What I wanted to do is to use a completely different value list if there wew no related records for populating the main one. I did it less "elegant" by displaying another tab. Thanks for replying to my post! :-) Carlos

Hi Everybody I wish you all a very prosperous 2016 and may all your wishes come true. I have been using some of my holiday time to update my FM solutions, so far I have managed most of what I wanted to do and learned a couple of tricks on the way. Now I have found a roadblock, using different value lists on the same field. I have many value lists based on relationships and they work fine, but in this case the situation is: a) It is a checkbook solution, if there is a relationship it displays certain values (List of debtors/creditors in one field, invoice numbers with balances > 0 in the next and Invoice value on the next). b ) However payments and deposits come not only from purchases/sales of trade goods (relationships and resulting value lists come from the purchasing/invoicing solutions), I need to use a completely different value list if the operation is not related to trade (for example salaries, office consumables, sales of old and depreciated capital equipment, etc.). If somebody know how to do it, I will really appreciate some insight. Thanks and enjoy the party tonight. Carlos

Hi Comment I had not noticed FM also has the "Match whole words only" that will also easily do it.

You can also export the fields to a csv file, open it in word pad and do a find/replace taking care of clicking on "Match Whole Word Only". Find 6 Replace with (leave empty) This will remove all 6's but will leave alone numbers like 16 and 66. I tried with the following: 1 12 6 2 1 2 6 6 16 9 1 15 29 66 12 6 And after doing as above got the following result 1 12 2 1 2 16 9 1 15 29 66 12 Then you import the records again. It is fully manual, but since it is only once a year it should be OK. Best of luck Carlos

I managed without using ScriptMaster

Thanks Dan

Hi: How do I use "Call Script Immediately", I have looked around but found no real answer and 360Works documentation is poor (too bad because the products are great). I need the script to run when a calculated balance reaches 0 or less (overpayment). Thanks Carlos

Thanks my first plugin is working great!

Thanks, I never used that one, the Std available formats were enough for me. Since you mention 123, I still use it as my main spreadsheet, when I need to send it in Excel to somebody, I use save as :-)

Hi: Sorry for so many consecutive posts, I am 100% new to ScriptMaster Advanced When I create plugins, do I have to install them on every desktop or can they be installed in the server (or both?). I run FM Server 11, FM Pro Advanced 11 on Win and FM Pro 11 on Win and Mac. Total users 8. Thanks Carlos

HI; I created this module for currency conversion, variable "pair" = currencies in ISO format (example $ to Taiwan Dollar = "USDTWD" String url ="http://download.finance.yahoo.com/d/quotes.csv?s="+pair+"%3DX&f=l1n"; return new URL(url).getText().trim(); Returned result = 32.8200,"USD/TWD" Feel free to use it! Merry Christmas!

Hi LaRetta: Merry Christmas! I never used Field Masking, how did it work? There were also script triggers (attached macros) back in 1998 and it was incredibly easy to use as MySql front end. If it had not been abandoned by IBM it would be a wonderful product nowadays. There seem to be a few former Approach users in this forum. Carlos

OK, I found out how to do it, quite criptic and hidden. Now I will see how it goes with the 2 hour limit, I read here that it also has some problems Carlos