awayand

Ugo, when I try setting the c_fieldtosort as the key to constant on the right, nothing shows up in the portal. When I do the reverse, I get the error that "this relationship won't work because c_fieldtosort can't be indexed". Any clues?

Kickass, Ugo!!! I will try that. In my previous thread about the sortkey, I edited my post and attached my latest attempt. Would you mind taking a look at it? The sort seems to work, but it doesn't sort alphabetically... Thanks!!!

Guys, is there a script step to insert a record into a portal? Here's what I want to do: When one person clicks on an item in a portal on the right, that item should be inserted into the portal on the left. (There are two portals to two different files on my layout) Any ideas?

Ok. Here's my latest attempt. Something happens, just not the right sort. any ideas? The file doesn't need its related file... Sites Example.zip

So what exactly is a sortkey?

Sincerest apologies. The password is "master".

Hey, I guess here's the problem I have. I tried implementing your approach into my little database, but somehow, the sort doesn't work. Can you guys direct me to my problem? Any help *greatly* appreciated! Sites.zip

Hi, I still don't understand. What's the concept of a "sortkey"? I noticed one of the fields in the relationship was a global. Why is that? I tried changing it to "Text", but all the entries disappeared and couldn't be revoked even when I changed back to a global. This is a really *cool* feature, but I just don't seem to get it. Any more detail on how this works? Thanks!!!

That's actually pretty cool. I don't quite understand it though. What does the self-relationship do?

Thanks! Is there a way to do this using a script step/function? Neat trick. If I can do this in a script, I can make sure the field is always updated...

I have two text fields, that are supposed to auto-fill themselves with a calculated, not looked-up value. However, those fields are empty after I imported some data. What can I do now to automatically update all those fields? I'm really stumped. Any help appreciated!

Hi guys, I have a Parent db and a child db. I created a child portal in the parent db, so that I can see multiple children for one parent. The children have some fields in them, that are calculated fields. Now I'm trying to define a sort in the relationship needed for creating the portal, but the sort should be on a calculated field. For some reason, the sort seems to be random. Do you guys know if a sort on a calculated field is possible inside a portal? Thanks! I know this is a hard one.

I am looking for a function or script step, that will allow me to go to a record depending on a value in a field. Example: I have a portal. There are entries I can click. Depending on which entry I click, a field called "selectedentry" will be filled. At the same time, I want to jump to the record that contains the value inside "selectedentry" in his primary key. It's sort of a browsing solution I'm trying to develop here. I guess I'm looking for a function, that will return the record # for the value I'm looking for in a field. Then I'd be set, because I could use the returned number with the script step "go to record by field value"... Any ideas? Thanks!

Let me clarify. I'd like to enter a number into a field. As soon as I hit the enter button, I want to execute a script, that'll take me to the record number that I just entered into the field. Do you guys have any help for me on this? Thanks!

Hello Chris, that doesn't work for me. If I uncheck "allow entry", and then create a button to use the step "go to field", the field can still not be edited. Any other ideas?

Thanks!!!

Anyone know how to activate a script to automatically execute when a user enters a certain field on a layout? Thanks for your help!

Hi guys, I want to have a button on my layout, that enables entry into a field. However, if people click into the field, entries should not be possible. I have a huge note field, that I don't want people to edit manually, but I want to put a separate script button on there, so that when people do have to edit something (Murphy's law), they can click the button. Any ideas?

Hey guys, this is fun. Anyway, I'm trying to execute a script as soon as someone leaves a field. Is there a way to do this? Also, what script step do I need to use, to deactivate all fields? For example, I have a script that clears out a field. It just inserts nothing into the field. However, I want to get out of that field, I don't want the cursor to be flashing in there. Any ideas? Thanks so much!!!!

Thanks guys! You rock!

Guys, I'm trying to put a field on my layout that is supposed to hold notes. I have a button on the layout that says: "Add comment". When a user hits that button, I want to insert text into the note field on top, with the current username, the date, and a ": ". Then the person should be able to type whatever he wants in there. My problem is that when I use the "insert" script text, the whole note field gets replaced. I guess my question is, how should I go about doing this? How do I avoid replacing text, and how do I make sure the text is inserted *before* all the other text that may already exist? Any ideas? Thanks!

Hi all, I have an issue I need help with designing. I have a database with three fields: PortID - the actual port id of the actual record PortB - the port this actual port is connected to Now what I want to do is list all those circuit portions preferably in a portal, one by one depending on which circuit I pick. Example: PortID PortB 1 2 2 3 3 4 4 5 5 6 6 - So say I click on the circuit 3-4, filemaker will know that this is actually part of a "bigger picture" and list all those circuit portions mentioned above. Problem is, I don't know how to set up the relationship to make this kind of recursive. Would I need a script for this? Another option would be inserting a third field, call it "overall circuit id", and assign all portions that one id. I'd like to avoid this approach if at all possible. The design of that is not very elegant or userfriendly. Thanks in advance for answering this tough one!

How would I set up the calculation?

Here's another one: I'd like to implement a security feature: I have records, all of which have a field called "Creator", that is automatically filled in when a new record is created. Now I don't want people to see each other's records. So when a user logs in, I'd like to use the Status(CurrentUser) calculation somehow to create an Open-Document-Script that will automatically do a find on the field "Creator" to match the current user, so that only a subset of all the records is displayed, which only belongs to the creator. How would I be able to make that possible? The "Find" script step only seems to offer "hard-coded" finds, not conditional ones (i.e. based on user input, calculation, etc.) Thanks for your help guys! (and girls, of course)

Guys, could you explain to me how I would want to use the above script step? It somehow doesn't make sense to me, and the manual is not very clear about this. Would you mind explaining the "Specify by Number" step, too? Any help greatly appreciated!