ContributionsMost RecentMost LikesSolutionsImage displayIs there a way to embed an image in a new form? Use case: Need to have a different image displayed every time I add a new form. Not file attachment. Ideally, be able to pick the image from a file explorer or paste the image on the new form. I have a "Parts" table and want to display the image of the part. ------------------------------ ed cooper ------------------------------ Re: Military time conversion Cancel. Got it figured out _______________ Ed Cooper On May 18, 2021 6:46:39 AM Ed Cooper <edcooper@squareriggerinc.com> wrote: Nathan, Two more things. How do I set a new report I built to be the default report when the user clicks the table heading? How can I get a total of the hours: Regards, Ed Cooper/CEO Manager/National Accounts Squarerigger, Inc. phone: (360)698-3562 email: edcooper@squareriggerinc.com web: http://www.squarerigger.com PPlease consider the environment before printing this email or any attachments Re: Military time conversion Nathan, Two more things. How do I set a new report I built to be the default report when the user clicks the table heading? How can I get a total of the hours: Regards, Ed Cooper/CEO Manager/National Accounts Squarerigger, Inc. phone: (360)698-3562 email: edcooper@squareriggerinc.com web: http://www.squarerigger.com PPlease consider the environment before printing this email or any attachments Re: Military time conversionHi Nathan, That worked perfectly. You're a genius. Nobody at QB would tackle it. I owe you a beer! I live near Port Townsend. ------------------------------ ed cooper ------------------------------ Re: Military time conversionNathan, I don't want my users to have to enter both the date and time in StartDate and EndDate. I want the form to look like this: Date: 05/12/2021 (standard date field) Start Time: 1000(numeric) End Time: 1130 (numeric) Above fields entered as military time not 12 hour time Duration: 1.5 (formula - End Time minus Start Time) I'm using military time. This is my test screen for the last 3 fields. Start is a number representing military time. End is a number representing military time. So, if you subtract Start (1000) from End (1100) you get the value 100 I need Tot (total time expressed in 12 hour time) which would be 1. If Start was 1000 and End was 1130 the Tot should be 1.5 ------------------------------ ed cooper ------------------------------ Military time conversion Trying to find a way to solve this: I am doing time and date tracking for a support app. I have a date field. I also have a start time and end time fields where I would like to user military time: Date:_05/12/2021____ Start Time:__1000 End Time: ____1130 I would like to convert the military times in the Start Time and End Time fields and subtract the Start Time from the End Time so the value in Total time needs to be in hours and minutes Total Time: __1.5 hours Help!! ------------------------------ ed cooper ------------------------------ Re: Embed image from local fileQB said they can't do anything about it. I rotated the images in question so they were all horizontal. That worked but a clear get around and a pain if you have lots of images. Thanks for your help.Re: Embed image from local fileOK thanks Mark. I'll check in with them.Re: Embed image from local fileOK. I used a file attachment in a form for the jpg's. Works fine for what I am doing. However...... I have a form that displays jpg's. Everything is working with the exception of a couple of the jpg's are rotated. If I bring them up in a viewer the display correctly but in QB they are rotated 45 degrees. I know I could bring them up in a viewer and rotate them 45 degrees so they're good in QB but wrong in my viewer. How do I handle this? Re: Embed image from local fileGreat. I'll go for it!!