Skip navigation
Currently Being Moderated

customer specific web app item value?

Apr 24, 2012 12:47 AM

The client is a fund manager. The goal is to have a secure zone to which investors log in to see the value of their investment, where the fund in which they own units, the quantity of units, and the total $ value of units owned (investment value) is listed - could be entire history or just one line being current value.

 

A simple web app won't work, because that would show the same value to all customers. What I'm looking for is kind of the functionality of cases, or orders - being able to provide a customer specific case or order within the secure zone - but pertaining only to the customer's holdings in a specific fund.

 

The closest I've gotten is by creating a catalogue called Funds, and a product called for example, Resources Fund One, allocating a price of say $20,000 (being per unit $ value).

 

I manipulated the order layout thus:

 

<table class="order-list" width="100%" cellspacing="0" cellpadding="0">

    <tbody>

        <tr>

            <td><strong>{tag_ordername}</strong></td>

            <td> <span class="date">{tag_createdate}</span></td>

            <td><span class="total">{tag_invoicetotal}</span></td>

        </tr>

    </tbody>

</table>

 

and inserted it in the secure zone member page:

 

Investments held:

{module_order,a,,Default}

 

 

and manually created an order for a customer, specifying how many units of the product Resources Fund One purchased, to show on customer login:

 

Investments held:

Resources Fund One24-Apr-2012 04:42 PM$250,000.00

Create date could instead be last update date. The order name (which in this case is also the manually typed product name) has a system link to invoice (I can edit the invoice to output some other data - like fund details perhaps), but to update customer investment values, my client will have to manually create a new order, or edit the existing order for every single customer, typing in the fund name, unit value and number of units held, each time, for every single customer. The margin for human error is too great. It needs to be a system update.

 

So I don't think using the product and order process is going to work. Although how that module outputs to the member landing page is what I want.

 

The web app module looks like it could best serve this purpose, but I'm stuck on how to make this work in terms of customer-specific output and updating of unit $ value.

 

Ideally, the client will update the unit $ value in a single web app item field (a different web app item for each fund) once each day, and that automatically updates customer data in the secure zone to reflect the new value of customer holdings.

 

Hope I'm making sense. Any ideas?

 

Or.... would I just do a new web app item every single day, and have the output be module_webapp,latest,1? That would at least give current value per unit. If I have to write some javascript for equation, can I inlude the module_webapp,latest,1 within the javascript as one of the computable values?

 

Has anyone else done something similar? Any experience in coding javascript using modules?

 

Many thanks.

 
Replies
  • Currently Being Moderated
    Apr 24, 2012 3:51 PM   in reply to DigiPubs

    On your web app items, under more options, you can set 'Submitted By:' on each web app item to be the customer the information is related to.

     

    Then in the secure zone use the web app module {module_webappscustomer}. http://kb.worldsecuresystems.com/134/bc_1345.html?bc-partner#main_Web_ App_Modules

     

    This way people logged in can only see their specific web app items and the information can be unique to each customer.

     
    |
    Mark as:
  • Liam Dilley
    4,054 posts
    Feb 28, 2012
    Currently Being Moderated
    Apr 25, 2012 4:35 PM   in reply to DigiPubs

    Can I ask why your not using cases for this?

    We have built pretty much very similar and using Cases, web forms and Custom CRM stuff.

     
    |
    Mark as:
  • Liam Dilley
    4,054 posts
    Feb 28, 2012
    Currently Being Moderated
    Apr 25, 2012 7:06 PM   in reply to DigiPubs

    - Cases created manually? - No

    - Cases are much more then records of forms and forms do your calculations

    - Basically everything you have indicated we have done for very similar companies using forms and cases and the issues your bumping heads with are solved with the extra elements you get with cases and the forms.

     

    If you want to go web apps still your not going to solve the issues you have and I am sorry I can not help you there, as I have/would suggest the route I did. If you not found that useful for you I am sorry but I know it works.

     
    |
    Mark as:
  • Liam Dilley
    4,054 posts
    Feb 28, 2012
    Currently Being Moderated
    Apr 25, 2012 7:48 PM   in reply to DigiPubs

    Can you first please explain what you want the system to auto update?

    You want one unit value to update all of a given value for all customers throughout the system?

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (1)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points