Formula URL button - save and redirect
Hi there I?ve created a form accessible to ?everyone on the internet? for our clients to submit service requests. I added ?&ifv=20? to the url to hide the qb branding. However, doing this causes the save button to become hidden. I created a formula url button that will save it using this javascript I found on the forum: var text URL = "javascript:void(DoSaveAdd())";var Text Image = "<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit</a>";"<b href =" & $URL &">" & $Image & "</b>" My problem now is how do I get the page to redirect after the form is saved. Here?s a link to the form, you can try it and see what happens. https://sparkav.quickbase.com/db/bnzwm7ykp?a=nwr&ifv=20 I'd like it to redirect to an external webpage. If that is not natively possible than I'd like it to redirect to a rich text page I've created in quickbase. Any help with this would be greatly appreciated! Thanks, Elisha
Can I use concatenate in Quickbase?
Trying to combine two text fields in Quickbase into one text field. Field 1 is a title from another table and Field 2 is the version of that title. So Field 1 might be "Diabetes" and Field 2 might be "v2". I just want to combine them to be "Diabetes_v2" in the new field. Is that possible? Seems like if should be simple enough with CONCATENATE([FIELD1),"_",[FIELD2]) but that doesn't seem to work. Getting this error: Formula error -- Unknown function The function name Concatenate(text, text, text) is unknown. Really? You can't use CONCATENATE in Quickbase? Any advice? Thanks!
Using 'not ifnull' formula in a 'formula text field'
I need some help with a formula. I am trying display text if a field is not null. This is my current formula: If(not IsNull([AP Supplier Type]), "Oracle Hold", If(not IsNull([CURRENTWORKNODE]), "Rapid Hold", If(not IsNull([Amt]), "Payment Hold"))) Currently, everything is being listed as an "Oracle Hold". I am not sure what I am doing wrong. Your help is much appreciated!!
Adding number of days to Date - Formula Field
Hello: Your friendly yet persistent novice with another question: I am trying to add days to a date - formula field based on selection in a different field. Error Message: Formula syntax error Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets. if( [Work Type]="RD-Reactive",([Date Complete WO Received]+Days(5)), [Work Type]="PJ-Planned Job",([Date Complete WO Received]+Days(12)), [Work Type]="RP-Reactive Project",([Date Complete WO Received]+Days(10)), ) Any help would be greatly provided Dirk
Formula to check for blank/null Multi-Select Text field
I am writing custom data rules and would like to have a rule that when a specific Multi-Select Text field [Items Awarded] is blank/null the record cannot be saved. I've tried using each of the following, and each returned an error [Items Awarded] = "" -- The operator '=' can't be applied on types textlist, text ToText([Items Awarded]) = "" -- Expecting text but found bool [Items Awarded] = Null -- Expecting text but found bool ISNULL([Items Awarded]) -- Expecting number/date/datetime/TimeOfDay/duration/workdate/user/userlist but found textlist How do I use a formula to check for blank/null Multi-Select Text fields? ------------------------------ Amanda Thomas Business Systems Analyst Morse Steel Reinforcing Bellingham WA 360-756-6208 ------------------------------
Using HTML in Formula - Rich Text Fields
At EMPOWER2019 in Miami, Senior UX Designer Lisa Sawyer shared some awesome tips in her session Quick DIY solutions for beautiful & user friendly apps. Do yourself a favor and carve out an hour to check out this highly informative session. If you only have a few minutes to spare, check out this quick video highlighting my favorite tip: using HTML in Rich Text Formula Fields This is a great technique to quickly add some color and style app by highlighting key data points or KPI’s for your end users. Here is the code snippet that is used in the video: "<div style=\"color:#74489D;font-size:350%;font-weight:bold;\"align=\"center\">"& ADD YOUR FIELD &"</div>"& "<div style=\"color:#gray;font-size:150%;font-weight:bold;\"align=\"center\">PLACEHOLDER TEXT</div>" To learn more about which HTML Tags are allowed by Quick Base, click here ------------------------------ Freddie Sabbs fsabbs@quickbase.com ------------------------------IF AND Formula Issue
I have to calculate the amount of per diem an associate is to receive. For the most part I can get this to work in Excel with the following formula: =IF((J2-I2)<=7,(J2-I2)*25,IF(AND((J2-I2)>7,TODAY()<I2),7*25,IF(AND((J2-I2)<7,TODAY()<I2),7))) I read where Mark Shiner stated for "And" to do something like this: IF( [Project Actual] = 0 and [Project Forecast] = 0 and [Project Budget] = 0 ,0, So I tried this If( ToDays([Hotel Check-Out Date]-[Hotel Check-In Date])<=7,ToDays([Hotel Check-Out Date]-[Hotel Check-In Date])*25, If( ToDays([Hotel Check-Out Date]-[Hotel Check-In Date])> 7 AND Today()<[Hotel Check-In Date],7*25, If( ToDays([Hotel Check-Out Date]-[Hotel Check-In Date]),7 AND Today()<[Hotel Check-In Date]),7))) But I get an error message "the operator 'and' can't be applied to boolean... Any help would be greatly appreciatedFormula to Show "Day of Week, XX/XX/XXXX to Day of Week, XX/XX/XXXX"
Hello, Can someone provide any insight into how to create a formula that produces text that will show [event date start] to [event date end], when [event date end] is empty. I need a field that will combine two date fields to show, for example, "Thursday, May 6, 2021 to Friday, May 7, 2021". I have the following formula in a formula - text field set, but it's showing me what I need in a simple "5/6/2021-5/7/2021" format when I need to spell it out more like above. If(not IsNull([event date end]),ToText([event date start])&"-"&ToText([event date end]),ToText([event date start])) Thank you in advance for your help! ------------------------------ Gabriella Tremoglie ------------------------------
Formulas - IS Not Null & If Then
Hello! I have the following fields in my report: "Date Manager Entered" "Last Day" I'd like to create a formula that does the following: 1. See if there is a date entered in "Date Manager Entered" 2. If there is a date in "Date Manager Entered" to calculate if "Date Manager Entered" - "Last Day" <5 days 3. If that calculation is <5, display "No". If it's >5, display "Yes" I was thinking of using: If(Is Not Null[Date Manager Entered], If(ToDays([Date Manager Entered]-[Last Day])<5,"No","Yes"),"") but I'm pretty sure I'm not joining these correctly. Can you please help me determine what the proper formula should be? Also, please advise what sort of text type it should be. Thank you!
