LizChartrand
Qrew Cadet
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: If/Then Help - Unforeseen number populating
Roy, it looks like sadly, it works for me, but not for the other user. It's still yielding that ~24000 amount in the currency field. Mark, I love that syntax change, let me update those problematic currency field rows and follow up Thanks everyone for your suggestions!35Views1like1CommentRe: If/Then Help - Unforeseen number populating
Thanks Mark, same - in fact, has I've updated my syntax again it works for me. And yet , when my team member uses the API button, she's getting the ~$25000 populated instead of being blank. It seems like its happening with her but I have no idea why. This is a Rich text field making an API call.32Views0likes0CommentsRe: If/Then Help - Unforeseen number populating
Sure thing, Mark, var text Renewed= URLRoot() & "db/" & [_DBID_***] & "?a=API_GenAddRecordForm" &"&apptoken=***" & "&_fid_8=" & [Related Application] & "&_fid_328=" & URLEncode(If([Property - Invoice for Renewals?]="Yes","No","Yes")) & "&_fid_330=" & URLEncode([Property - Invoice for Renewals?]) & "&_fid_141=" & "1" & "&_fid_143=" & "2" & "&_fid_895=" & [What Terms Need to Be Added?] & "&_fid_781=" & [Related Property*] & "&_fid_138=" & [Related Building] & "&_fid_6=" & [Related Renewal Unit] & "&_fid_69=" & [Renewal Outcome Gross Rent] & "&_fid_45=" & URLEncode([Move-In]) & "&_fid_39=" & URLEncode([Renewal Outcome Lease Start]) & "&_fid_52=" & URLEncode([Renewal Outcome Lease End]) & "&_fid_40=" & [Renewal Outcome Lease Term] & "&_fid_226=" & [Renewal Unit Utility Fee] & "&_fid_57=" & If([Renewal Outcome Parking Rent]>0,"Yes","No") & "&_fid_176=" & If([Renewal Outcome Parking Rent]>0,[Renewal Outcome Parking Rent],null) & "&_fid_67=" & If([Renewal Outcome Pet]>0,"Yes","No") & "&_fid_64=" & If([Renewal Outcome Pet]>0,[Pet Details], null) & "&_fid_65=" & If([Renewal Outcome Pet]>0,[Pet Fee], null) & "&_fid_66=" & If([Renewal Outcome Pet]>0,[Pet Rent],null) & "&_fid_71=" & If([Renewal Outcome Storage]>0,"Yes","No") & "&_fid_72=" & If([Renewal Outcome Storage]>0,[Renewal Outcome Storage],null) & "&_fid_22=" & [Renewal Outcome Concession (mths)] & "&z=" & Rurl(); var text Renewals = $Renewed; //button colors //whitetext on orange button var text bgcolorone = "#dc7c5c"; var text txtcolorone = "white"; var text styleone = "style=\"text-decoration: none; width: 150px; text-align: center; background:" & $bgcolorone & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolorone & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;"; Case([What Terms Need to Be Added?], "Renewed", "<a class='SaveBeforeNavigating'" & $styleone & " href = '" & $Renewals & "'> Add "&[What Terms Need to Be Added?] & " </a>", "Renewed (Transfer)" , "<a class='SaveBeforeNavigating'" & $styleone & " href = '" & $Renewals & "'> Add "&[What Terms Need to Be Added?] & " </a>", "<span style='font-family: Arial, Helvetica, sans-serif; font-size: 10pt; text-align: right; color: #426ab3'>" & " Please select the type of terms to add to this application </span>")1View0likes0CommentsIf/Then Help - Unforeseen number populating
Hello! I've got an API button that when triggered, creates a new record with some preset information pulled in. That all works except in the instances where I need some fields to be blank. I thought I could use an If/Then statement to complete data or stay blank when necessary. for exp, If( [Renewed Parking rent] >0, [Renewed Parking rent] ), [...] I assumed if I left that as the statement, nothing would happen in the even of a $0 amount. The new record's field would be intentionally blank. Instead strangely, when data should be blank (whether the if/then sample above is blank or null), it populates a crazy amount like $25,000... It's always roughly $2#,###. I've attached some of the screenshots of the data output (currency fields) and formula. The text fields populate correctly if for example, [Renewal OutcomeStorage] (currency) =0 so the output for [Storage] = No (row 32) but [Storage Rent] (currency) should be blank but instead reflects $24,302.00. Any ideas about what I'm doing wrong? Thank you for your help, LizSolved158Views2likes11CommentsFile Manager Plug-in for Add Record Any Creative Solutions?
Hello, I'm wondering if there's any clever solutions to route to the file manage plug-in so end users can add documents to child records when they are also adding a parent record. I know natively that's not available due to lack of RID on the parent. But I was hoping to leverage some other formulas I've used in the past to circumvent this issue, but I'm getting syntax errors when I attempt to combine elements - I'm curious if this is user error or due to the plug-in it's simply not adaptable? general use case: User adds accounting record for invoicing, as a legal requirement in 2026 they have to now add several large documents for which I would like to leverage the file manager plugin. Samples of what I've concocted: The intention is to save before navigating/opening the file manager and/or use the %%rid%% to provide a new RID for the parent record so the user can bulk add documents with the parent form submission - I think I've scrambled somethings: //original plug=in URL. do not tamper var Text realmHostName = NotRight(NotLeft(URLRoot(), 8), "/"); var Text pidRaw = "" & [Record ID#] & ""; var Text pidQueryParam = URLEncode($pidRaw); var Text URL="https://api.plugins.quickbase.com/launch?pluginId=qb-uploader&pid=" & $pidQueryParam & "&configId=#####&appId="&AppID()&"&realmHostname=" & URLEncode($realmHostName); //"var text URL="" and end ";" added when updated to rich text formula. //button colors var text bgcolorone = "#7f81aa"; var text txtcolorone = "white"; var text styleone = "style=\"text-decoration: none; width: 100px; text-align: center; background:" & $bgcolorone & "; border-radius: 5px; padding: 5px 5px; color: " & $txtcolorone & "; display: inline-block; font: normal 700 40px/1 \"Calibri\", sans-serif; text-shadow: none;"; "<a class= 'SaveBeforeNavigating' " & $styleone & " data-replaceRid=true href='/db/abc?a=dr&rid=%%rid%%'" & $URL & "'> Upload Documents </a>" If this isn't possible, are there alternative solutions out there? Thank you for your help!75Views0likes2CommentsAnyway to convert RichText or Multi-Select Text fields into a numerical Value? (trying to Query of a result)
Hello, I am getting stuck trying to make a rich text/multi-select text result value into an actual numeric value , I have the following Formula rich Text Field which will result in a specific dollar amount, var text NextLease = "{6.EX.'"&[Related Unit]&"'}AND{168.EX.''}AND{142.XEX.'Application in Process'}AND{291.XEX.'Yes'}AND{475.EX.'"& [Query Next Valid Lease (Renewals)] &"'}"; SearchAndReplace(ToText(GetFieldValues(GetRecords($NextLease,[_DBID_RENTAL_DETAIL]),69)), ";" , "<br>") Alternatively, this is what I have for the Multiselect version of this field var text NextLease = "{6.EX.'"&[Related Unit]&"'}AND{168.EX.''}AND{142.XEX.'Application in Process'}AND{291.XEX.'Yes'}AND{475.EX.'"& [Query Next Valid Lease (Renewals)] &"'}"; SearchAndReplace(ToText(GetFieldValues(GetRecords($NextLease,[_DBID_RENTAL_DETAIL]),69) However, this isn't a true value, it looks like a dollar amount, but the system is not fooled! Is there a way for me to convert the rich text or multi-select text into a numeric value? Very interested in any suggestions! Thank you! ------------------------------ Liz Chartrand ------------------------------82Views0likes2Comments