ContributionsMost RecentMost LikesSolutionsRe: Join us on our Journey to Reimagine the Quickbase Exchange This is a huge loss of ability and information for those of us who know how to use the old exchange. While the new exchange may look nice is is largely toothless and has 10% of the apps that the old one had. Re: Running inventory Hey Chayce I do have that already. I created a formula URL that takes the inventory to the parent table and then pushes it into a numeric field upon creation of the child record. However, if something changes, or there is a correction in the middle of the sequence, then all of the following records have to be manually updated. ------------------------------ Brian Hunot ------------------------------ Re: Running inventory It's only a single numeric field. I could copy it, but in 2024 that seems like a lot of manual entry. This is a database not a spreadsheet. ------------------------------ Brian Hunot ------------------------------ Running inventory I have a table that tracks inventory at our locations. Every 2 weeks we measure and report the inventory so that every 2 weeks there is a new record for the inventory. I'm trying to create a formula where the beginning inventory of one period (record) is always the ending inventory of the period (record) previous to the current. I have formula queries that return the result from the table itself and also lookup fields from a parent record, but I can't seem to make a formula that is not recursive / references itself, because by definition ending inventory formula is (beginning inventory - sales + receipts = ending inventory) ------------------------------ Brian Hunot ------------------------------ Re: Name and rename pictures and attachments in attachment fieldsHey everyone, happy new year. Has there been any progress or changes on the feature to rename a file attachment after upload to Quickbase? ------------------------------ Brian Hunot ------------------------------ Re: Aligning fields with each other and or the right side of the page Hey Mark, thank you. I agree Forms are long overdue, not just for a refresh, but some serious UI upgrades. It would be nice for someone who actually uses them daily to be involved in the update process. I will definitely continue to leave feedback on forms on their page. I have been using Exact Forms, not the plus version offered by Juiced. It does work, but it takes a long time fighting formatting within MS Word, and it keeps defaulting to a Web Layout view. There is a similar option to exact forms that uses MS Excel from another vendor that would be easier to use for this kind of thing, but the price is quite high. ------------------------------ Brian Hunot ------------------------------ Aligning fields with each other and or the right side of the pageI've been searching for a way to align numeric fields so that you can read them easily and the document looks polished. I've spent quite a lot of time already inserting 'blank' text form elements, saving it, going back to look at it, adding another one, saving it, etc. There must be an easier way. I am thinking it may involve a code page. The pdf attached here is after quite a bit of form element wrangling, and can all be undone by adding another field. But it takes a long time and now that I have many forms for different users, would have to repeat this process over and over. Any ideas or workarounds out there? Thank you. ------------------------------ Brian Hunot ------------------------------ Re: Formula field that is unique to each record in a tableHey Mark, I haven't quite built all of the tables and fields to make this work, figuring out the best way to do it. There are a couple of different facets in the relationships. I was considering relating the table to itself, but hadn't thought about conditional drop downs. I've been hoping I wouldn't have to make a bunch of tables or fields. It would be convenient to have a formula field that acted like a standard text field, but that doesn't seem to be possible. Is there a way to have a formula field reference the contents of a text field and use it as a variable so to speak for the formula. This can be done in Excel. It's really the same basic CASE formula across all the calculations. And the inches / measurement component is always a number between 0 and 99. ------------------------------ Brian Hunot ------------------------------ Formula field that is unique to each record in a tableIs there a way to have a formula field be unique to and have different values for, each record? Each of the 40 records in our Locations table has fields that describe the location and these are unique to each record. For instance, the address field. However, the formula fields in this table are 'universal' by Quickbase design; the formula field has the same value and performs the same calculation across all records using values in fields that change with each record. Is there a way though to have the ability to put a different formula in the same field in each record so that it will use the right numbers for each individual record? We have 40 locations that have tanks for liquid storage. Every location has different size tanks. We measure the tanks with yardsticks, such that each inch of height equals a specific volume. I made a simple CASE formula that will return a volume for each tank given an inch measurement. I found that the numeric entry fields would change with each record but the formula field was the same, because there can only be one value in that field for the table. In another table, with a somewhat similar scenario, I put an IF formula in front of the CASE formula that would only perform the calculation on the field if current record matched a certain Location name. The problem is that I would have to create over 120 of these fields, once for each tank at each location. The other solution I thought of was just to have a formula field that housed the IF and CASE formulas for each location all in one field. This field however would have thousands of lines of data, which seemed excessive. So I figured that I would ask to see if there was a simpler solution. ------------------------------ Brian Hunot ------------------------------ Re: Subtotals in table reportsOkay, thank you Mark. I can't imagine an alternative way right now, but it's still early in the morning. ------------------------------ Brian Hunot ------------------------------