ContributionsMost RecentMost LikesSolutionsQuickBase Developer Needed Our company, Tidal Wave Auto Spa, utilizes QuickBase to build applications for our Site Manager and Home Office use for efficiency and other benefits; we currently have about 140 locations across the country. We have a library of applications already in production, and we have a number of proposed applications that need to be developed. We have a few members on our team with QuickBase experience, but we are searching for a contracted developer to help accomplish our QuickBase needs. Our preference is that this person is a Certified QuickBase Expert Builder. This includes: Develop new applications. Making current live applications more efficient. Bringing new and better QuickBase practices to our organization. If anyone is interested in this opportunity, please get in touch with me at michael@twavelead.com. Thank you! ------------------------------ Michael Martin Tidal Wave Auto Spa Business Systems Analyst ------------------------------ Re: Formulated Calculations A consultant will be physically on site to conduct the assessment, so if he arrives and the location has no windows, he'd select "N/A" for the grade of that field. Not sure if you saw my reply to myself, but I was able to use your code and make it work. This is an example of what I did for one category: var number blank = ToNumber("N/A"); Average( If([Signage Lit / Easily Viewable Day & Night]<>$blank,[Signage Lit / Easily Viewable Day & Night]), If([Reader Board Working]<>$blank,[Reader Board Working]), If([Entrance / Exit Obvious and Easily Understood]<>$blank,[Entrance / Exit Obvious and Easily Understood])) Thank you for your help! ------------------------------ Michael Martin ------------------------------ Re: Formulated CalculationsI was now able to get it to work using your original code with a little bit of work. var number blank = ToNumber("N/A"); Average( If([Signage Lit / Easily Viewable Day & Night]<>$blank,[Signage Lit / Easily Viewable Day & Night]), If([Reader Board Working]<>$blank,[Reader Board Working]), If([Entrance / Exit Obvious and Easily Understood]<>$blank,[Entrance / Exit Obvious and Easily Understood])) Thank you Mark! ------------------------------ Michael Martin ------------------------------ Re: Formulated Calculations Hey Mark, I'm getting the error that I can not use the <> operator with numbers or text. Also, I am using one Field for each graded question, so I am not sure how to manipulate what I am trying to do with your solution. For example, I will pretend I have the three questions: Wall Cleanliness: (1-10 numeric grade) Floor Cleanliness: (1-10 numeric grade) Window Cleanliness: (1-10 numeric grade) Normally, I'd take the three grades and average them for the overall 'cleanliness' score. But if the next location I go to does not have windows, I would need to omit that from the overall average of the 'cleanliness' score. ------------------------------ Michael Martin ------------------------------ Formulated CalculationsHello, I am trying to build an "assessment" application that takes different grades and calculates overall scores. The issue I am currently having is that lets say I have three numeric fields that are 1-10, and a score field that takes the aforementioned three fields and sums them and then averages. How would I go about creating a calculation where if one of the grades were not applicable, it would average the other two without needing the N/A field to complete the calculation? ------------------------------ Michael Martin ------------------------------Re: Mobile Home Page Default All UsersEditing my message because I realized what I replied was wrong. ------------------------------ Michael Martin ------------------------------ Re: Multi-Picture Attachment ButtonHey Mark, Thanks for the reply. For my use case, the managers would only be adding photos in Add mode (assuming Add mode means "add new record"). The button will only work when the record is in edit mode is what I understand? ------------------------------ Michael Martin ------------------------------ Multi-Picture Attachment ButtonHello everyone, I followed Kirk's Magic Buttons application tutorial regarding adding a button that allows you to add multiple attachments. The functionality seems to work overall well for what I am using it for except one odd mishap. If I use the custom multi-attachment button on a new record, it does not save the record ID along with any other related record information to the "Pictures" table I've created; however, if I use the native "Add Picture" button that was automatically created by the relationship between the two tables, it works as intended... The oddest part is, after I use the native "Add Picture" button, the custom multi-attachment button starts to work as it should if I use it AFTER using the native Add Picture button. I hope this makes sense, I am newer to QuickBase so my terminology may be a bit off. Let me know if I can provide better information. Thanks everyone. ------------------------------ Michael Martin ------------------------------Re: Grading SlidersThanks for the reply Mark! I've actually already stumbled upon the Magic Buttons application and have contemplated using his button rating method as well. I just wasn't sure if there was any other options to accommodate what I'm looking for. ------------------------------ Michael Martin ------------------------------ Grading SlidersHey everyone, I'm new to QuickBase and still learning the ins and outs. I'm currently working on an assessment application that will allow consultants to review and grade different items at a business location. In HMTL, I'd use an tag such as "<input type ="range" .. etc> to create a 'slider' to choose a numerical value for a grade. Is there any integration similar to this in QuickBase? I've Googled but to no avail. Thanks everyone. ------------------------------ Michael Martin ------------------------------