ContributionsMost RecentMost LikesSolutionsRe: Displaying images on reportsI've just tested the following: A: Large picture with a large file size, pulled straight off google images (as a jpg): self orients correctly B: Large picture with a large file size, freshly converted from HEIC to jpg: does not self orient correctly C: Continuing from Case B, resizing the image down to a smaller picture and smaller file size (no changes in file type, jpg to jpg): self orients correctly Based on this, it seems like quickbase doesn't like whatever is happening to an image when the image is freshly converted from HEIC to jpg. And whatever is happening when the image is resized from a large everything to a smaller everything, all keeping with jpg, seems to fix it. ------------------------------ Andrew Le ------------------------------ Re: Displaying images on reportsDesktop hmmm, I've resized the image, from3024x4032 to 605x807 (20% of original). The file size has gone down from 1.2 MB to 0.8 MB, and it's still a jpg. It now orients correctlyby itself. ------------------------------ Andrew Le ------------------------------ Re: Displaying images on reportsSure, The photos were taken on an iOS device and imported into windows as typical HEIC files, they were then converted into jpg's using heictojpg.com They are imported into quickbase as jpg's, as either 3024x4032 or 4032x3024 depending on the orientation. The images range anywhere between 0.5 MB to 1.5 MB ------------------------------ Andrew Le ------------------------------ Re: Displaying images on reportsThat works perfectly, thanks for the help! I do have a second (and hopefully last for this topic thread) question though, my pictures that are normally in portrait orientation are being turned over on their sides into landscape orientation. Is there anything I can do to ensure that picture maintain their correct orientation? ------------------------------ Andrew Le ------------------------------ Displaying images on reports Hello all, I have a question regarding getting images to display on reports. I am currently trying to get images that are uploaded to quickbase to also display in reports as regular images. However, I am having difficulty getting the code to properly work. ----- I've found that the code works if I code the field such that a specific image address is hard coded into the rich text field, I can get an image to display, but since it's hard coded to a specific image, all the rows display the single image that was hard coded. What I really want is for the code in the "Photo" field to dynamically look at that record's "Photo File" address and display the image connected to that record's photo file. This is the code that I currently have in the Formula - Rich Text code for the "Photo" field: "<img src=https://xxxxxxxxx-####.quickbase.com/up/xxxxxxxxxx/g/rc/ej/va/"&Right([Photo File],"va/") I did notice that the > symbol is missing, but the only place that quickbase will allow it is at the end of va/, which just cases it to behave like the example lines of code below. Additionally, when I try to put it on the end like in the second example line of code that I've shown below, quickbase returns a syntax error. This is the code that works when I hard code a specific image: "<img src=https://xxxxxxxxx-####.quickbase.com/up/xxxxxxxxxx/g/rc/ej/va/IMG_2294.jpg"&"height=100>" Note: if I were to also hard code the following line of code, I can get the same behavior: "<img src=https://xxxxxxxxx-####.quickbase.com/up/xxxxxxxxxx/g/rc/ej/va>" Note: I've removed some private identifying information from the code. What should I be doing to get the images to display properly? Thank for you help and suggestions. ------ I have also included a screenshot of the what I'm hoping to achieve from this report: ------------------------------ Andrew Le ------------------------------ Using Less/Greater Than operators for numbers within a range?Hello all, I am currently trying to organize some numerical data with formula operations, however I am having an issue Quickbase taking my code: if([Units Inspected]=0,0,1<=[Units Inspected]<=4,1,5<=[Units Inspected],[Units Inspected]/4.5) I need to be able to control the output values when the input values fall within the range of 1 and 4 (inclusive). However, Quickbase is marking the second <= in1<=[Units Inspected]<=4 as not being able to apply the operator, thus not making any of the code work at all. (All outputs are blank) Is there a way around this or a different operator that I can use to control values that fall within a stated range of values? Any help is appreciated, ------------------------------ Andrew Le ------------------------------ Re: Lookup fields not populating data using table-to-table relationshipsI looked at the child table's [Related Reference] field and found that it indeed doesn't not match the the parent table's [Reference Key] field; which, as you predicted, would explain why the LookUp fields are not populating correctly. Thank you very much for your advice.Lookup fields not populating data using table-to-table relationshipsHello all, I am having trouble getting a table-to-table relationship to auto-populate some lookup data. The two tables that I am trying to connect are an Employee table and an Overtime Tracking table. The employee table contains fields for employee ID#, name, business title, department etc etc. The overtime tracking table contains fields for the year-to-date week, the overtime hours worked for that week, and the employee ID# for the employee who worked those hours. (This means that the same employee can appear on the table multiple times based on which week you're looking for) I have created the relationship to connect the Employee table as the Parent table and the Overtime table as the Child table (since each employee has many overtime records, organized by YTD week #). What I would like to do is to have the tables reference each other such that I can display business title (from the employee table) as an auto-populating field on the overtime table; and to be able to have each employee's form (on the employee table) being able to pull and display that employee's OT hours. However, when I create the relationship, the overtime tracking table is not auto-populating the business title and department fields. I'm trying to trouble shoot why the connection isn't working. Is there any specific settings or relation behaviors that I need to tune? Thank you for any help you can provide.