Formula to look up a corresponding field from a related table?
I'm a new QuickBase user. This is probably a simple question, but I don't know how to construct a formula to look up a corresponding field from a related table. I have a parent table and a child table with a one-to-many relationship. The child table contains only two fields: Code and Description. There are thousands of records in the child table, each containing a Code and a corresponding Description. The parent table has a form. One of the fields in the form allows users to manually enter a Code. Another field in the form -- which is a text formula field -- is where I want to enter a formula that will return the corresponding Description based on the Code entered in the first field. Both the Code and Description fields from the child table are part of the relationship to the parent table. I'm not sure what functions in Quickbase will produce the desired result. I've scoured online help, the knowledge base, the community, etc. for several hours. The closest I've come is finding a response saying yes, QuickBase can do this, but no instructions on how. Can someone please help? Thanks in advance.
August 27th 2PM EST-Ask Me Anything-Cloudpipes, Automation, and Integration with Jay Jamison
As many of you have seen in your inboxes, we announced today that we acquired Cloudpipes, a leading cloud-based integration and software platform. This is a huge step towards our vision of delivering an enterprise-grade integration platform inside of Quick Base. We are working on getting this combined platform to the market as soon as possible, and will keep you all updated. Read more about this announcement, and sign up to stay in the know, from our CTPO Jay Jamison. Through all of your feedback on and hunger for power integrations and workflow automations we knew that this was the next step to giving our customers exactly what you all need to be successful and power your teams and your businesses. This community is a key stakeholder in the decisions we make on how to better our product every day. This is another step in that direction, and we want to give you all the chance to ask the questions that you have! AMA Details We will be holding an AMA (Ask Me Anything) with Chief Product and Technology Officer Jay Jamison on Tuesday August 27 from 2-3 pm EST to answer any and all questions you may have about the acquisition and the future of the product. You can start submitting your questions here in this Community thread between now and the event. Then Jay will be in this community thread live to tackle them on Tuesday August 27!
How to stop user(s) requesting permission to create applications billed to the account
We are periodically getting an email from users stating they are requesting permission to create applications billed to the account. Checking in with one of the users, the request to create an app came as a popup on the screen. The popup is exited out (clicking the X), though the user has to click several times to close it. These are not desired requests, yet as the account administrator, we receive emails that the users are requesting it. It seems this is an error with the popup if they are not actually making the request. Is there a way to disable this popup for the users from randomly appearing? I'm not sure yet what this looks like. Hoping it's an easy solution to resolve. Thanks!
Still no way to hide 'New App' button?
Is there still no way to hide the New App button? It's the first button everyone tries to click, so I receive about 10 requests a week to try to create new apps. Has anyone come up with a way to remove this button?? ------------------------------ Michael Tamoush ------------------------------
How can I set up a Quick Base Access Request process?
We have an app where the owner wants to set up an Access Request approval process. We need for users to be able to submit a request for access to the app. Have the request route to an admin who then determines who should approve and routes the request to the correct approver. Then the approver would go in and approve the access. Finally the admin would provision the access. We would need to be able to pull quarterly reports that show each user, every app they have access to, who approved that access and when the access was provided. Does Quick Base have anything built in that would allow us to do this sort of process? I know we can build an app to do this but I was wondering if there was something already built in on the realm side.
Selling an app to my clients...
Hi, I am working on an app that I think I can monetize, sell to several of my clients. I am having a hard time finding any guidance on how to best do this. Am I able to copy the app into their QB account? Or would it be better to keep the app in my QB account and then grant them access? If I do this for multiple clients will they be able to use SSO on their end? Hope the question makes sense. Thanks for your help!
