r/Quickbase • • Jun 19 '17

How QBO Bank Feed works

Thumbnail
quickbooktechsupport.strikingly.com
0 Upvotes

r/Quickbase • • Aug 01 '22

Anyone ever found a way to build a Dynamic Multi Select Text Field?

0 Upvotes

So here's the scenario, you have a parent record, let's call it Related Client. Let's assume that each client has different financial templates or just template children records.

So now you're in a job record and you choose the related client. Great, now you want to be able to dynamically choose one or more template records in the job with the idea that a created pipeline would look at these chosen records and then would copy said templates into a live records table that is under the job table.

For the life of me I cannot figure out a way to be able to dynamically select multiple records like. Every time I think I get close quick base just simply refuses to display anything or everything is unselectable. This is really driving me insane as it's such a simple concept.


r/Quickbase • • Aug 06 '24

Favorite / Popular Add-on for QB?

3 Upvotes

Im fairly new to QB, I've had experience building sharepoints from scratch with webparts, farms, etc so I'm picking up quickly. As I've learned so far there are some add-ons out there that can help a variety of aspects.

I wanted to ask what are some of your favorite add-ons or outside the box items you have incorporated to QB? Love to see some suggestions and quick recaps on use-case. As I'm learning, I want to ensure who I'm helping has the right options up front.

I've heard that QB is getting a 'pdf' generation feature coming later this year possibly, but looks like people have used: Juiced Technologies Exact Forms Plus. Any reason to just stick with this as it shines WAY better in it's current state?


r/Quickbase • • Sep 01 '22

Help with basic checkbox button

2 Upvotes

I'm fairly new to Quickbase and coding in general. I have a basic daily goals table with a checkbox when the goal is complete. I want to have some way to check the checkbox without having to leave the report, use grid edit, or open popups. Looking around online there's tons of people talking about using a formula URL button with JavaScript, but that's all depreciated now. Is there a way to do this without JavaScript?


r/Quickbase • • Aug 03 '22

Make custom integrations with python easier! (with auto-generated models)

4 Upvotes

https://github.com/robswc/quickbase-model-maker

Hey all! Just created another tool after finding myself doing the same thing 100 times over, lol.

This lets you easily register some tables to create models. You can then reference the models instead of digging around for field IDs or table IDs.

the quickest example is this...

# select relevant info
select = [3, 43, 23, 63, 21, 52, 24, 54]

Into this...

from references.order_manager import Order
select = [
    Order.RECORD_ID,
    Order.ORDER_TYPE,
    Order.ORDER_NUMBER,
    Order.DELIVERY_DATE
    ...
]

Sure, its a bit more verbose. I've found it pays off in dividends though!

There are a few more examples on github and its totally open source (might be a bit rough around the edges tho!)

Feel free to try it out!


r/Quickbase • • Nov 07 '11

Welcome to r/Quickbase

3 Upvotes

I created this subreddit to share with other Redditors my new hobby, creating (and selling) custom applications using the Quickbase platform. I have zero DBA experience, but despite that, I fell in love with Quickbase and how much fun it was to take spreadsheets, "webify" them, and share them as databases with my colleagues and clients.

Please, if you haven't tried it yet, please do so. I make zero money from this plug and neither does Intuit. This subreddit is NOT intended to earn me a single cent. I only intend to use it to share code, ideas, and custom databases with fellow Redditors.


r/Quickbase • • Dec 22 '11

Example Code and Formulas from Kirk Trachy.

3 Upvotes

============================= dbid= database ID of the table

dfid= form ID

fid= field ID

a=dr means display record

a=er means edit record

rid= record ID

clist=a

ifv= stands for iframe version. The number of pixels to indent from the left of a report or form (without a QuickBase page around it). For instance may be used in popups and printing where ifv=1 makes the form or report ready for printing with only 1 pixel from the left border.

act=q query

a=q query

qid= query ID

rdr= redirect

act=dbpage tells that the following pagename is located as a dbpage on this application

pagename= this is the dbpage name like mypage.html

username=

password=

jht=

rl=

qrppg= report x number of rows in a report

mdbid= master DBID

sdbid= slave DBID

%3D is =

%26 is &

%3F is ?

%5E is ^

%3B is ;

For more URL Encoding options visit: http://www.w3schools.com/TAGS/ref_urlencode.asp


r/Quickbase • • Jun 24 '20

Data from Excel to Quickbase

1 Upvotes

Can anyone point to a way of automating the entry of Excel data into Quickbase? I am interested in entry of 2 to 30 Excel values in a row into Quickbase as a new entry to the QB table. This will be one row at a time as a new sample is completed (not importing a completed Excel table into QB).


r/Quickbase • • May 27 '20

Integrated AWS Connect and Quickbase to build virtual call center

4 Upvotes

I've used AWS Connect (amazon's virtual call routing/handling software) AWS lambda (serverless computing, ie quick functions for scripting/integration) and Quickbase to build a virtual call center in Quickbase.

I wrote an article about it on linkedin: https://www.linkedin.com/pulse/dont-telework-spreadsheets-build-virtual-call-center-day-patricio/


r/Quickbase • • Feb 03 '23

Get USER last name only.

2 Upvotes

How can I parse a username so that I can extract only the last name ? I want to get the last name to compare to the last name in another field . Thank you


r/Quickbase • • Dec 31 '22

How to make a bar graph with weeks as the x axis

1 Upvotes

I have a tasks table that tracks estimated hours for each task as a field. I am trying to build a bar graph to show each week as a date range Mon-Fri and the estimated hours for each week.

My tasks table has a start date and due date. Any ideas on how to jump start this?


r/Quickbase • • Jan 05 '23

Creating a Button that creates an Excel document from QuickBooks data

1 Upvotes

Currently I have a code page report that pulls data from several QuickBooks tables and creates a report that is formatted exactly like a report I was provided.

However, new scope now requires that Report to be able to be saved to Excel.

Does anyone have a suggestion/tool/product that can place a button in QuickBase that generates an Excel Document from a Template?


r/Quickbase • • Jan 27 '23

Quickbase Improves JSON Validation

5 Upvotes

r/Quickbase • • Jan 07 '23

Empower 2023

4 Upvotes

Does anyone know if they're doing a physical Empower event in Boston this year? Their website just mentions a virtual event on June 7th. Kind of a bummer if it's exclusively virtual, this was going to be my first Empower and I'm excited to meet other QB devs and share ideas.


r/Quickbase • • Jan 05 '23

Quickbase Certification

2 Upvotes

For those who have passed the Quickbase Builder and Expert builder exams - would you recommend taking the combined Builder/Expert exam or taking each individually? Trying to gauge how difficult they are. Thanks in advance!


r/Quickbase • • Sep 15 '23

Alignment and Font Size changes

3 Upvotes

Is anyone aware of a way of changing the alignment and font size for the labels?


r/Quickbase • • Sep 28 '23

Pipelines for App to App?

2 Upvotes

Does anyone know how to get a pipeline to function App to App? I tried using the beta version as the legacy version is so confusing to me. It will only list my current App's tables to do what I need it to, which is to create a copy of a record into another QB app.


r/Quickbase • • Jun 27 '24

Formula to update Text(Formula Field) as you progress through sections

2 Upvotes

I'm struggling to build formula with this logic and have it actually work. It's not changing to correct wording.

If [Customer Service Complete] is blank, status should be "Customer Service" If [Customer Service Complete] is equal to "Yes", status should be "QA Review" If [QA Review and Conclusion Complete2] is blank status should be "QA Review" If [QA Review and Conclusion Complete] is blank status should be "QA Review" If [Responsible Entity Review Complete] is blank status should be "QA Review" If [Complaint Complete] is blank status should be "QA Review and Conclusion" If [QA Review and Conclusion Complete2] is equal to "Yes", status should be "QA Review and Conclusion Complete" If [QA Review and Conclusion Complete] is equal to "Yes", status should be "Closed" If [Responsible Entity Review Complete] is equal to "Yes", status should be "QA Review and Conclusion" If [Complaint Complete] is equal to "Yes", status should be "Closed"


r/Quickbase • • Jun 28 '24

Materials Calculator Help

2 Upvotes

Hey Everyone,

I am fairly new to quickbase, but have experience with sharepoint development so I am picking up quickly. However, I ran into a issue where I am needing a 'real time' calculator essentially from a running list of materials with associated costs so they can be quickly calculated for jobs in the field. There is a subtotal, field showing 10% calculation, then a grand total combining the two. They dont need the records saved, but need it to statically update as they change the qty field, and if they leave the page or refresh - it resets to 0.

Future state, they would be adding "Job Names" (JOB######), and would like a record to be saved, The catch here, field tech may add additional items down the road to that same job id so it would need to be consolidated. But for the time being, they'd like to see a realtime calculator.


r/Quickbase • • Jul 10 '24

Google Drive Pipeline Channel

1 Upvotes

Is it possible to return the url link for a given Google Drive folder based upon a search query?


r/Quickbase • • Mar 11 '24

Assistance Needed with Managing Recursion in Nested Container Inventory System

1 Upvotes

I am developing a nested container inventory management system within QuickBase and have encountered a challenge with calculating "Total Inventory" across nested containers due to recursion issues. I'm seeking ideas or solutions on how to effectively manage or circumvent this recursion to ensure the application performs as intended.

Application Overview:

Purpose: The app is designed to track the location, storage type, identity (by Part Number), description, count, and all transactions related to every inventoried item.

Container Hierarchy: Our inventory system uses a hierarchical structure where one container can contain other containers (e.g., a pallet can contain bins, which in turn can contain boxes).

Current Structure:

Tables:

CONTAINERS: Tracks each container, its contents, and its parent container (if any), establishing a parent-child hierarchy.

ITEMS: Holds information about different types of items.

TRANSACTIONS: Records additions, removals, and transfers of items in containers.

LOCATIONS: Differentiates storage locations (e.g., warehouse, vehicle).

The Challenge:

The recursive relationship within the CONTAINERS table for managing nested containers is creating a loop that prevents the app from loading forms correctly, particularly when trying to calculate the total inventory that spans across multiple container levels.

What I've Tried:

Depth Field: I introduced a "CONTAINER TYPE" field with predetermined depths (e.g., SMALL BOX = 1, ORGANIZER = 2, etc.) to assign a fixed depth based on the container type. This was intended to help manage the recursion depth.

Total Inventory Formula: Attempted to adjust the "TOTAL INVENTORY" formula to account for container depth but still facing issues with accurately calculating totals without causing performance issues or loops.

Seeking Solutions For:

Optimizing Recursion: How to efficiently calculate total inventory across nested containers without running into recursion limits or performance bottlenecks.

Depth Management: Best practices for utilizing the "CONTAINER TYPE" field to manage recursion depth or alternative strategies that could circumvent the need for deep recursion.

Formula Adjustments: Any suggestions on adjusting the "TOTAL INVENTORY" formula to work with the depth-based approach or other innovative solutions to this problem.

I appreciate any insights, examples, or guidance you could provide on tackling these challenges. Has anyone here worked on similar recursive setups within QuickBase and found effective strategies for managing them?

Thank you in advance for your help!


r/Quickbase • • Feb 16 '24

Archiving

1 Upvotes

Our company has a database created in Quickbase. We are porting the info to an ERP but would like to be able to access the info for a few years.
Any suggestion on archiving without significant cost?


r/Quickbase • • Mar 20 '24

Color coding formulas syntax

1 Upvotes

I'm trying to add a set of conditions to highlight possible setting mismatches in a database. All colors are based on pairings of two columns which may indicate a mismatch if they have specific values together. I have a single condition working but can't figure out how to add others.

At this point I suspect I have made a mess of parenthesis or something but I can't get it to save, I may also be missing an initial If() to contain it all, but with that it seemed to be ignoring the 2nd and third conditions. Can anyone help out with my syntax?

// 1. Minor + >18 = Mismatch

If((([Age])>=18), If((([Legal Status])="Minor"), "red"),

// 2. Emancipated + Guardians = mismatch

If((([Legal Status])="Emancipated"),If(([# of Guardians]>0), "orange"),

// 3. Protected + NoGuardians = mismatch

If((([Legal Status])="Protected Person"),If(([# of Guardians]=0), "orange")

r/Quickbase • • Feb 19 '12

"Check All That Apply" field

1 Upvotes

This is something that is practically demanded by users, but doesn't seem to get any attention from the devs.

We should be able to do this without listing out all of the checkboxes. My solution requires the following:

  1. A multiple choice field

  2. A multi-line text box with append only- tight style

  3. A formula text field with a 'list /n' formula

  4. A checkbox "trigger" to add each choice to the multi-line text box, then clears itself and the multiple choice dropdown (using form rule)

  5. A form rule that changes the multi-line text box to the value of the choice

If you need help setting this up, let me know.


r/Quickbase • • Nov 07 '21

Happy Cakeday, r/Quickbase! Today you're 10

3 Upvotes