ContributionsMost RecentMost LikesSolutionsRe: Using Quickbase solely as a backend (Custom Frontend) Hi. Awesome info! I'm afraid I'm a newbie to this kind of setup though. What are the chances we can connect on a conf call at your earliest convenience so I can pick your brain a little? I have a use case for something like this but not sure where to start. ------------------------------ Jose Baez ------------------------------ Re: Using Quickbase solely as a backend (Custom Frontend) Hi Pete. Quick question. How are you accomplishing using the API? Are you switching on the " everyone on the internet" option to accomplish this? ------------------------------ Jose Baez ------------------------------ Re: Got CSV To Import?I just want to append the data into my table from an html page. I tested the code and the file does import..except it created a bunch of unnamed fields. My guess is the code needs the field names.Re: How to create a view or maybe report combine the items from 2 tables?Hi - I have a similar requirement. I just need to know where to place the code found in: Pastie Database https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=288 Re: Got CSV To Import?All sorts of confused here...what code would go in the //your code here? gotCSV("myFile").then(function(csv){ //your code here console.log(JSON.stringify(csv, null, " ")); Re: Is there a way to have a summary report calculate the variance of the difference between sums?indeed you can!! woohoo! awesome bud..thank you!Re: Is there a way to have a summary report calculate the variance of the difference between sums?Sorry..Mark. The variance calc in the record is missing the Filled and Opened totals for the Cost Center. Keep in mind its a sum of multiple records for each cost center. In other words, each cost center has multiple records within it...I need the sum of Total FTE (Open) and (Filled)...if I can get this in the record I'd be in business...the variance calc would work.Re: Is there a way to have a summary report calculate the variance of the difference between sums?Hi Dan, Correct I do have Cost Center table. I'm also am doing the math in the record but it sums the individual variances on the summary which is not the result needed. Question - is there a way to create a formula field that captures the totals shown at the bottom of a Report Link? i.e. pull in the total 40.3 into a separate formula field? I'm thinking as a workaround have the math show in each record..I think this will be acceptable because the report consumer has to view each record individually anyway. Is there a way to have a summary report calculate the variance of the difference between sums?Basically I need the variance to be calculated as the following: FTE Target - FTE Sum (Filled) - FTE Sum(Open) = Variance. In which case would be 9.6 below. Is there a way to make the onload of a form conditional based on a field value?Is there a way to make the onload of a form conditional based on a field value? Say like - if the Status = "Closed for Editing" redirect to page...otherwise open the record?