DougCrandall
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Duration of 48 hours starting on a workday
Thank you, Mark. This was what I needed. Quickbase accepted this function with an extra set of parenthesis and it appears to work, though I'll create a record on the weekend just to make sure. And I also learned from your example that I can comment within a line, which I had never done before. :-) ToTimeStamp( ToWeekDayN(ToDate([Date Created])) , ToTimeOfDay([Date Created]) + Hours(48))Duration of 48 hours starting on a workday
Greetings. I am trying to create a Due Date/Time field that would show 48 hours from the Date Created for a record, but need to take into account work hours. Right now my formula is [Date Created]+Hours(48), which shows the date/time 48 hours later, but if the record is created Saturday morning at 10am, for example, I would need the countdown to start as of Monday morning 8am. I thought about using ToWorkDate, then WorkDateAdd, but I believe I would lose the time component, so am not sure that will work for the date/time field type. Any suggestions?Transferring a copy of an app between realms
A sister company of ours is transferring a copy to us of an app that we want to use. I have received the application transfer notification email from the pipeline, but it is directing me to sign in to our sister company's quickbase realm to retrieve it. Since I am not set up as a user in their realm, I am unable to proceed. We've transferred apps before but it seemed it was much easier and I can't remember what we did to complete the transfer. Does anyone have any suggestions? What am I missing? ------------------------------ Doug Crandall ------------------------------Re: Phantom data appearing in 'new' embedded report
Jeremy, based on your hunch about these records not having a related parent, I went in and deleted them and that seemed to do the trick. The embedded report no longer shows any records on new tickets before they are saved or added. ------------------------------ Doug Crandall ------------------------------Phantom data appearing in 'new' embedded report
I have a form (using the new format) with an embedded report associated with an Add Child Record button. With a new Parent record, before adding new child records, the embedded report shows random data from the Child table instead of an empty table. This does not happen with the old format forms. Does anyone know why this is happening and what I can do to just show a clean, empty embedded report? ------------------------------ Doug Crandall ------------------------------Changing native Save button's redirect behavior
Can we edit the redirect behavior of the native Save button? I have a form (using the new format) with an Add Record button to add a child record. The form is set to automatically save before it is redirected to add the child record. Once the child record is added and saved the user is directed back to the parent record. If the user saves the parent record again or edits the parent record before saving it (after having added the child record) the user is taken back to a new Add Child record in the Child table rather than to the Parent table home screen or to the Home Page where they clicked on the Add Parent Record button. I do have a custom button that will save the record and take the user back to the Home Page, but I know that people will still click on the native Save button. I don't believe there is a way to hide the native Save button, but is there a way to change its redirect behavior? ------------------------------ Doug Crandall ------------------------------Filtering a report on the new forms
Hi Qrew! I'm trying out the new forms in a Request table that is a child of the Accounts table (one Account can have many Requests). In my first section I utilize a lookup field to show the Account #, name, and phone number. I want to insert a report from the Request table that would dynamically filter on the Account # and show any Requests that have previously been created for that Account #. I have a table report already created in Requests that lists the requests, but I can't figure out how to dynamically filter the report for display. Any suggestions on how this could be done? ------------------------------ Doug Crandall ------------------------------
