Hi all
Our Dev dept want to be able to track a 'referring member' ID when processing a new membership through Contribution module, so that the referrer can be registered for benefits of some sort. They hope to be able to associate the info to the Contribution as some kind of structured note, rather than just as an Association between the two Constituents.
I suspect this is not possible but thought i'd ask - can i do a Custom Tab element through t_keyword that somehow replicates the Constituent Search chiclet that is possible on a Custom Screen?
Thanks
Peter
You can’t add any sort of chicklet to custom tab elements in contributions or orders, but you can build a dropdown based on data from the current constituent. If the “referring member id” is associated to the constituent by some means (either using associations or some other relationship), you could build the dropdown using that table (or a view to construct the const name for display) and filter by FS_GET_PARAM_BY_APPNAME(‘CT’) to get the current constituent for the contribution/order.
I don’t know if this helps or not, but thought that option might spark a potential solution. If the “referring member” is added as an association, or some other means, you could easily build a distinct list of constituents to select from based upon this data.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Peter NelsonSent: Thursday, May 05, 2011 7:49 PMTo: Ryan CrepsSubject: [Tessitura Technical Forum] Constituent Search from Custom Tab
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Unknown said: filter by FS_GET_PARAM_BY_APPNAME(‘CT’) to get the current constituent for the contribution/order.
Hi Ryan,
I'm trying to figure out a similar custom field for contributions: I want to be able to offer a list of ticket order numbers associated with the constituent. Right now I have:
Description: Ticket Order
Data Type: Number
Edit Mask: None
Ref Tbl: T_ORDER
Ref Idcol: order_no
Ref Desccol: convert(varchar, order_no)
Ref Where: customer_no = !.customer_no (not working)
Ref Sort: order_dt desc
Use for List: Contribution
Custom Id: 1
Ideally I'd be able to show order number and date and or paid amount in the pulldown, ultimately storing the order number. Is this possible? Also, not seeing that function in my database.
Hi Gawain, The function is FS_GET_PARAM_FROM_APPNAME. Have you tried altering the 'Use for List' to 'Order'?
Debbe
Ah, that's it. Maybe there's some documentation in the function to explain the context it works in...it doesn't work in a simple T_CONTRIBUTION query.
I definitely don't want to change it to Order, since I need it to appear in the Contributions custom tab.