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 thesavebutton 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 thepage to redirect after theform 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
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!!
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!Formula 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 ------------------------------
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 ------------------------------URL button to edit then refresh page
I put the following code into a Formula URL field. The purpose is to change the status to completed by clicking the button. URLRoot() & "db/" & [_DBID_LOTO] & "?a=API_EditRecord&rid="&[Record ID#]&"&_fid_37=Completed" Works great, but it then goes to the response page below. Which I don't want. How do I modify the code above to simply change the status and refresh the page. ------------------------------ Steven Nelson ------------------------------
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 DirkNew line code in formula rich text field
Hi, I'm trying to add an image thumbnail and text together on a report, and want the text to be under the image. With the formula rich text field below, the image and text show but the text is currently displaying to right of image, not below. I'm trying "\n" to force a new line after the image but it is not working. Thanks "<img height=\"150\" src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e10/v0\" />"& "\n" &[My Text Field]
