ContributionsMost RecentMost LikesSolutionsRe: How to update a default (canned) report with a custom field?The custom field also needs to have the property checked that says - include this field when searching/filtering this table. This should then allow you to use as a filter in any report. Re: Formula Support-Duration # of days in a monthKatie, For this you will need the field that has the month you are calculating. For example : if someone stayed for 3 months from 15th Jan to 20 April, there are different number of days that person has stayed in each month. If you just need to know January (first month from the date admitted) that is fairly simple. Just use the following formula : ToDays(Min(LastDayOfMonth(Date(Year([BTC Admission Date]),Month([BTC Admission Date]),1)),[BTC Discharge Date]) - [BTC Admission Date])Re: How to extract month and year from date, then use them in a relationshipCreate a new formula text field. Here is the code below Case(Month(ToDate([Date Created])), 1,"January", 2,"February", 3,"March", 4,"April", 5,"May", 6,"June", 7,"July", 8,"August", 9,"September", 10,"October", 11,"November", 12,"December", "") This will create the month based on the date created. I think the issue you are having is that date created is a date/time field and not a date field. You need to do a typeconversion first using ToDate.Re: Is it possible to customize the file name when exporting a report from a table?I dontthink you can do it natively, but it is definitely feasible using a workatorecipe. In fact if you are using a cloud service it will upload the csvfile into the specific destination as well. SO essentially you will trigger a webhook using a button that calls a workato recipe. It creates a csvfile based on the query and uploads the resulting csvfile to your designated location.Re: Disadvantages of a non number key fieldAs long as the key field uniquely represents a record and its child records have that key field value to be able to relate it, you should be fine. Is the key field system generated or provided by the user ?Re: Is there a way to return from child table back to the parent parent record?There are two ways you can handle the returning to the correct parent form. One is encoding the correct dfid in the URL like Matthew suggested. It would be a formula url like : URLRoot() & "db/ABC123456?a=er&dfid=12_fid_9=" & URLEncode ([Related Parent Record ID#]]) ABC123456 = parent table dbid This formula will only take you to the specific form (form id 12). You can use some logic to dynamically change the form id it goes back to or use multiple buttons which take you to the different forms. This formula field will be in the child table second way is - to encode"&z=" & Rurl() at the end of your add child record formula URL in the parent table. the z=rurl() will return to the prior page (be it a form or a report). That means once the user is done adding the child record he/she will return to the original form/page they started with. An example would be URLRoot() & "db/DEF123456?a=API_GenAddRecordForm&_fid_9=" & URLEncode ([Parent Record ID#])& "&z=" & Rurl() the DEF123456 = child table dbid.Re: How to mass update one field in an existing tableJay, I dont think there exists a setting like that. Quickbase by default will update records if the key field exists. You may want to check if there are leading or trailing spaces in your csv data. use the excel formula Trim(cell number) on the serial number field and try to reimport. I've had that issue of leading/trailing spaces. Second thing I can suggest is using google drive / box or dropfox folder and placing that CSV in that folder. Create a connected table and then do a lookup to your destination table. setup your csv connected table to refresh everyday (sometime after you place the new CSV file) and it will keep it connected. The sync to CSV is very effective and thorough.Re: How to mass update one field in an existing tableLike Matthew suggested, you need to set that field ("Serial Number") as the key field. Other option is to map the record ID with Serial number and import using the record ID .Re: Creating a duration upon saveIt is possible that somone may have rename the Record ID field . Just look at the fields in the table and see what the key field is. It will have a yellow key made next to it.