ContributionsMost RecentMost LikesSolutionsMS SQL and Access Database to QuickBase We merged with a company that has a legacy application on a local physical server that has a MS SQL backend and an Access frontend. Does anyone know a third-party company that works on migrating these sorts of applications to QB? I see some services that move Access to QB (Juiced being one), but I am not sure what extra wrinkles are added with the MS SQL backend. Thanks. Ben ------------------------------ Ben Gillihan ------------------------------ Connected Tables Last Update Time/DateI have around 20 connected tables that update daily or multiple times per day. I would like to have a summary location of all the tables' last update date so I can catch any update problems. Is there already a location in QB that has this that I am not finding? If not I assume I need to do an automation for each connected table to post the last update date to a summary table. Thoughts or ideas? Thanks! ------------------------------ Ben Gillihan ------------------------------ Summary of TrainingWe have employees who progress from levels (1-4) in their trade based on completing various training tasks. I would like to have a list of all the training for each employee showing what training tasks they have completed and which ones they have not (so they know what they need to do). Showing what they have done is easy enough, it is including what they haven't done that I am unsure about. I have 3 tables at the moment for the training. A summary for each employee of completed tasks. A table with the completed tasks. A table with all the (119) possible tasks they can complete. I would like to have a report that shows the status of all 119 tasks for each employee. I suppose I could have a record for each employee for each task and the status (complete or incomplete), but this seems very manual. I am unsure if the list of tasks and status of complete or not complete would be done in a new table or just be a summary by the employee in the task list table. Thanks! Ben ------------------------------ Ben Gillihan ------------------------------ Attachment Files Size in a Field Is there a formula that could be written to create a field to show the size of a file attachment? I know I can get the information in settings, but I'd like to be able to have the information for reports so we can keep an eye out for large attachments and move them to Dropbox, resize them, etc. Thanks. ------------------------------ Ben Gillihan ------------------------------ Re: Field required based on value in another field Ugh, super simple. Thanks guys. I am surprised I couldn't figure that out myself of find it in the search. Have a great weekend! ------Original Message------ Ben, Assuming you have people entering the data into a form then the answer is yes. Here is a screen shot of a form rule where you would set the values to require entering the data. Where are you going to get the County data? Will it be a Text field so they can type the name or will you have a Table of Counties and connect it via a relationship? Your follow on reporting will vary significantly based upon what you let the user do next. ------------------------------ Don Larson Paasporter Westlake OH ------------------------------ Field required based on value in another fieldIs it possible to make a field conditionally required? If a job we are working on requires us to pay prevailing wage, we want to require the user to enter in the name of the county where the work will be done. It is not required if the job is not prevailing wage. So if "Prevailing Wage" =Yes then "county" is required. If"Prevailing Wage" =No then "county" is not required. Thanks. ------------------------------ Ben Gillihan ------------------------------ Re: Save Daily Summary in new table That worked perfectly. Thanks Mark! ------Original Message------ OK, so all you need to do is to create a table of Locations and set the Key field to be the location name.. The go to that multiple choice field properties and copy the choices onto your clipboard. Then go to import / export for that Locations table and import from clip board and populate the same choices. Then make a relationship back to the details table based on that multiple choice field. One Location has many detail records. The multiple choice field will now convert to be the reference field from that table. Then make a summary on the Locations table for your daily stats that you want to capture. The go to import / export and set up a saved table to table copy from locations to the stats table. You may also need to create a formula date field in Locations for Yesterday as you will need to populate the date. Then lastly set up an Automation to run that saved table to table import every day. ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com markshnier2@gmail.com ------------------------------ Re: Save Daily Summary in new table It is a simple multiple choice at this point. ------Original Message------ Is the managing Location from a table of Managing Locations or is it a simple multiple choice field? ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com markshnier2@gmail.com ------------------------------ Save Daily Summary in new tableMy question is similar to this one, but either my question is a little different or I can't figure it out: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=c0c28a60-ad19-4ad5-8504-80a53cb9490e&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer I have a summary report for a table that shows total current backlog for each of our locations: I would like to save these totals daily to another table so I can look at the backlog by location (the amount left to invoice) over time and see changes, trends, etc. I believe the other forum post said to create another table and create a field for the total for each location but I can't figure out how to do create that field or link the tables together. The record id is the key for the table that I am trying to summarize and I assume that table would be the child which I think makes this impossible. Once the summary field is created I believe I would need to create an automation to post the summary field each day to another table to create a backlog history table. I hope that makes sense. If not, please let me know what questions you have. Thanks in advance, Ben ------------------------------ Ben Gillihan ------------------------------ Re: Lookup Question Unfortunately, employees often have more than one payroll record per day, so I can't make the key name and date. We aren't storing the whole CC# in QB. Just the last few digits to identify which employee it is. A good point to remember though. Thanks. ------------------------------ Ben Gillihan ------------------------------