ContributionsMost RecentMost LikesSolutionsRe: Copy Record then edit orginalI am also assuming I would have to link the fields to my original record somehow?Re: Copy Record then edit orginalThanks, how would I use API_GenAddForm as I have never used it before. Re: Copy Record then edit orginalNot many, I have 1 date 2 DropDowns 1 Notes 1 checkbox (fid_30) 3 related fields Copy Record then edit orginalI am trying to use a button to copy a record and then change a field in the original. I have typed in exactly the below(apart from the dbid being XXX)into the field formula which is a URL Formula field: URLRoot()&"db/XXX?a=GenCopyRecord&rid="&[Record ID#] &"&_fid_30=1" The button will copy the record fine but wont set the checkbox in field 30 to be checked? Any ideas? Find gaps in datesI have an issue where we book out our consultants using dates and want to find the gaps/soonest availability. Each booking is either a day or half day. The half day is just done as checkbox and brings out the value 1 or 0.5 accordingly and booking 1.5 days is possible. I do currently have a calendar colour coded to show this, but would love some kind of report to say something along the lines of: In the next 3 months, Consultant A is next available on the dd/mm/yy for 5 days In the next 3 months, Consultant B is not available In the next 3 months, Consultant C is next available on the dd/mm/yy for 0.5 days Even better would be if there is a way we could say that 3 days are required, it would read: In the next 3 months, Consultant A is next available on the dd/mm/yy In the next 3 months, Consultant B is not available In the next 3 months, Consultant C is next available on the dd/mm/yy (+24 days for example to the above as the 0.5 days above would not suffice so would find the next gap in their diary) In essence the dream solution would look at the days required and just say the soonest time each consultant could do it. We have normal working weeks Mon-Fri, and would like it to run using these days alone. Many thanks