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.
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!
Logging edit history for Numeric Field
I want to log the edit history for a Numeric field. I tried creating FORMULA-TEXT field. But using that i can log only last edit details. But i want to log all the edit history for that Numeric Field. Currently QuickBase supports logging edits only for Text Fields. Is there any way i can do that for a Numeric Field. Also, i dont want the user to see that edit history on the form. I want the edit history to be visible to Admin only.
Ways to Log When a Record is Viewed
I've never had this use case before and was curious if anyone had any thoughts on this. I have a client who's workflows are highly regulated and they are interested in a way that we can log the Users and Date/Times that a record is opened and viewed by them. So each time a record is opened, they want to know who was looking and when they looked. Any thoughts on this? I'm familiar with setting up native Logging and have looked into the Advanced Logging tool from MCF Tech. Just curious if anyone had anything to offer. Thanks so much! ------------------------------ Todd Molino ------------------------------
