Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Select Specific Portal Row


Peter Ardis
 Share

Recommended Posts

For Educational Context.

Two Tables. SpellingWords and SpellingLesson.

 

SpellingWords stores as records all the Spelling Words and related data. This table has fields for Word, Definition and WordType (noun, verb etc.).

 

In the SpellingLesson table I type a word, i.e. "light", and a SpellingWord portal shows the information for the specific word.

 

My portal has a scroll bar so that the definition for "light" (i.e. not heavy) show up as well as the definition for light (i.e. not dark).

 

The Problem:

I need to be able to bring only one specific definition that I select from SpellingWords onto the SpellingLesson Table in order to create a lesson with it and I cannot figure out how to select a specific portal row (i.e. not heavy) and make that data available in the SpellingLesson.

 

I have tried buttons on the portal row, but cannot get the script right. If the word has only one context/meaning such as "luddite" SpellingLesson table currently works fine.

 

 

This seems like it should be quite simple. Thanks in advance for you help.

Link to comment
Share on other sites

By "select" do you mean "in a script", i.e., literally GO TO a portal row and cause it to be the active portal row and then set other fields or parameters to its vaue? Or do you mean "within calculations or relationships", e.g., creating references within your structural definitions that reference a specific portal row? In other words, verb or noun?

Link to comment
Share on other sites

I want to "... cause it to be the active portal row and then set other fields or parameters to its value".

 

I will need to browse/scroll the portal rows that occur when I type "light" in SpellingLesson::Word. When I see the word that I want in SpellingWords portal, I want to be able to select a specific record/word/portal row and cause it to be part of the Lesson. For example make the definition in SpellingWords "light" (i.e. not heavy) become the active definition in the Definition field in the SpellingLesson.

 

Hope this makes sense.

Link to comment
Share on other sites

So it will include user intervention ("user" meaning YOU)? As in YOU PICK which portal row is the relevant one?

 

I'd stick a button in the portal row itself; it should do something like this:

 

Set Field [Lesson::Definition; PortalTable::Definition]

 

When you click on it, the specific portal row for PortalTable::Definition is the one that you click on. That is, you will see the button over and over again, once per portal row, and it "knows" which portal row's "copy" of the button you clicked on.

Link to comment
Share on other sites

Where does the "Set Field [ Lesson::Definition; PortalTable::Definition " go? As part of a Case calculation in a script? If it is part of the script for the button field, what is the field that I specify? I assume the definition in the lesson table.

 

I have tried a few things but nothing yet.

Link to comment
Share on other sites

This is a button-function, or a single-step script assigned to your portal's button:

 

Set Field [Lesson::Definition; PortalTable::Definition]

 

 

 

(PS The smilies are not intended.)

there's a checkbox in "Advanced" post on this board that lets you disable smilies

Link to comment
Share on other sites

This is a button-function, or a single-step script assigned to your portal's button:

 

Set Field [Lesson::Definition; PortalTable::Definition]

 

 

 

there's a checkbox in "Advanced" post on this board that lets you disable smilies

 

Allan - I think smiley-undecided the question was "what does the "set field" do in this case? Oh Really!

 

Ahunter is suggesting a command that takes the field content from the portal field called "Definition", and writes it to the lesson field named "Definition".

Link to comment
Share on other sites

Yes, sorry. I assumed someone with "Intermediate" skills knew what Set Field does!

 

I'm afraid that sometimes when I describe something, because HECK, I know what I'm referring to, I don't realize it isn't self-explanatory to the folks I'm conversing with.

Link to comment
Share on other sites

Okay I got it. Thanks. A very useful tool, if I only had have known about how the set field works I could have saved myself hours. Now to rewrite the database....

 

What I did not know was that the first definition field referred to the Specify option and the second definition referred to the Calculation option. That is what I meant by where does it go?

 

I will down grade my level from "intermediate" to "loser".

 

Truly thankful.

Link to comment
Share on other sites

I will down grade my level from "intermediate" to "loser".

 

And I, in turn, will take a refresher course in Tact :o

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use