ContributionsMost RecentMost LikesSolutionsRe: Question on a Formula QueryThanks Mark, I have some other Formula Queries that I had gotten to work that had the "query" part of them. I wondered if I needed to add one, but didn't get far enough into it to try that option. Thanks again. ------------------------------ Chad Kragness ------------------------------ Re: Question on a Formula QueryThat did it Sean. I hadn't tried the SumValues as I thought I should be able to just grab the value that I can see sitting in the field. Thanks again to you and the others for taking time to help. ------------------------------ Chad Kragness ------------------------------ Re: Question on a Formula Query Sean, The formula you show allows me to exit the page without errors, but it does not return anything. I think we're past the number vs text thing? But not sure why it returns nothing. I may need to re-think my solution. Thanks for taking time to assist. ------------------------------ Chad Kragness ------------------------------ Re: Question on a Formula QueryI'm looking to pull the Cost of the item in record ID 108 from the table shown and bring it to a new table so I can then use it (and 43 others) on a price page for our items using an HTML page. field 159 is where the cost is stored in that table. Thanks, Chad ------------------------------ Chad Kragness ------------------------------ Re: Question on a Formula QueryGetFieldValues(GetRecords(108, [_DBID_TITAN_TIMBER_ITEMS]), 159)); //GetFieldValues(GetRecord(101, [_DBID_PROJECTS]), 5) sample from quickbase help. Thanks Mark. New to this forum stuff. ------------------------------ Chad Kragness ------------------------------ Re: Question on a Formula QueryThanks Mike, I tried ToNumber() and ToText() in a few places in the formula to no avail. I also tried changing the type of the filed from Formula-Numeric to Formula-Text as a trial and that doesn't work either. ------------------------------ Chad Kragness ------------------------------ Question on a Formula QueryI have a Formula query that is giving me the error message "Expecting Number." I expect that the field (159) is a number in my table. The record ID (108) should also be a number? Commented out on the attachment is the formula that I had copied out of the help area to start with. As I add "s" to the end of GetFieldValue or GetRecord - the errors change but do not resolve my issue. Is there a Formula Query "guru" who can enlighten me on what I'm overlooking? Thanks, ------------------------------ Chad Kragness Timber Technologies, LLC Year 1 user (creator) ------------------------------ Re: Exact Forms Logo fileI had found a post on here from 20/20 that had a link to the directions on how to ad the image. I made the Document Library available to everyone on the internet (as a contributor) do you know if the contributor part matters? I had it working on Friday but then I went back and modified the Word Document template and when I re saved to Quickbase it had the logo's moved around. I then deleted them from the Word Doc template and tried to re-load. It keeps telling me they don't exist or could not be found. I went back and tried again now and it tells me the image can not be displayed because the file may have been moved or deleted? I'm trying to work around the fact that Our Company name doesn't show up in the correct font. I look inside the .html file and everything appears correct as far as the style calling out the correct font (Bremen BD BT) it shows up at the top of the document as a font-face type as well. But when printed it comes out way smaller and in the wrong font. I want to add our company Name and address into the logo in insert that in the file to eliminate the font issue but now it won't find my file..... ------------------------------ Chad Kragness ------------------------------ Exact Forms Logo fileI am having an issue with a Logo in my Exact Form Template. I was able to make it work last week. I went back to the Template to make changes and since then it keeps telling me the file I'm trying to insert (Logo File) does not exist. I have tried uploading it to the Document Library application I downloaded. I also tried saving it as a File Attachment directly in my application. Any thoughts? Thanks, Chad Kragness Timber Technologies, LLC User since August 2021 ------------------------------ Chad Kragness ------------------------------