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.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?
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 ------------------------------
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 ------------------------------
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 ------------------------------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!
