ELANAMETH
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Using ""&z=""&Rurl() and rdr in formula URL fields
@Brian Cafferelli I have a button on a report, and I want it to update a field in the record and redirect to the report. I've been doing this with JS, but want to move away from that, considering the phase out. What would you recommend as a redirect for that case? Neither of these solutions worked. Thank you!Re: Virtual Empower: App Library
Thank you @Blake Harrison! @Ryan Pflederer, wondering if you have any tips on this (updating schema automatically). Also wondering if there is an error log functionality to record "event" errors. Overall, this app is great! I'm excited to maximize all its capabilities to help us better document and clean up our app. ------------------------------ E. P. ------------------------------Re: Add a button to open a specific form?
You can redirect to a specific form using the form ID like this: (this would be the last statement in your call) "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&dfid=10&rid=" & [Record ID#]) Where dfid is the form ID. You can access the form ID # on the form settings page ------------------------------ E. P. ------------------------------Using URLEncode Conditionally
Hello, I have an API add record button that is passing through 4 different API calls. The first 3 are conditional (all, 1, or 2 can be called), and the 4th is always necessary. I realize that I need to use URLEncode for any of the clauses that are not first. I cannot default them all to begin with URLEncode, as the first clause cannot have that, but I can default #4 to use it, as it will never be first. I tried having each variable end with it so that it, but that did not work. Any other suggestions on how to use URLEncode conditionally? The individual variables work correctly, it's just the URLEncode for multiple calls that is messing things up. var text urlAddApp = URLRoot() & "db/" & [_DBID_APPS] & "?a=API_AddRecord"; var text AP = $urlAddApp & //CREATE APPLICATION "&_fid_6=" & URLEncode ([Related Company]) & "&_fid_20=3" & //AP application "&_fid_8=AWAITING APPLICATION FROM WEX" & "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxx"; var text credit = $urlAddApp & //CREATE APPLICATION "&_fid_6=" & URLEncode ([Related Company]) & "&_fid_20=1" & //credit application "&_fid_8=AWAITING APPLICATION FROM WEX" & "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxx"; var text prefunded = $urlAddApp & //CREATE APPLICATION "&_fid_6=" & URLEncode ([Related Company]) & "&_fid_20=2" & //prefunded application "&_fid_8=AWAITING APPLICATION FROM WEX" & "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxx"; var text createNextActivity = URLEncode(URLRoot() & "db/" & Dbid() & "?a=API_AddRecord&_fid_18=" & URLEncode ([Related Company]) & "&_fid_34=6" & "&_fid_6=" & Today() & "&_fid_66=true" & "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxxx" & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_CO] & "?a=dr&rid=" & URLEncode ([Related Company]))); var text createAppAP = If(Contains([APPLICATION TYPE], "AP"), $AP & "&rdr=" ); var text createAppCredit = If(Contains([APPLICATION TYPE], "CORPORATE CREDIT"), $credit & "&rdr="); var text createAppPrefunded = If(Contains([APPLICATION TYPE], "CORPORATE PREFUND"), $prefunded & "&rdr="); $createAppAP & $createAppcredit & $createAppprefunded & $createNextActivity ------------------------------ E. P. ------------------------------Re: Sync two Quickbase tables into a third Quickbase table.
Hello, Is there any updated way to do this? I have 2 apps with a table in each that need to be merged (on a filter, as I don't want overlap). Each table already has a corresponding sync table in the other app, so it does not really matter where I do the join. I would like to sync table A and table B into table C. Again, not all of table A or B - each would need a filter. Is the only way to do this via an import? ------------------------------ E. P. ------------------------------Re: Pipeline trigger
I am wondering the same thing. It is quite frustrating to have build out a whole pipeline only to realize you need to change from "add" to "edit." It seems like you have to redo the entire pipeline if you want to change it! Is there any way around this?? ------------------------------ E. P. ------------------------------
