ContributionsMost RecentMost LikesSolutionsSurpassing 500mb limit for tables Hello, I am working on a project for my company, we are pushing NOTE_TXT data into a QB table to be read by our customers as part of a larger application. We're still developing right now. I am not the QB developer here, I am responsible for the data. It was discovered that we are going to surpass the 500mb limit on the table very quickly. The data we want to send in is already as lean as we can make it, the only thing I can think of to make it leaner is to either remove records, or truncating NOTE_TXT fields. Questions 1. Can the 500mb limit be increased? Is that limit an arbitrary cap set by whatever plan my company purchased from Quickbase...or is it a physical limitation of the storage mechanism used by Quickbase? 2. Can multiple physical tables be joined together into a single virtual table? 3. Can multiple tables containing the same type of data be addressed by Quickbase? Say, I create tables NOTE_1, NOTE_2...NOTE_n, and have something like an intermediate NOTE_LOOKUP table to assist with managing the NOTE records? Thanks, Nick ------------------------------ Nicholas White ------------------------------ Data lost/empty fields when adding records/populating fields with HTML data using (Alteryx) API Hello, My setup: 1. I get text data from sources, blend and mangle it together in Alteryx 2. Data leaves Alteryx via API tool, arrives in table in Quickbase I can add records easily from Alteryx. Where I'm having issues is when I try to send over text data which includes HTML tags. The field I want to sent HTML information into is a Rich Text field. The problem is that some of the records will not populate the the HTML information in the Rich Text fields; it populates absolutely nothing. To add insult to injury, if the Rich Text field gets skipped, it will fail to populate any subsequent fields in the record. I spent a few hours stripping out various tags I can live without in Alteryx...the usual suspects, like ', &, <BR>, a handful of others, and I can't seem to find the right combination to get it where I am able to successfully send over data every single time where all the fields are populated. Does anyone have experience with this? Are there things I should be doing in Alteryx to make sure that the data is QuickBase friendly? Thanks ------------------------------ Nicholas White ------------------------------ Re: Ability to select records from a table embedded in a form? Hi Evan, Thanks for your reply. "There is obviously more that goes into getting the exact experience that you are looking for as Mark mentioned, especially if there are some elements you really want to appear in a specific way. " The vibe I'm getting, that 'displaying a list of records as a sortable, filterable table; with radio buttons on the side to load a record into the form', is not possible out of the box. I'm fortunate that this app was already built using a dropdown which gives the users the ability to select records; I'll go back to my boss to report that this will require more work than anticipated to get that dropdown to appear as a table with radio buttons. Thank you, Nick ------------------------------ Nicholas White ------------------------------ Re: Ability to select records from a table embedded in a form? Hi Mark, Thank you for replying so quickly! I redid my drawing to better illustrate what I'm trying to achieve. I'm not inventing a new wheel; I'm modifying an existing one. I am working with an App which was developed a few years ago, the tabular part I'm envisioning already exists in the form of a drop list. The drop list is a little clunky, I was hoping that a table might make it easier for the users to select records. Here's the setup of how the existing app would work after my modification: Audits Table - a list of audit results, where selected transactions from the Transaction Table are reviewed by our auditing team, scored, and submitted. Transactions Table - a massive list of sales transactions Add Audit form - form used to pull in select fields from a Transaction record from the Transactions Table, and fields where the auditing team can score the Transaction. When the form is submitted, the TRANSACTION_ID and the scoring elements from Section 3 get added as an Audit record in the Audits Table. Workflow: 1. Auditor opens the Add Audit form 2. The Add Audit form pulls records from the Transactions Table and populates them into a tabular list seen below in Section 1. 3. The auditor looks through the list of Transactions and selects one by clicking the radio button next to it. 4. The Add Audit form puts read-only data related to the selected Transaction into Section 2. 5. The auditor reads the information in Section 2. 6. After the auditor understands what's going on with the Transaction, the auditor goes to Section 3 and fills in the 6 audits elements based on an audit business process we have here. 7. When Section 3 is complete, the auditor clicks the Save & Close button. 8. The Add Audit form will bundle the following information into a nice tidy data bundle (or whatever it's called in Quickbase) and create a new record in Audits Table: TRANSACTION_ID - from the Transactions Table SCORE_1 - user input from Add Audit form ROOT_CAUSE- user input from Add Audit form DROPLIST_1 - user input from Add Audit form SCORE_2 - user input from Add Audit form DROPLIST_2 - user input from Add Audit form NOTES - user input from Add Audit form I hope this makes sense, this stuff can be confusing. Thanks, Nick ------------------------------ Nicholas White ------------------------------ Ability to select records from a table embedded in a form? Hello! First post here, brand new to Quickbase. I've done web app development before, but it was PHP + database + HTML + CSS + Java Script stuff by hand many moons ago. I think I am looking for guidance, something like 'you need to read up on Quickbase Thingamajigs and how they relate to Quickbase Whatchamacallits', rather than a step-by-step set of instructions. If someone can point me in the right direction, I can do reading on my own time and figure it out. The graphic I have below is an Illustrator mockup of what my boss wants a form to look like, I drew this by hand: The bit at the top in Section 1 with the radio buttons and a table is what I'm interested in. The tabular rows thing is a screen grab from Excel. I want to create a table-like entry mechanism which allows the user to select a record using the radio buttons on the left side, and details of that record populate in Section 2. I would love it if that table-like entry mechanism could pull in all the records from the Transaction Table, and give the end user the ability to sort and filter records to reduce the list to a smaller one. The end user will then select the appropriate record from its corresponding radio button. Is this kind of record-selection mechanism possible in Quickbase? Thanks Nick ------------------------------ Nicholas White ------------------------------