ContributionsMost RecentMost LikesSolutionsLimiting Time Of Day Field Options A Time of Day field lists from 12AM to 11:30PM. Can I create a formula that tells the list to start at 6AM? My employees are clicking 2:30AM when they mean 2:30PM. I'm trying to limit the options of AM time. ------------------------------ Jillian ------------------------------ Re: If blank = Time of Day Field + 1 Hour I'm not having any luck. The field "Est. End Time" isn't identified within the formula field of "Est. End Time". Date / Time and Time of Day fields don't seem to like being in the same formula? My fields are as follows: "WO Date" - (Date) "Appt. Time" - (Time of Day) "Est. End Time" - (Time of Day) "Appt. TimeStamp Start Date/Time" - (Formula Date/Time) -- ToTimestamp ([WO Date], [Appt. Time]) -- "Appt. TimeStamp End Date/Time" - (Formula Date/Time) -- ToTimestamp ([WO Date], [Est. End Time]) -- Which field would your formula go under? "Est. End Time" does not want to reference itself within a formula. ------------------------------ Jillian P ------------------------------ If blank = Time of Day Field + 1 Hour I followed another thread and was successfully able to create time blocks in a calendar report. However, because I created a new field for moving forward, I have thousands of records without any data in that field. I am trying to create a formula that states if the field is empty then add an hour from another time of day field. I had [Appointment Start Time] already and have created [Appointment Estimated End Time] (Both Formula - Time of Day fields) In the calendar, the calendar is based on a Timestamp field of [Work Order Date] + [Appointment Start Time] (Formula - Date/Time field) For the Calendar's "End Date" I will also use a Timestamp field of [Work Order Date] + [Appointment Estimated End Time] (Formula - Date/Time field) It will work - but brings me to the issue that I want to enter data into the empty fields of [Appointment Estimated End Time] so that all previous records still show within the calendar. I know this is wrong but I want it to read something like: IF (is null ([Appointment Estimated End Time]), ([Appointment Start Time] + Hours (1)) In the field I want it to be an hour after the start time. It needs to read "if blank" rather than having it go to a default 1 hour. It won't always be 1 hour moving forward and another time of day will be manually entered. ------------------------------ Jillian P ------------------------------ Dynamic Form Rules I have a work order form where it is required to select which type: Service (Customer), Service Lead (non-customer), Installation (has both customer and lead option), Quote (both customer and lead option), and Employee Time-Off (Each it's own section). I have all my form rules working the way I want them to within adding a record but once that record is saved and viewed later, I only want the section Customer OR Lead to show depending on which one was filled out. How can I use a rule where if a field is just filled out (not specific data or matching - just entered) can I trigger hiding the section that wasn't filled out? When editing/viewing the form (especially on mobile) I only want to see the necessary data. ------------------------------ Jillian P ------------------------------ Formula-Date/Time I ran into an issue with our Work Order calendar report showing the appointments at the top rather than in their respective time slot. I did some research and realized the issue is stemming from me trying to utilize two fields – one to track date and one to track time of day. I need to use a date/time field specifically that holds both. If I were to use a formula-date/time field to combine existing data, how would this formula look? My fields are "Work Order Date" and "Start Time". ------------------------------ Jillian P ------------------------------ Not thinking, I deleted placeholders when I registered the matching user. I assumed the placeholder would remain in red and it did not :-( Did not think it through. I also did not realize it until a few days after the fact so there is no copy to pull from. I do have the initial data import file to attempt to import and match but this past year is missing from my initial data. Would that need to be updated manually or is there a history somewhere I can go back and correct? ------------------------------ Jillian P ------------------------------ Merging Fields New to Quickbase. I've already imported my CSV files and disconnected. Then I've set up my relationships and forms. When I got to my address fields, I noticed there is no option for me to change the "type" to address. I've now created Address Fields (with it's subfields) that will become a map and want to transfer the data from my original fields of: Service Address L1 Service Address L2 Service Address City Service Address State Service Address Zip Is there a way to do this? ------------------------------ Jillian Perry ------------------------------