JulieMeeker
Qrew Cadet
Joined 5 years ago
User Profile
User Widgets
Contributions
Record Picker in Grid Edit
Has anyone found a way to improve how the record picker works in grid edit? Say you are looking for the item that starts with CDV, When you type C it takes you to the beginning of the "C's" in the list and then when you hit D it jumps to the "D's" and so forth. When even using the default record picker in a form it doesn't have that behavior. I also tried creating a form for Grid Edit with a report for the picker and still reverts to single letter picking. Any ideas would be appreciated!Formula Url Buttons
I have a button that opens a Pre Use Check and the Formula is a case statement that looks at the asset type and open the correct checklist based on the asset type. It was working but now is invisible on the form. So I tried to build a "test form" and still shows up blank and I also tried to create a new Formula URL button but now I get a Refused to connect error. Any help would be appreciated. Support has not been able to help. They sent me the link to the Check my Formula documentation. Here's the formula: Case([Type], //Wake boat pre-use check "Wake boat", URLRoot() & "db/" & [_DBID_WAKEBOAT_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_25=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Large boat pre-use check "Large boat", URLRoot() & "db/" & [_DBID_LARGE_BOAT_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_20=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Small boat pre-use check "Small boat", URLRoot() & "db/" & [_DBID_SMALL_BOAT_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_20=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //PWC pre-use check "PWC (jet ski)", URLRoot() & "db/" & [_DBID_PWC_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_24=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Paintball gun pre-use check "Gun", URLRoot() & "db/" & [_DBID_PAINTBALL___BEFORE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_12=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Electric Motorcycle pre-use check "Electric Motorcycle", URLRoot() & "db/" & [_DBID_ELECTRIC_MOTRCYCLE_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Canoe pre-use check "Canoe", URLRoot() & "db/" & [_DBID_CANOE_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_17=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Electric Bike pre-use check "Electric Bike", URLRoot() & "db/" & [_DBID_ELECTRIC_MOUNTAIN_BIKE_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_24=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Golf Cart pre-use check "Golf Cart", URLRoot() & "db/" & [_DBID_GOLF_CART_PRE_USE] & "?a=API_GenAddRecordForm&_fid_24=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Kayak pre-use check "Kayak", URLRoot() & "db/" & [_DBID_KAYAK_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_18=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Bike pre-use check "Bike", URLRoot() & "db/" & [_DBID_MOUNTAIN_BIKE_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //UTV/ATV pre-use check "UTV", URLRoot() & "db/" & [_DBID_UTV_ATV_PRE_USE_CHECKS] & "?a=API_GenAddRecordForm&_fid_38=" & URLEncode ([Record ID#])& "&z=" & Rurl(), //Truck/Car/Van pre-use check "Truck/Car/Van", URLRoot() & "db/" & [_DBID_TRUCK_CAR_VAN__PRE_USE] & "?a=API_GenAddRecordForm&_fid_20=" & URLEncode ([Record ID#])& "&z=" & Rurl() )Trying to format with 2 decimal places
I have a Formula Rich Text field to display a grand total. If the cents end in 0 like .10 it drops the final 0. Here is my formula "<p style=font-size:14pt;color:red;><b>"& "$" & ToFormattedText(Round([Total with Tax & Fee],0.01),"comma_dot",3)& "</b></p>" What do I need to add to show that final 0?How to handle error in Upload step in Pipeline
I have a pipeline that uploads a file attachment to another record. There may not always be an attachment. This causes and error on the upload step. I have tried using a condition with is the file attachment set and also tried not equal to "blank" and neither by passes the upload step. Is there another way to test to see if there is an attachment to upload?Using Groups
I am graduating to more Cross app integration but adding users to several apps (and remembering to add them to all applicable apps) feels like a daunting task. I am reading about groups and it seems that I can have users in a group and then I can assign groups to apps. I am still having trouble wrapping my head around how the security will work. So I have a group that does outdoor recreation activities and they have an app to manage their equipment and with in that app they have a role that limits what they can see and the role is based on the club they work at. Now we are building out a procurement app and I don't want to have to rebuild those same roles in the procurement app but I want to limit it so that they can only track orders for their club. If I add the group to the procurement app will it use the role from their equipment app? ------------------------------ Julie Meeker ------------------------------
