Recent Discussions
Rich text lookup field not displaying correct when emailing a report
When I email a report from QB, I have a rich text lookup field that is not displaying correctly, it is showing the actual code: <span style='font-family: Gibson-Regular; font-size: 13px;'>Aviation and Occupational Medicine</span><br><span style='font-family: Gibson-Regular; font-size: 10px;'>6900 East 47th Avenue Drive<br>STE 100<br>Denver, CO 80216</span> (8 AP Invoice) Any ideas why or how to correct this issue?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() )
Filtered Dropdown on Form
Hi everyone, so I am trying to create a dropdown for user to pick in a form and the dropdown need to be filtered from user previous selection. But if previous selection is not selected, user still be able to pick the dropdown and select from it. To make it easier to understand, let say I have a form (in table called Main Table) with three dropdowns (State, County, and City from three tables) and State < County < City. If user pick Texas in State, then County dropdown will filter to only show Counties in Texas. But if user decide not to pick anything in State, the County dropdown will show all County in every states. Then if they pick Dallas County then City will filter to only cities in Dallas County and State will still be empty. I am aware of Conditional Value (in Field Settings) but it requires user to first pick State in order to pick County. I am open to any suggestion and solution. Feel free to ask if you need me to explain more.
The new "sidebar" navigation sucks.
The new "sidebar" navigation sucks. Everyone in my organization hates it. It is needlessly cumbersome to do anything now. It is also really stupid that you guys aren't going to let us, the paying customer, simply have the choice in how we prefer to use it and instead force it down our throats after the new year.
Reference tables quandary
I have 3 (Parent) reference tables: Dx Codes Reference, Pcs Codes Reference, and MS-DRG codes. Then there is a Charts table, and two connected tables: Dx Codes and PCS Codes. The relationships between them are as follows: Dx Codes Reference < Dx Codes Charts < Dx Codes Pcs Codes Reference < Pcs Codes Charts < Pcs Codes MS-DRG Codes < Charts Each year the Reference tables get an updated codes list. My plan had been to just add 3 new reference tables each year for the new codes list. but my quandary is how to have a field that picks from the appropriate reference table dependent on the chart discharge date. Is there a way of doing this? Thanks for any insight you can provide. -AudraHow to extract the URL value from a File Upload field
I'd like to get the actual file URL of a file uploaded to a File Upload field. How can I do this and display the URL in a form? My use case: Users can upload an image file. I want to display that image in an <img> tag in a rich text field in the form.
Sending email of Purchase order to our vendors (not QBase Users)
We have many many projects and within those projects we have templates that hold our labor and material for the specific projects. Each of the different labor and material has a vendor attached to it. I need, when I click ready to release to vendor, an email is sent to them allowing them to approve that PO via the email. Please help, the specifications on this are all over the place throughout the years.
