turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- How to automatically call a function when a column...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 4, 2013 1:25 PM
(629 views)

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Solution

This is a bit of a kluge but should work:

Let's suppose your character column is called A.

Create two hidden columns, B and C:

1. B is a copy of column A

2. C is a formula column who's formula is:

a. Do the two columns A and B have the same value?

b. If yes do nothing.

c. If no call your function, and then set the B equal to the new value of A

You might get some ideas on formula columns for step 2 from my poster: http://www.jmp.com/about/events/summit2011/protected/Poster11_PeterMroz.pdf

See section 4, where a table cell acts like a hyperlink. This approach might not be what you need, as I needed the user to just click on a column cell for things to happen.

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

This is a bit of a kluge but should work:

Let's suppose your character column is called A.

Create two hidden columns, B and C:

1. B is a copy of column A

2. C is a formula column who's formula is:

a. Do the two columns A and B have the same value?

b. If yes do nothing.

c. If no call your function, and then set the B equal to the new value of A

You might get some ideas on formula columns for step 2 from my poster: http://www.jmp.com/about/events/summit2011/protected/Poster11_PeterMroz.pdf

See section 4, where a table cell acts like a hyperlink. This approach might not be what you need, as I needed the user to just click on a column cell for things to happen.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 5, 2013 7:19 AM
(525 views)