ContributionsMost RecentMost LikesSolutionsRe: NEW CLIENTS Hi David, I have done this for many years using QuickBase. In my situation I built an application that addresses the target businesses I was after. The application is a product lifecycle management solution that manages product development from concept to production. Then I went after my clients demonstrating the solution capabilities. It worked, since QuickBase provides all the infrastructure and SAAS capabilities. Please feel free to reach out if need more info. souheilkaram@chameleonplm.com ------------------------------ Souheil Karam ------------------------------ Re: Fully exploding a Bill of MaterialsHello Edward, An approach you may consider is described below: 1 - Every item on a BOM has a parent coming from part master table or another part/assembly table. 2 - Create a BOM table that references part master table 3 - Assemble your product BOM with parts by selecting from part master table. Identify each BOM part with a parent. The parent will be a part. Same as you do with project task dependency 4 - Identify each BOM part with an order 5 - create your report by grouping on the parent and sorting on the order. ------------------------------ Souheil Karam ------------------------------ Re: Barcoding and key fieldsHi Dan, As follow up on Mark's inquiry what would help is provide a simple data model of your requirement, that would help. You may take a snap of the relational tables from inside quickbase. ------------------------------ Souheil Karam ------------------------------ Re: Quickbase API DoQuery Child ListHi, If table A is related to table B, then the 2 fields or as many fields from record A can be shown on related records in table B. So, if need to use api_doquery, just query table B where query = {related_record_A.EX.rid} where related_record_A is the relationship from A in table B and rid is the key in table A. if using the api via browser, you will need to know the rid in A. if using a programming language, you will need a list of all the rid's in A. ------------------------------ Souheil Karam ------------------------------ Re: Quickbase Automation Copying RecordHi, Automation is limited to certain number of records. If you exceed that number it will not work. I believe if 1000 records change in one operation it will not trigger. If that is not the case, you may want to post your automation for me to look at the criteria. ------------------------------ Souheil Karam ------------------------------ Re: Automatic Sequence Number FieldHi Syaeful, You can make this field a formula field that is made out of a concatenation of other fields. For example: 1 - Make the field called number a formula field 2 - Create a multi select field called UNIT NAME with the values [Finance, IT, etc..] 3 - If the date in the field is today use a formula formated date field and convert to text so your number formul field will be: PRF & [UNIT NAME] & ToText(Today()) you can get fancy and fromat the today) in many ways ------------------------------ Souheil Karam ------------------------------ Re: Thumbnails of externally hosted imagesHi Ashis, If you have the name of each image file that is on AWS in a field in QuickBase table, for example [qbimage], then you can create a formula field in quickbase as such: If(Length([qbimage])>0,"<img style='max-height:100%; max-width:100%;width:100px' src='[URL to AWS]" & ([qbimage]) & "'/>","") If you don't have the name of each image in you quickbase database you might have to resort to a way to add the image names into your table. Make sure the image file names have a pattern or have a name like dbid_rid pattern where [dbid] is the table id and rid is the record that the image belongs to. ------------------------------ Souheil Karam ------------------------------ Re: Is anyone out there using a cell phone app to scan barcodes into a QuickBase app?Have you resolved this requirement? If still looking for a nifty barcode solution, we have a native mobile barcode solution from you Mobile devices directly to Quickbase. Let me know if interested to review ------------------------------ Souheil Karam ------------------------------ Can I send an attachement with an email, subsription or notificationWant to send a subscription to a report but send the report as an attachment.