ContributionsMost RecentMost LikesSolutionsRe: How to use Pipeline to find the sum of a field? Hello Jay, If possible on your app,I suggest creating a summary field to obtain the Hours total (on a parent record that would be associated with all the children that contain those hours you want to sum up. Then with the pipeline you can grab the Hours total from that summary field you created and send it to the other app. Alternatively, you can obtain the Hours total by creating a formula query field, that will query (as your pipeline does) all the records and return the sum of Hours. SumValues() formula query function – Quickbase Help Let me know if you have questions. ------------------------------ Alberto Tablada Alberto@bluewellgroup.com Lead Software Engineer BlueWell Group Florencia +50688083124 ------------------------------ Re: Text colors on new dashboard Hello Everett, This is an interesting find, it looks like the texts in buttons are always white. I would suggest you use darker colors for buttons if possible, otherwise, we would have to request to Quickbase to add an option for font color. I tested and made a button white and I couldn't read anything 😅 ------------------------------ Alberto Tablada Lead Software Engineer BlueWell Group Florencia +50688083124 ------------------------------ Re: Bring field "forward" to related table Hello Tony, if you don't want to expose the email on the form, and want to show it to user after submission. Have you considered sending a notification email to user after the form is submitted, and on this notification include the selected department's email (you might have to ask user to provide their email address, assuming you are using an EOTI form). ------------------------------ Alberto Tablada Lead Software Engineer BlueWell Group Florencia +50688083124 ------------------------------ Re: Running inventory As Chayce said, probably capturing the previous period inventory and saving the value on a numeric field on the new inventory period record would be the best solution. You can do this with a pipeline and a couple of summary and lookup fields, something like this: Create Summary field to obtain Max Record ID of child records. Create Lookup field to this field that was just created in step 1. Create Summary field to obtain Max Record ID, but this time with filter where Record ID# must be less than [Lookup from step 2] Create Lookup field to field created on step 3. Summary field to obtain Max Ending Inventory, with filter where Record ID# must be equal to [Lookup from step 4] Create new data entry numeric field to capture Previous Ending Inventory value. Then create pipeline to run for example when an inventory record gets updated and the "Previous Ending Inventory" is empty, then have the pipeline query the parent record, and obtain the value from "Max Ending Inventory" and save this value on "Previous Ending Inventory" of the inventory record that triggered the pipeline. ------------------------------ Alberto Tablada Lead Software Engineer BlueWell Group Florencia +50688083124 ------------------------------ New Forms | Saving Glitch Hello Quickbase Community, I wanted to ask if you have ever experienced a glitch like this before: Basically, I'm trying to save the record and Quickbase is telling me that a field was modified before my changes could be saved (even though no one else edited this record), so I review the changes and select Keep, but it won't save no matter how many times I try. To make it work I have to cut the changes I had made on the specified field, then save the record, then refresh the page and paste the changes back and save the record. Has anyone faced this scenario before? how do you fix it? Thank you! ------------------------------ Alberto Tablada Lead Software Engineer BlueWell Group Florencia +50688083124 ------------------------------ New Forms | Missing Field Hello Quickbase community, I'm experiencing an issue with the new Quickbase forms where I have a predecessor field called "Predecessor Tasks" on the form, yet I cannot find it, even though I press the arrow icon to find the field on the form, it doesn't take me to it (see attached screenshot), and the form doesn't allow me to add the field to the form again. I wanted to know if anyone else has experienced this and if they have found a solution to make the field show up again, or how to remove from the form so it can be added again? Thank you! ------------------------------ Alberto Tablada Lead Software Engineer BlueWell Group Florencia +50688083124 ------------------------------ Re: Upload to File Attachment field using API_ImportFromCSV Hello Ryan, Yes that's correct, I've made it work with API_AddRecord for cases where I have to create only one record at a time, and there's no problem at all, I can see the image on the record created. But the problem when using API_ImportFromCSV is that I don't know where to specify the filename property which is necessary for File Attachment fields to work. Thank You. ------------------------------ Alberto Tablada ------------------------------ Upload to File Attachment field using API_ImportFromCSVI'm used to uploading images to File Attachment fields using API_AddRecord and API_EditRecord, however I'm now in a situation where I'm already using API_ImportFromCSV to send data to Quick Base (since I'm creating several records at a time) and I need to send images for each one of those records. So my question is if it's possible to send images to File Attachment fields using API_ImportFromCSV? ------------------------------ Alberto Tablada ------------------------------