Can I extract specific text from the middle of a string?
I have a field that contains serial numbers within blocks of sentence text. I want to extract the serial numbers and place them into their own field. I cannot control the input into these fields or mandate that a new field be filled out. For example, the field may contain: "Picked up S5442 at Boxies on Golden" or "S5931 inbound to home" What I'd like my formula field to display is "S5442" and "S5931" respectively. The serial numbers will always start with "S5" and be 5 characters long total. What would be ideal is something similar to excel's 'Find' formulas - for example: MID(A1, FIND("S5", A1,), 5) - However I can't seem to find anything analogous to this in Quickbase.
Sending Forms via email for completion by outside user
Good Morning All, I want to know how it is possible to submit a form to someone via email to where they receive a link that they can access to complete said form that gets captured in quickbase. Everytime i look on the forums, the only things that come up is how to send emails with changes that have been done to a form or another.. not exactly what I am looking for.. ------------------------------ Douglas ------------------------------
Hiding Tables in Table Bar
I hide many of my tables from most user roles. However, when I add a new table it defaults to be visible, and I have to manually go through each role and hide the table. Is it possible to default to hide, or to go to the table itself and choose that option? In the table settings, I know I can set access per role, but only permissions, I don't see user interface. Can the user interface per role be set from the table settings? ------------------------------ Mike Tamoush ------------------------------How do I find the application ID.
I want to grab information from another application to a table in a separate application. When I go thru the process to do this... I am presented with a few feilds one of them being "Application ID" I can NOT proceed unless I enter in a "Application ID" Where can I find this?
Granting one user multiple roles
I recently assigned a user (not an admin) to multiple roles in the same app. That user has a management role as well as a test - front office role. I want the user to be able to view patients based on one form I created for the management role, but I also want this user to view a beta version of a new form I created under their test - front office role within the same table. My question is, how does this user toggle back and forth from multiple roles? Are they asked to select a role when they log in or do I need to go through an additional step(s) in order for this to work? ------------------------------ AR ------------------------------
App for submitting requests for a team but where users have no other access
Hello all, I'm part of a BI team that is taking over the support of QB at our company. I'm new to app building and want to see if anyone has heard/had the following scenario: We have many apps in QB which users have access. I'm building a new ticketing app for our team to support users who need help with QB or for other tasks that our team handles. For this app, I want users (either registered or non-registered) to be able to fill out the form I created but not have any other access to the app. The only people who will have access is our team (as admins) and very few managers from other teams (these will likely have QB licenses). My thought was that I would build a homepage that has a button to fill out the form (screenshot attached). Not sure if this is the best way to accomplish my task...so would love some input. My second question is about permissions. I read about EOTI but 1- that sounds risky and 2- we don't need it for anyone outside of our organization. I thought maybe the better option was granting access to all in our company per this article. However when I try that I get no results...is that how it's supposed to look? Thanks in advance for any help/advice you can give! :) ------------------------------ Julie Bowers ------------------------------How do I copy a record via api?
I need to create a copy of a record to a separate table before changing the Revision value and deleting the contents of several fields. I've got the update to the Revision value working, and how to delete the field contents - now I need to figure out how to copy the record before making these changes. Unfortunately, there doesn't seem to be an APICopy action. Thanks in advance!Audit Log table of which User deleted a record.
I know how to make an Automation or a Pipeline to create an Audit Log of changes to records and which user made the change. But is there a way to capture which user deleted a record? The [Last Modified by] remains as the "Last Modified by" and not which User did the deletion. ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com mark.shnier@gmail.com ------------------------------Can QuickBase receive & display location information from a Field Tech's phone?
A HVAC office wants to be able to view the location of their Field Techs on a Google Map within QuickBase so that they can dispatch the Tech closest to the customer?s location. The Tech?s all carry company issued Verizon phones, so would it be possible for the phones to periodically send out a message with their location information to a destination that can be read by QuickBase?s new connected tables? If the phones can?t do this, is anyone aware of a GPS device that?s stored in the service truck that can send out the location info?
