SamW
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
New Python Library to Provide Local Quickbase App Backups
I've been slowly teaching myself Python for a while, and have just uploaded an early version of a library to interact with the Quickbase RESTful API. It's very rudimentary right now, but the one fully functioning thing is the ability to backup as many reports as you like in one Quickbase app to local JSON files. This would built for my own use, but I thought it'd be fun to turn it into something that others might find helpful. Download Python (tested up to Python 3.9), pip install the module, create the reports in Quickbase you want to backup (just add 'BACKUP' to report title), and then three lines of code will download and generate local JSON copies. https://pypi.org/project/my-quickbase/73Views0likes0CommentsHow to create lists of entries in a single field?
Currently, two of my tables include aliases for individuals and organizations. So at the top of each record I have the fields Name and Aliases. Name is just as regular text field, while Aliases is currently a multi-line field, as sometimes a person or organization has multiple different names/different spellings of names. Users are supposed to separate each alias with a semi-colon. However, to my endless annoyance, many don't, using new lines or commas. I was hoping for a workaround for this problem. I was thinking one solution would be a system to only allow the generation of one alias at a time, a bit like a multiselect field. However, a multiselect field would make everyone's aliases available to all the records, which I don't want. Is there another option I'm not thinking of? Some other sort of way to create manual lists within a single field? (I should add that aliases are not something we want to track in a separate table). ------------------------------ Sam ------------------------------How to create 'families' of records within one table?
I have a table filled with people. Some of these people are related. (this is not my actual data, but I thought it easier to explain than the slightly over-complicated reality). I want to record those relationships within that one table. 1) So if Matt is Jim's son, I'd want Jim's record to state that Matt is his son, and Matt's record to say that Jim is his father. 2) Then, if I later add Lisa as Matt's sister, I'd want Jim's record to automatically show that Lisa is his daughter. Does anyone have any ideas about the best way to set this up? I can get 1. working by setting up a hidden second table and running two relationships to it from my main table, and then setting up an automation so that when I add one record in this hidden table, it creates another record with the inverse information. I'm guessing this isn't the best way? ------------------------------ Sam W ------------------------------28Views0likes1CommentCombine values from an entire column of text fields
I have a table of 'Research Words'. It has about 60 rows, each containing a field named 'Research Word'. I would like to have a separate multi-line text field somewhere else that concatenates all those different Research Words. I tried creating a parent table - 'Research Words Combined' - and using the Combine Text summary field. But it turns out that has limit on the number of characters and rows it can combine (I think it's 25 rows). Can anyone suggest a way I can successfully combine all my Research Words into one field?How to Keep HTML after Using Left Function to Produce Excerpt?
I use the Left function in a Rich Text Formula field to show the first 200 characters of a regular Rich Text field. However, in a report, this appears to strip it of its HTML function, showing the source code instead. e.g. Hello become <a href="google.com">Hello</a> Is there a way for me to avoid this, and preserve the HTML functionality?