ContributionsMost RecentMost LikesSolutionsRe: Sorting TextList in formula Hi Joel Any luck with a solution for this? :) I am facing the exactly same situation.... ------------------------------ Sergio Sanchez ------------------------------ Related already created records to a ParentHello community. I have 2 tables: Campaigns and Contracts. My problem is: The campaign table is the Parent and Contracts is the child. I have already uploaded a lot of contract records, but none of them are related to a Campaign. When I am creating a Campaign, I would like to be able to select a couple of contract records and relate them to the Campaign record that I am creating. So, the question is: what is the easiest approach to achieve that? I mean, should I use an API, an embedded report, buttons, formulas, save and redirect... I am attaching a picture of how my form looks right now. Again, the goal here is to have uploaded childs related to a parent. Thanks and regards, ------------------------------ Sergio Sanchez ------------------------------ Re: Career OpportunityPerfect Brian. I'll let Kevin know. Thanks. ------------------------------ Sergio Sanchez ------------------------------ Career OpportunityHello Community, Kevinis working with a PaaS company that is looking to bring on a QuickBase Developer to their team, this is a full-time remote Direct Hire opportunity. Let him know if you are interested so he can go over the details with you. Best, ------------------------------ Sergio Sanchez ------------------------------ Career OpportunityHello Community, Kevinis working with a PaaS company that is looking to bring on a QuickBase Developer to their team, this is a full-time remote Direct Hire opportunity. Let him know if you are interested so he can go over the details with you. Best, ------------------------------ Sergio Sanchez ------------------------------ Re: URL Button to auto-complete formHello Joshua Absolutely, please modify he following code as your best convenience: ----- var text URL= URLRoot() & "db/" & [your table ID] & "?act=API_EditRecord" & "&apptoken=your app token" & "&_fid_field##=yes" & "&_fid_field##=Approved"; "javascript:" &"$.get('" &$URL &"',function(){" &"location.reload(true);" &"});" ----- Remember to use URL type field, and have it :Display as a button on forms and reports". ------------------------------ Sergio Sanchez ------------------------------ Re: Group and filter by "customized week"Awesome!! thanks everyone for such a quick and great help with this. I really appreciated it. Best regards, ------------------------------ Sergio Sanchez ------------------------------ Re: Group and filter by "customized week"Thaqnks a lot Mark :) Yes, reading them as the screenshot will be ideal. 6 months back will be sufficient for the calculations I am planning. Kind regards, ------------------------------ Sergio Sanchez ------------------------------ Group and filter by "customized week"#Formulaandfunctions #reportsandcharts #Formulasandfunctions Hello I would like to get assistance on how to group and filter records based on particular criteria: workweek from Wednesday to Tuesday. For example, on excel I can do it like this: so as you can see, I can count records if the date is between the range established in excel - from Wed to Tue. Basically the need is to group and count records based on customized date ranges. Each record has it own "Sent to 1st level Review date", I just need the count based on those ranges and then show them in Summary or Table reports. I hope it was clear enough. Thanks in advanced. Regards, ------------------------------ Sergio Sanchez ------------------------------