Slater

wow Comment, you have an incredible archival knowledge of FM! 🙌 I've had a look at it, and it mainly seems out of my understanding, but I'll come back to it over the weekend and see if I can get things going! All the best

Thanks Comment, I'd found this: https://community.claris.com/en/s/question/0D53w000054L1ihCAC/setting-line-spacing-with-a-script-possible Which was similar, though it's about being able to format whole fields and I'm trying to just use particular sections within a field's text. and you might have been thinking of this: https://community.claris.com/en/s/question/0D53w000069UD1tCAG/soft-return-in-calculated-field-text which is about using a calculation field, which doesn't work for me (though I don't really understand it!) Thanks though, and all the best,

Thanks for getting back to me Fitch, and I guess I'll just keep going to the menu to do it! All the best

Hi Everyone, I've a script to change the colour of some selected text, and in that vein I'd like to make one that changes the line spacing so that I can have indented paragraphs that look like bullet point lists, is this possible? The way to do it long hand is to go Format > Line Spacing > Other, and in my case it would be Left 0.8 and First -0.3 (as attached screen grab), but I can't figure out or find any answers on the web if it's possible to do this via a script, for the selected paragraphs / text? My FM version is 19.6.3 Many thanks for any ideas

Thanks Comment, much appreciated

Hi Everyone. So I used to do this with the Character Viewer which is Cmd Ctrl Spacebar, but that no long brings up the Character Viewer in FMP (tho it does other apps). 2 Qs - is there a way to bring the Character Viewer back to live - using a scrip such as Insert Text, is there a way to give a script a specific keyboard trigger, ie Option 9 or Option 0, rather than this number just come based on how many other sripts I have in play? That way I can have the script trigger be the same in different files, rather than have 8 empty / dummy scripts using up the slots, so that then I can have the ones that I wan as Option 9 or 0. Cheers, and thanks in advance

Yes, in my regular language counting from and scanning are more or less the same thing. Apologies, I should have said scanning from the right

Comment, now that makes total sense! So it's always about the position of the character from the LHS even if you're counting from the RHS. Thank you so much, such a simple answer but one that caused me so much head scratching!

Hi Everyone, I guess I'm doing something stupid! I'm trying to find a character in a string, working from the RHS. Position ( "123456789" ; "7" ; 9 ; -1 ) returns the value 7. And I had thought that it would return 3, as starting from the RHS (due to the -1) 7 is the 3rd character. Position ( "123456789" ; "7" ; 1 ; 1 ) gives me 7 Position ( "123456789" ; "7" ; 1 ; -1 ) give me 0 Position ( "123456789" ; "7" ; 9 ; 1 ) gives me 0 Checking it with different numbers, Position ( "123456789" ; "2" ; 9 ; -1 ) returns 2. Again, I had thought that it would give me 7 as that's the 7th digit from the RHS Can someone tell me what the function should be so that it counts from the RHS? Many thanks

Thanks Søren, I'm all sorted now, but it was an interesting read! Cheers

Haha, yes, true! Thanks for your help. I implemented a solution to it using a temporary marker in People that could be counted within one of my current Company layouts, so that I could then order the Companies appropriately. Appreciate your help

Thanks for your reply Comment. Why I'd like to do it - I've got one Table with Companies, and one linked Table with People. I want to find records within the People table that have [x], and then I want to go to the Companies table and see how many [x] People there are per Company, so that I can then fix the issue, starting with the Companies that have the most number of [x] People. My go to was the second method you stated, but I was just hoping that there was a Get(x) that would flag those People's records that were in the found (ie current) set. This is in a single user environment, so noted what you said about multiple users. Much appreciated, thank you

Hi All! Stumped on this one! Is there any calculation that would let me mark if a record is in the current found set? So, if I've a database of say 100 files, I then perform a find for something, and that results in 30 records - is there any calculation that I can have so that those 30 records are marked, and the others aren't? I've had a look through all the Get (x) and the other expressions, and I can't see one that would fit the bill. I could do it via a loop to mark the found records, but then I'd have to invert the selection, and clear that marker, which is more of a fuss than just being able to find if they're in the found set. It would get tricky if there were two windows open on the same records, with different windows having different found records, and so this might never have been made possible ... but wondering if there's a function for this? Cheers

How I've now got it set up works perfectly, thank you. Can you tell me how it works, I can't readily see how Set Field "\"*S\"" actually inputs "*S" into the field. As per the above, I don't know the syntax of what it's doing. I tried this but Set Field wouldn't take it. Thanks though

Thank you Comment for replying to me. And apologies for not being more clear. I have the need to perform a find on a set of records. The string that I want to search for is *S. I want to do this via a script. So I was running into problems when I was using Set Field within the script, because as you say But your suggestion to use within the Set Field works perfectly, and means that I get the whole of the string that I want to be used within the Find! Thank you very much for that little piece of magic

Hi All, Probably a no go - but what I want to do is insert "*S" into a find request via a script - but keep the "s. So all of this →"*S"← is input via the script. Of course, when I script it: Set Field ""*S"" then it thinks it's inputing "" & *S & "" which doesn't work. Is there a way to do this? Thanks for any tips

Thanks, that second approach was the basis for my first attempt. I've got it working now, thanks so much again

Thanks Comment, so kind of you to reply. I've got it working, probably a cludge, but I did want to reply to your post with the information you asked for. So the Tables and Relationships are as follows: Table 1 - Events Table 2 - Activities Table 3 - People The portal is within the Events window, and it is a list of Activities. The portals also have some limited info brought over from the People table. They're linked together with the following relationships: Events & Activities: joined by ID_Event Activities & People: joined by ID_People The portal within the Events window shows Activities information that they did at that Event. I can sort the portal via things like which Activities they did, how many times, if they gave +ve feedback about the event etc. And I can highlight certain rows of the portal, ie if they gave the event more than 5 out of 10. But then I want to bring look at all the highlighted portal row's People in a different window, the People window, which is easy enough. And then I'd like to sort those people in that window, so that they're in the same order as they are in the portal. Their portal row number I'd got via Activities Get (RecordNumber), and that showed correctly in the portal. But when I looked at the People window, that same field was always 1. The same filed would show the correct portal row when in the portal, but 1 when in the People window. I sorted it in the end by having a field called Portal Row Number, looping through the portal rows, and just increasing each portal row by x+1. Because that was just a simple number, it was easily viewable in the People window. I was sure that there'd be a more simple way to get that portal number number across, so that was the question. Thanks though Comment, all the best

Hi All, so writing all that above must have helped me! I've gone with the Loop method, but looping on the portal row rather than going into the different Table etc, works quite well, and hopefully won't be too time costly with large portals! If there is a better way though, do let me know

Hi Everyone, Bit of a head scratcher. I've got records (Table 2) in a portal on the page of Table 1) and that is sorted. The order of those records can be shown using a field Order_Number, set as a calculation of Get (RecordNumber). However it all starts to go wrong when I want to use Order_Numer in a Table 3. Order_Number always comes up as 1 in that Table 3 ... I'm presuming that for each record in the Table 3, it's in 1st place, as it's the only record that is being seen - so they all have the same first place, ie Get (RecordNumber) is always 1. I want to sort the Table 3 in the same way as the portal is (the sort in the portal is very complicated, and so i can't just export that calculation to the Table 3). I've tried unique relationships, putting the calculation as text and a few other things, but it always comes out as 1. To fix it, I can only think of having a Loop in Table 2, goto first record, enter LoopNumberRecord as 1, and add through to it with each loop, so that I've got a hard coded figure for each record in Table 2, and then go to Table 3 and sort using LoopNumberRecord. But this isn't as simple as just being able to use Order_Numer from Table 2 in Table 3, because I'd like to call it up without going back to the Table 1, finding the relevant records in Table 2, and doing the Loop calculation. Is there any other way? Hope the above makes sense!! Cheers

Thanks Comment, much obliged for your response. Yeah, for the life of me I was trying to make the layout be 'based' in the Pictures Table, but I could only base the layout in a relationship (ie Show Records From: in the layout set up) but I just couldn't get that to work, it was always via a relationship. I realised the GTRR had a direction, and that my script was going in the wrong direction. Because of the wording in the GTRR script saying "Go To Related Record From" I never played with that as it seemed sensible that this was listing the Table that I was going from. Turns out that if I set "Go To Related Record From" to the Table that I would like to go TO, then it works. That was what was throwing me, if it had said "Go To Related Record TO" I would have figured it out immediately!

Solved! Can't see how to delete this post so ... I had thought that "Go To Related Record From" mean the records that you were going From ... turns out it's the records that you're going To! 😳 ✌️ 🥳 Hi Everyone, Hope you can help as I've been banging my head against this one for over an hour, and I just can't figure it out! (I'm on FMP 16) I have two tables: People & Pictures They're related by a relationship called People_Pics_Relationship, and in that People::ID_Person = Pictures::ID_Person I have a layout called "Pics" based on this relationship People_Pics_Relationship, filled with fields the Pictures Table, and a script that says: Go To Related Records: related record from: Pics, show only related records, match all in current found set. So when I run that script in a layout based on the People Table, it takes me to all the related records from Pictures Table, but when I run that script in a layout based on the Pictures Table, nothing happens. It's like it will go in the direction that I don't want, but won't go in the direction that I do want! Can someone help point out what I'm doing wrong, as I guess it's something really simple, but I just can't figure it out! I'm guessing that the layout is based in the People Table somehow, rather than the Pictures Table, but I can't figure out how to switch things around. Many thanks

Hi Guys, thanks so much for getting back to me and apologies for my delay. So, the problem is not so much that it runs slowly on her machine, but that after a time it kinda grinds to a halt. That could be after as little as 5 mins, or as long as an hour or two. But before that happens, it's all going along nicely enough. And that delay in it slowing down to a halt, leads me to think that the load on the host machine (my Mac) isn't the culprit, because the system can be scooting along nicely for a couple of hours. Typically, if she's going from one record to another in a found set, then her computer can hang for even a couple of minutes, while most of the time to do so would normally take a second. One strange thing that is visible when this happens is that there are a succession of pop up dialog boxes, but off the top of my head I can't remember what they say. I'll take some screen grabs next time (though I'll not be at my desk computer for the rest of the week, but I'll post a grab once it happens again). Undoubtably, the DB could have been written better - it's grown over many years and has quite a few oddities in its methods, but I don't think that that is the culprit because otherwise it should be a constant problem. When the slow down occurs, sometimes just restarting her FM can solve the problem, though sometimes it takes me to restart my FM, but even sometimes we both need to restart the computers. Is FM Server a separate app? As a solution, I could perhaps host the DB when she's with me using FMP, and then if I'm away I could host the DB with FM Server? If FMS didn't solve the problem, would that point to a network issue? Both of my Macs are up to date and attached to a switch (un-managed) and then the switch is attached to an Netgear Orbi router. The router is new as I thought that my old Apple airports could be to blame, so I changed them out for the Netgear system. Though I am running FMP16, which could be the problem. As I need to buy the app for 3 seats, as a sole trader the cost is very high, and so I'd like to wait for the release of FMP19 to upgrade my FM copies. Thanks for any of your thoughts!

Hi Everyone, Looking for a bit of advice - I'm using FMP16 on two computers here at my place. I host the DB and then a person who comes in to work for me uses Open Remote to access the DB on the computer that she's working on (my second computer, both Macs). I've had no end of problems with this - the DB is very slow on her computer. I've worked around that a number of ways, but each one falls down sooner or later. Anyway - the issue is that she needs to be in here this week, while I'm not able to be here. The last time this happened, the DB ground to a complete halt, everything was so incredibly slow, that I paid her for a half day of doing nothing, essentially. (She couldn't get into my computer to restart and then host the DB on FMP.) In terms of what I could do while she's here and I'm not, * I could just put a copy of the DB on her computer, but then she'd be able to copy it, say to a USB. I don't think she would, but as it has very important personal info on it, I'd like that not to be a possibility. Also, her user is locked out of those parts of the DB, but none the less, that's something that I'd like to not be possible. * If it were windows, I believe it's possible to set a folder so that it can't be copied. And so I'm out of ideas! Is there any advice anyone can give me on 1. allowing her to access the DB, while 2. her not being in a position to copy the DB, and 3. me not hosting the files on my computer? Many thanks for any help! Cheers

Hi Everyone, So here's one that's either really easy and I've missed it, or it can't be done! I'm printing address labels, and the 7 rows that I'd like to print take up the whole label layout, and so the first one is located at the top of the label in the layout, and the bottom one is at the bottom of the layout. If the label only has 4 rows, then those 4 rows are printed at the very top of the label. To make things pretty, I'd like to have them centered within the label. Is it possible to have the block of text center itself, so that there is the same amount of blank space both above and below it, rather than having all of the space below it? Many thanks in advance!