KellyKiernan
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Getting a new domain and email addresses, how do I change them in Quickbase
My company was recently acquired, therefore, we will be getting a new domain and email addresses. Below are some questions I would love some assistance with. 1. Do I have to change the domain name associated with my Quickbase account to the new domain? 2. If I don't have to change the domain, how do I change my users email addresses to the new name? 3. Will all historical records linked to the users by way of User ID fields stay with them? Thanks in advance for any help you can give me! ------------------------------ Kelly Kiernan Senior Operations Specialist ------------------------------38Views0likes2CommentsFormula Help-Duration Calculation
I'm new at building formulas in Quickbase. I need to build a formula that will calculate accrued employee PTO time (it's accrued daily). Simply put, it would be as follows: (Today's Date - First Day of Current Year +1)/365*# of PTO Days Given # of PTO Days Given is a field in a report. I'm not sure if I need to create another field to build the formula in to get the calculation or if I just need to add a calculated field to a report. Any help for this novice would be greatly appreciated. Thank you in advance!18Views1like2CommentsFormula Help
I'm new at this and trying to create a formula that will update the status field in parent record from a status field(s) in child record(s). Certain status' will only need one record changed to change the parent record, where as for 2 status, all child records will need to have that status to change the parent record. Essentially, when all child record status are marked as either Not Started or Completed, I want the parent record status field to say Not Started or Completed respectively. However, if one or more of the child record status changes to In Progress (with the rest staying Not Started) I need the parent record to be updated to In Progress. And also if any of the child records change to Completed, I want to keep the parent record status field as In Progress. This is what I've build so far: If(Contains([Project Title], "do not delete"),"Template", If([# of Workflow Steps]>0 and [# of Open Workflow Steps]>0,"In Progress", If([# of Workflow Steps]>0 and [# of Open Workflow Steps]>0,"Not Started", If([# of Workflow Steps]>0 and [# of Open Workflow Steps]=0,"Completed"))) The result I'm getting is that when the child records are set to Not Started, the parent record status says Completed. When one or more child records is set to In Progress, the parent record status says In Progress (so that works). When the child records are set to Completed, the parent record status says Not Started. Any assistance for this newby would be appreciated. Thank you!4Views1like1Comment