Slater

Ahh, that makes sense now! Thank you so much Comment 🙌

Yes, that's exactly what I want! I've been trying to figure out what it's doing, but I've not been able to. Is it all to do with: Choose ( Objects::Status ; 1 ) But I don't get how Status makes one layer hide or not (or go on top), can you give me a hint please?!

Sorry Comment, those are two different fields, I just wanted to show one that is "yes" and another that is "". I would want to change the colour of the radio button(s) when they are not "yes", which is therefore "". When "Yes" the have the dot within the line-circle, and I want to change the colour of the line-circle to grey when that particular field is empty. Apologies for the lack of clarity You say "note that only the fill can be modified by conditional formatting", and it's the border that I wanted to conditionally format! Oh well 🥹 Thanks

Hi Everyone, just wondering if it's possible. Here's a screen grab of two radio buttons, and I'd like to have it so that if a button is not checked (ie the button on the right), then its colour is changed to grey, rather than the blue that you can see. I don't think this is possible though? This is Filemaker Pro 19.6 Thanks for any advice

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!