ContributionsMost RecentMost LikesSolutionsRe: Table relationship with a formula field in child table That's not a problem. Already configured and the app is looking pretty cool and slick. Thanks Mark! ------------------------------ Deepa Prashant ------------------------------ Re: Table relationship with a formula field in child table Duh! I must have been tired last night. That's such a simple solution. Thanks Mark! ------------------------------ Deepa Prashant ------------------------------ Re: Table relationship with a formula field in child table Hi Mark, What you suggested is working beautifully but now I need a creative solution for confirming if each line in this embedded report that you helped me design above has a checkmark against a column called "Ready for processing." This checkbox field triggers a set of rules in the table and ensures that required fields are filled in etc. So I need each line in this embedded report to have a checkbox before they can continue to process the report and send it for approvals. Any ideas of how I may achieve that? So in the record above - Asset Capitalization request #27 has a number of assets that need to be capitalized - shown in the report to the right. You can see that I was playing with Line # and counting the number of checkboxes with "True" for "Ready for processing." "Ready for approvals" in the 2nd section in the form should be editable only if each line in the report has "Ready for processing" checked. how do i confirm that? Thanks!! deepa ------------------------------ Deepa Prashant ------------------------------ Re: Table relationship with a formula field in child table Mark, This was perfect!! Love it. Thanks! ------------------------------ Deepa Prashant ------------------------------ Re: Table relationship with a formula field in child table Hi Mark, I tried what you suggested, but until I save the Asset Request form and a record ID is created for the Asset Request, the asset form details in the legacy Grid Edit report do not get attached to the newly created Asset Request form Record ID#. It appears I have to first save the Asset form request and then pull up the grid edit asset forms and fill in the details for it to get attached to the asset request form. I can't create the Asset request form and add the asset details in one go. Am I missing anything? ------------------------------ Deepa Prashant ------------------------------ Re: API_edit record not updating records if there is no change Hi Chayce, No all my fields are strings in the table that works. However, your solution of adding the modified date was a neat work around and is working as expected. Thanks! ------------------------------ Deepa Prashant ------------------------------ Re: Table relationship with a formula field in child table Got it. Thanks! ------------------------------ Deepa Prashant ------------------------------ Re: Table relationship with a formula field in child table Jus re-reading Mark's solution. Wow! You do think outside the box Mark. Having a form within a form, that's brilliant! ------------------------------ Deepa Prashant ------------------------------ Re: Table relationship with a formula field in child table Thank you so much Mark and Chayce for your suggestions. For now, I decided to take a simpler rule and added a few lines of instructions and will have the analysts first create the Asset Request form (save it) and then add the records via Grid Edit in Asset forms with Related Asset Request a required field. I decided to keep the new form as I do like the layout with the Grid edit report showing to the right in the Asset Request form. Thank you so much for your help! ------------------------------ Deepa Prashant ------------------------------ Re: Table relationship with a formula field in child table Thanks Chayce. I am using the new form and that does make things more time consuming for me as I am still figuring my way around those. It does allow Grid edits for embedded reports. But doesn't appear to automatically link the Asset Form Request record to the new asset forms via Grid Edit. I need to have to use the drop down in the Asset forms Grid Edit and select the Related Asset form and then the report shows up correctly. Also now my app has both legacy forms and new forms making it inconsistent. Any way of switching back to legacy? ------------------------------ Deepa Prashant ------------------------------