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.
Build a table in a form where user can input values and save them.
I need to create a table in a form where a logged in user can enter data ,similar to grid editing. If I am not wrong the values in the table must be stored in different fields. Image is shown below. Can anyone advise me on how to accomplish this task?
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 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!How do I download files using a User Token instead of an Application Token?
Hello. I sometimes write scripts that manipulate QuickBase record attachments from outside of quickbase. Usually just like a "curl" request from the command line. In the past the instructions outlined here have worked very well. I just get an API ticket from API_Authenticate (using my username and password):, https://mysite.quickbase.com/db/main?a=API_Authenticate&[email protected]&password=XXXXXXXXXX then run a command like this from the terminal: curl https://mysite.quickbase.com/up/XXXXXXXXX/a/rXXXXX/eXX/v0?ticket=<authentication_ticket_from_API_Authenticate> > Desktop/mydownload.pdf And the file in question appear in mydownload.pdf on my Desktop BUT HERE'S THE PROBLEM: I'm trying to use User Tokens now, since they're just much nicer and easier to keep track of, but as far as I can tell there is no way to get an authentication ticket when exclusively using User Tokens for authentication. For example, running something like: https://mysite.quickbase.com/up/XXXXXXXXX/a/rXXXXX/eXX/v0?usertoken=<my_user_token> gives me a message that "User token is invalid" (despite the fact that it is a known working user token). Running the following API_Authenticate call in order to try to get a ticket from the user token: https://mysite.quickbase.com/db/main?a=API_Authenticate&usertoken=<my_user_token> gives me the following error: <qdbapi> <action>API_Authenticate</action> <errcode>3</errcode> <errtext>Insufficient permissions</errtext> <errdetail>You don't have sufficient permissions to access that page. User Tokens cannot be used to call this API</errdetail> <username>me</username></qdbapi> And this is a token that is associated with an account that has full access to the app, so I am confident it's not a permissions thing. Are there any potential workarounds to this?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.
