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

Sort related records only


redzwanlatif
 Share

Recommended Posts

Hi . I have staff list records. It's divided into 2. Male and female.I'm using radio button for male and female choice. How can I sort only Male staff on the list?

 

Thanks in advance :)

Link to comment
Share on other sites

You can GO TO just the male staff and then sort them.

 

Is that what you mean?

 

Or do you want the final result to be a mixture of male records (sorted) and female (not sorted)? (that would be do-able but it seems kind of weird)

 

 

To isolate the male recs only, either do a Find like so

 

Set Variable [$Gender; YourTable::RadioButtonField]

Enter Find Mode

Set Field [YourTable::Gender; $Gender]

Perform Find

 

 

... or set up relationship between the RadioButtonField and the Gender field and do this:

 

Go to Related Records [show only related, ThatRelationship]

 

 

either way, then you sort.

Link to comment
Share on other sites

Please clarify: do you

 

a) want to LIST only the male records (the female records NOT BEING on the screen any more at this time) and sort the male records? or

 

b) somehow, in some unexplained fashion, end up with both male and female records on screen, but the male records sorted and the female records interspersed among them, somehow, NOT sorted

 

??

 

 

AND

 

please clarify also:

 

The scripts are not working

 

 

In what way are they "not working"? Are you getting male records but not sorted? Are you getting an error message? Are you getting male and female records sorted? Are you getting pink kitty cats and orange snails eating your computer screen? something else?

Link to comment
Share on other sites

a) want to LIST only the male records (the female records NOT BEING on the screen any more at this time

 

Scripts:

Female records are there

Link to comment
Share on other sites

  • 2 weeks later...

 

Set Variable [$Gender; YourTable::RadioButtonField]

Enter Find Mode

Set Field [YourTable::Gender; $Gender]

Perform Find

 

 

 

I've used Set Variable [$Gender; "Male"] instead of Set Variable [$Gender; YourTable::RadioButtonField] and it's worked. Thanks for the answer. :)

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use