We are trying to integrate a jQuery grid in a Visualforce page, but also want to be able to place on it, the ‘view’ drop down, so users can access the custom list views that they have built, and have the data and columns returned and bound to the grid. Were doing it this way (btw) so we can leverage some of the more powerful sorting features of the jQuery grid.
Thus far we have been having an assortment of issues, and thought we'd post out to the wider comm to see if anyone could help.
We have been able to build a custom drop down and make a request for a list of available views on an object, to populate it, but we can’t find a way to draw on the SOQL query that is behind each view, so we are unable to run anything to produce the array of data that can be bound to the grid.
What would really solve the problem for us, is to be able to do either of the following
A) Find a way to request the SOQL statement that is executed by the view, so we can run it when the corresponding view is selected in our custom list controller drop down. This will allow us to return an array of data that we can program against to bind to the grid
Or
B) Get the standard list controller to return a format that we can program against efficiently.
Does anyone out there have any experience of these issues?
We are looking for some help with integrating a jQuery grid into a visual force page, and want to leverage the inline editing capabilities.
We’ve stumbled into a problem whereby a user may want to inline edit a field that is populated by lookups, and so we need to be able to trigger the lookup dialogue, and capture the selected value for re-inputting back into the cell of the grid, prior to postback.
Does anyone have experience of this issue, and is able to offer pointers, or know of any documentation, blog posts, beer mats, cigarette packets etc that might contain such information.
We are integrating a jQuery grid into a visual force page, and want to leverage the inline editing capabilities.
We’ve stumbled into an issue whereby a user may want to inline edit a field that is populated by lookups, and so we need to be able to trigger the lookup dialogue, and capture the selected value for re-inputting back into the cell of the grid, prior to postback.
Does anyone have experience of this issue, and is able to offer pointers, or know of any documentation, blog posts, beer mats, cigarette packets etc that might contain such information.
Hi everyone, we’re scratching our heads a bit on integrating a custom JQuery grid into our VF pages, and are looking or some help.
We are trying to integrate a jQuery grid in a Visualforce page, but also want to be able to place on it, the ‘view’ drop down, so users can access the custom list views that they have built, and have the data and columns returned and bound to the grid. Were doing it this way (btw) so we can leverage some of the more powerful sorting features of the jQuery grid.
Thus far we have been having an assortment of issues.
We have been able to build a custom drop down and make a request for a list of available views on an object, to populate it, but we can’t find a way to draw on the SOQL query that is behind each view, so we are unable to run anything to produce the array of data that can be bound to the grid.
What would really solve the problem for us, is to be able to do either of the following
A) Find a way to request the SOQL statement that is executed by the view, so we can run it when the corresponding view is selected in our custom list controller drop down. This will allow us to return an array of data that we can program against to bind to the grid
Or
B) Get the standard list controller to return a format that we can program against efficiently.
Does anyone out there have any experience of these issues.
We’re wrestling with a concept, and need to know if we can use authenticated sites to solve it or do we need use a customer portal which may prove to be cost prohibitive.
We’re an ad network, and have 1000 or so advertising partners which we need to pay, for displaying advertisements on their websites, on behalf of clients. These ad partners exist as a record in an object ‘ad partner’, and an ad partner can have 1 or many websites, represented as records in another object ‘partner sites’.
In process terms, the ad partner is required to take the ad (usually a banner or some graphic), put it on their site, and let us know what site and where on their site they have put the ad in terms of URL, so we know its live, and can monitor it, and pay them according to their agreed rate.
From time to time we may discontinue these ads, change them over to new ones, or give them additional ones, and so need to communicate this to them as a new ad request, changeover, or discontinuation.
We also prepare self bill invoices for them to us on their behalf, and send them a copy, before paying them at the end of the month to their registered bank details, which are held on the ‘ad partner’ record. Payment is currently handled though MS dynamics which produces the invoices and sends on a payment file to the bank. (less than perfect but thats a whole other story)
Some work flow is required between us to manage the communication, escalate failures to respond, notify of issues etc, like ‘you haven’t given us your bank details yet’, or ‘they are incorrect’, or ‘you haven’t reported an ad as live yet’ etc etc. They may also wnat to view their invoices and download them for their record.
This requires them to be users so we can expose the objects to them as an account management site, and configure the work flows.
The obvious solution is partner/customer portal licenses, however...
these interactions between us and each ad partner are very limited, and infrequent. For example after sending them the initial request to put an ad live, they may log in a few times, and then potentially once a month to check they’ve been paid or download or pick up their invoice, or submit a case if there’s been an issue.
Also some partners may sit dormant for a long period before and between ads
Paying an ongoing license for each partner seems like a prohibitively expensive solution for such a task, and so wanted to know if the same could be achieved using ‘authenticated sites’ or some sort of pay per use.
I’m trying to create a roll up summary of a field on 1 object, that is created by a Formula, that looks up to another object, but the fields dont appear in the aggregate drop down, when I try to create it,
basic background is that I have 3 objects.
Advertising Goal. An advertising goal that we need to achieve,
Ad spots. We may have to buy multiple ad spots to fulfill the goal
Websites. Ad spots exist on other websites. We may have to buy 1 or more spots, on 1 or more of the websites.
Advertising goal and websites are both currently master objects to the ad spot, since ad spots and their stats need to be rolled up to view at either level. ie how many spots have we bought on a website, how many spots are we using to support an advertising objective.
Ad spots also have an ‘ad type’ which is a picklist of 3 values. Button, banner or text link. Each website may charge differently for each type of spot, and the record for what they charge is held in 3 fields on the website’s record, called button rate, banner rate and text link rate.
To set how much the spot is going to cost on the ad spot record, we have a ‘monthly rate’ field, where we have developed a case function that references the ‘type’ picklist on the ad spot record, and depending on which value is specified, looks to the website record and returns the appropriate field value. Formula is below.
CASE( Placement_type__c ,"button",Partner_Website__r.button_Rate__c,"Banner", Partner_Website__r.Banner_rate__c,"Text link Ad" , Partner_Website__r.Text_Link_Ad_Rate__c, 0)
We’re happy with this at least and it seems to work.
However, now we need to know how much the advertising goal is going to cost from having secured all these ad spots, so we need to create a rollup summary field, that sums the monthly rate field, across all the associated placements.
When we try to create a roll up summary though, the Formula fields do not appear.
I'm hitting a wall with this as I'm not a programmer and just don't have the skills to work around, and SF support can’t help me either. They ahve suggested that you can't roll up formulas that involve other objects. So I would love to hear from anyone that can explain what is going on, and offer a solution.
...plus of course a respectable contract rate, if you can help us with our force.com development.
We're one of the fastest growing digital marketing agencies in the UK, and due to our growth, we are trying to rapidly develop more advanced systems to manage and enforce workflow and business process, share data, and give transparency across our business.
Whist we're fans of users of salesforce, and technically adept, our ability to customize the force.com platform to our exacting needs is limited, and is far exceeded by our visions.
Hence we need a personable and highly experienced developer / consultant with a sleeves up, hands on, get stuck in attitude to help us with the following.
configuring complex workflow, and approvals
Developing database schemas, custom object and fields, and supporting relationships
Writing custom formulas and code to drive complex data and reporting needs.
Utilizing the API in both directions
Customization of front end design (not essential, although useful)
understand and integrating with other platforms we've already developed in the Microsoft environment.
The successful candidate will have the opportunity/misfortune to be working directly alongside me, and liaising directly with other over worked, stressed out, highly caffeinated, biscuit abusing stakeholders across our business.
Candidates will be required initially, to work most oft he time in our offices in the City of London, EC2A. Our nearest station is Liverpool Street.
...plus of course a respectable contract rate, if you can help us with our force.com development.
We're one of the fastest growing digital marketing agencies in the UK, and due to our growth, we are trying to rapidly develop more advanced systems to manage and enforce workflow and business process, share data, and give transparency across our business.
Whist we're fans of users of salesforce, and technically adept, our ability to customize the force.com platform to our exacting needs is limited, and is far exceeded by our visions.
Hence we need a personable and highly experienced developer / consultant with a sleeves up, hands on, get stuck in attitude to help us with the following.
configuring complex workflow, and approvals
Developing database schemas, custom object and fields, and supporting relationships
Writing custom formulas and code to drive complex data and reporting needs.
Utilizing the API in both directions
Customization of front end design (not essential, although useful)
understand and integrating with other platforms we've already developed in the Microsoft environment.
The successful candidate will have the opportunity/misfortune to be working directly alongside me, and liaising directly with other over worked, stressed out, highly caffeinated, biscuit abusing stakeholders across our business.
Candidates will be required initially, to work most oft he time in our offices in the City of London, EC2A. Our nearest station is Liverpool Street.
We’re wrestling with a concept, and need to know if we can use authenticated sites to solve it or do we need use a customer portal which may prove to be cost prohibitive.
We’re an ad network, and have 1000 or so advertising partners which we need to pay, for displaying advertisements on their websites, on behalf of clients. These ad partners exist as a record in an object ‘ad partner’, and an ad partner can have 1 or many websites, represented as records in another object ‘partner sites’.
In process terms, the ad partner is required to take the ad (usually a banner or some graphic), put it on their site, and let us know what site and where on their site they have put the ad in terms of URL, so we know its live, and can monitor it, and pay them according to their agreed rate.
From time to time we may discontinue these ads, change them over to new ones, or give them additional ones, and so need to communicate this to them as a new ad request, changeover, or discontinuation.
We also prepare self bill invoices for them to us on their behalf, and send them a copy, before paying them at the end of the month to their registered bank details, which are held on the ‘ad partner’ record. Payment is currently handled though MS dynamics which produces the invoices and sends on a payment file to the bank. (less than perfect but thats a whole other story)
Some work flow is required between us to manage the communication, escalate failures to respond, notify of issues etc, like ‘you haven’t given us your bank details yet’, or ‘they are incorrect’, or ‘you haven’t reported an ad as live yet’ etc etc. They may also wnat to view their invoices and download them for their record.
This requires them to be users so we can expose the objects to them as an account management site, and configure the work flows.
The obvious solution is partner/customer portal licenses, however...
these interactions between us and each ad partner are very limited, and infrequent. For example after sending them the initial request to put an ad live, they may log in a few times, and then potentially once a month to check they’ve been paid or download or pick up their invoice, or submit a case if there’s been an issue.
Also some partners may sit dormant for a long period before and between ads
Paying an ongoing license for each partner seems like a prohibitively expensive solution for such a task, and so wanted to know if the same could be achieved using ‘authenticated sites’ or some sort of pay per use.
I’m trying to create a roll up summary of a field on 1 object, that is created by a Formula, that looks up to another object, but the fields dont appear in the aggregate drop down, when I try to create it,
basic background is that I have 3 objects.
Advertising Goal. An advertising goal that we need to achieve,
Ad spots. We may have to buy multiple ad spots to fulfill the goal
Websites. Ad spots exist on other websites. We may have to buy 1 or more spots, on 1 or more of the websites.
Advertising goal and websites are both currently master objects to the ad spot, since ad spots and their stats need to be rolled up to view at either level. ie how many spots have we bought on a website, how many spots are we using to support an advertising objective.
Ad spots also have an ‘ad type’ which is a picklist of 3 values. Button, banner or text link. Each website may charge differently for each type of spot, and the record for what they charge is held in 3 fields on the website’s record, called button rate, banner rate and text link rate.
To set how much the spot is going to cost on the ad spot record, we have a ‘monthly rate’ field, where we have developed a case function that references the ‘type’ picklist on the ad spot record, and depending on which value is specified, looks to the website record and returns the appropriate field value. Formula is below.
CASE( Placement_type__c ,"button",Partner_Website__r.button_Rate__c,"Banner", Partner_Website__r.Banner_rate__c,"Text link Ad" , Partner_Website__r.Text_Link_Ad_Rate__c, 0)
We’re happy with this at least and it seems to work.
However, now we need to know how much the advertising goal is going to cost from having secured all these ad spots, so we need to create a rollup summary field, that sums the monthly rate field, across all the associated placements.
When we try to create a roll up summary though, the Formula fields do not appear.
I'm hitting a wall with this as I'm not a programmer and just don't have the skills to work around, and SF support can’t help me either. They ahve suggested that you can't roll up formulas that involve other objects. So I would love to hear from anyone that can explain what is going on, and offer a solution.
