PranavChoudhary
Qrew Trainee
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Duration Formula
Hello Jamie, For calculating simple duration, We have "Formula - Duration" as field type available in Quickbase. Few changes required here are : Change field type of "Days Open/Advisor Actively worked" to formula - duration. Formula Modification :- If([Status]="Complete", [Date Completed] - [Date Advisor Received] , Today() - [Date Advisor Received]) The 1st Date Client Advisor Received comes back with error Field not identified. - this is because in your formula you have two square brackets instead of one. Hope it resolves your problem. Looking to hear back from you! ------------------------------ Pranav Choudhary Quickbase Expert Builder Certified by Quickbase beniwalpranav@gmail.com ------------------------------Re: Hiding the Save&Close button
Yes, you can use "&ifv=1" in url at last. Example : URLRoot() & "db/" & [_DBID_] & "?a=er&rid=" & [Record ID#] & "&ifv=1" ------------------------------ Pranav Choudhary Quickbase Expert Builder Certified by Quickbase beniwalpranav@gmail.com ------------------------------Re: Formula Text Field - Buckets based on Duration
Hi, use below code : If([Penetration Days]<Days(0),"Not Aged", [Penetration Days]>Days(1),"0-3 M", [Penetration Days]>Days(91),"4-6 M", [Penetration Days]>Days(181),"7-9 M", [Penetration Days]>Days(271),"10-12 M", [Penetration Days]>Days(366),"13-18 M", [Penetration Days]>Days(547),"19+ M" ) You need to remove the comma after text in last line. ------------------------------ Pranav Choudhary Quickbase Expert Builder Certified by Quickbase beniwalpranav@gmail.com ------------------------------Re: Formula to Save & New while keeping fields from current record
You can use Save & new option from dropdown at top right while adding record. Data can be passed from fields 15, 7 and 9 to new record by using relationship and creating any one of those which has unique value as reference proxy and other two as lookup fields. So anytime Add record button is clicked then 15,7,9 will be auto populated on new record on basis of reference proxy key. ------------------------------ Pranav Choudhary beniwalpranav@gmail.com ------------------------------
