Steve Martino

If I am following you correctly, I think simply the layout you copied from is bigger than the layout you are copying to, or you are pasting lower on the layout and the block of items you are pasting will extend past the bottom of your layout. Sometimes instead of using your keyboard to paste, point you mouse at the upper left corner of the layout, then paste. Everything you pasted remains selected so you can drag or use keyboard arrows to position. But once again when you get to the bottom of your existing layout and try to go farther you will get the same message. It's the same w

LOL, you're probably on your own now.

@comment Thanks!

Interesting @commentI’m not disagreeing with you but I don’t quite understand 'conceptually wrong'. Does it depend on what the user is actually doing with it? IOW, if the only reason to have a number 'checked' is to designate it as the best number to reach that client, does it matter? Or maybe a better question is what can you do with that field on the client table that can’t be done as my example shows. just curious/trying to learn. Thanks Steve

Here's part of a simple phone portal. Checking the box marks that number as main and moves it to top of portal. Also has auto formatting and error checking.Simple Phone.fmp12 You can do the same basic thing with emails.

I fell into this vortex when I redid my business solution with FM16 a few years ago. I think I know what you are going for. The problem for me was it got so complicated (for me) with all the script triggers, and global variables, and calculations, that adding/editing layouts became such a headache. It wouldn't always refresh, or if on panel had a portal, that would cause a hit/delay. Sometimes refresh object/refresh portal, refresh layout wouldn't work consistently. I ended up abandoning that and continuing with simpler layouts.

For some reason I posted 6 hours ago and it disappeared. Your link doesn’t work. Seems to be a spelling error 'collage' instead of college?

If you're trying to prevent a user from opening the database after a certain date, this won't work if the user opens up FileMaker, then Script Debugger and Data Viewer, opens your file and changes your $$Demo, then runs/exits the script.

It's a whole new world now... https://store.claris.com/product/PMO

How do you want to present the data from the portals? If it's one, then the other, then repeat, seems like a looping script where you gather want you want thru GTRR from the first portal, then switch layouts, do the same, then repeat, which would create what many use and call a Virtual List. Edit: Just saw @Ocean West answered right before me.

You stumbled upon a well known technique discussed many times on the forums regarding entering find mode. I don't quite understand your need for an empty set. Are you looking for a record, then if you don't find it, you are creating a new record? As far as duplicating code, this blog may help. http://www.philosophyoffilemaker.com/robust-filemaker-design-87

One thing to rule out. I had similar problems with a database. I was recovering, using backups, rebuilding, still getting lock ups. One thing I did, and then it never happened again was to clear my Data Viewer, Watch tab of all calculation after I'm done experimenting with them (and moved them to a reference database). I was the DV to keep complicated calculation for this database and other db's I was working on. Many SQL calcs, as I just couldn't get the hang of the syntax and was experimenting with them. Now I can't say if it was a coincidence. But it hasn't happened again wi

I add a Show Custom Dialog message before the exit script step to remind you, or a user that there's a script that needs to be enabled. Otherwise someone may be clicking a button and think something is happening when it isn't. For example a button that shows customers with past due balances, etc.

Your script doesn't print. How do you determine which report is first or second. Basically... -Get the right record. -Print Setup //with correct parameters -Print -Go to other record -Print Setup //change parameters -Print. Something that may help as your solution grows, is you may want to make dedicated separate print scripts, one for each orientation, and one for current records, current found set, for each printer. Because at some point, you're going to get a new printer, and then you'll have to hunt thru the entire solution looking for all your

I’m confused by your question. Do you have an existing database and want to import this data, or do you want to create a database to mimic the spreadsheet?