Resource Icons
Latest Highlights
Check Out The Latest in The Qrew
1 MIN READ
Hi Qrew,
While there are no Qrew Meetups this week, this is an important week for the Qrew, as we'll be opening up registration for Empower26! Be on the look out for more details for Call...
Maria
Community Manager
1 MIN READ
If a quick summary is what you need, in under 3 minutes I will walk you through the most recent updates to Quickbase, right here:
Highlights include:
New getRo...
RobHenderson
Quickbase Staff
3 MIN READ
When you talk to Mark, you can sense two things immediately:
he’s been using Quickbase for a very long time
and he’s still having a blast.
As the founder and Principal Engineer of Your Qui...
Maria
Community Manager
The Content Feed
Feed
Autopopulate Form Fields
Hello, I was wondering when a user enters demographic info (i.e., First Name, Last Name, Date of Birth, etc.) on a form, is there a way to autocomplete / autopopulate a user's info? For context, this is a concern because we have staff members who often enters multiple entries for the same clients/members on QuickBase and they frequently have to reenter the same demographic info. Can non-users info be saved or accessed in an easier way? Please let me know if I need to elaborate. Thanks in advance!Solved0likes1CommentDocument template barcode field
I'm creating a document template and I want to add a barcode of a text field. I've added this to the source directly from a rich text formula field. The resulting document is displayed as What is the proper notation to get the field "UDI" into the <img src....? Thanks.Solved1like4CommentsSecure Links & File Attachments
I have an EOTI user and role. They can only access records where the key = valid. This much works as expected. The problem is on records they can access, if they click a file attachment (just a field on the same record), it returns a Quickbase not found error page. Doesn't let them access the attachment. In the Quickbase docs it says: "You can use the EOTI group to provide access to file attachments at a more granular level than what Quickbase offers, that is, using Quickbase without custom code or API access from a separate environment." So it seems like it should work. What am I missing?Solved0likes4Commentschange navigation button so it opens the new location in edit mode
My app has a button that redirects to a documents table, but I need that to be opened in edit mode. If I use the button, it automatically switches back to view mode. If I choose edit mode from the documents table it refreshes me to the top of the form. There is a checkbox I want people to use next to the documents table, but the only way they can get it to work is if they tab over 10 tabs to the documents table - making the button that takes them there immediately useless if they need to use the checkbox. The button uses a formula to make it work: "https://thefamilyplace.quickbase.com/nav/app/buf7b3sig/table/buf7b5kxp/action/dr?rid="& URLEncode( [Record ID#])&"&rl=dvb&page=21" how do I adjust this so it opens in edit mode? Thank you for your help!Solved1like6CommentsFormula to lookup value in another related table
I have a lookup table that has a relationship with 2 other tables (Table 1 & Table 2). There are 2 different IDs in my lookup table that I need to check in Table 1 & Table 2. I need to check Table 1 if one of the IDs exists, if yes then I need a checkbox ticked. For the other ID, I need to check if it exists in Table 2, if yes then some other checkbox is ticked. How do I go about doing this?Solved1like1CommentUsing Total in a child table embedded in a form
I have a form (based on a parent table) with 3 embedded reports (based on the same child table). The children reports are the same except that they have one different filter each. I need the Total of a column to calculate another column (class % in my picture). If I use the summary field in the parent table, it gives the total of the all three tables. (See first picture) I also tried with the report formula but I have the same issue. Do that Total field have a name that we can re-use in the formula ? You will find attached some pictures of my form for your understandingSolved0likes2CommentsOn Form Open, populate an User and Timestamp field. No way to trigger rule on Form Open?
Hi! Use case: On opening a form (new or existing record) I want to auto-populate a field (e.g. timestamp field with now() and a user field with currentUser()) when the fields are currently empty. I tried the following: ❌ A trigger that is just user == <other> with a blank field --> should be true on open but does not do anything ❌ A custom when formula with the content `true` --> definetly true on open, but does not do anything ❌ Record ID != -1 (also always true) does not do anything ✅ A trigger "when checkbox is checked" using a helper checkbox: As soon as user checks, checkbox, the field fills correctly. But this is not the intended behaviour 🤔 The options to change field value after save and validation also seems to work (mostly) But this is not the intended behaviour. Any way of enabling this pattern of "fill a field when form is opened (and field is empty)" would be helpful.Solved0likes4Comments