UchennaOgbejesi
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Edit Record Formula Button
The two tables that I'm using for this button are: Gating and Gating Questionnaires. Gating is used to mitigate risks for projects by having projects stop at different gates to make sure the project is meeting different requirements to move through the gates. The questionnaire is used to fill out whether they have met these requirements essentially. Gating is the parent table and Gating Questionnaires is the child table. One Gate can theoretically create multiple questionnaires, however, I'm restricting the creation of multiple records for each gate. I have two buttons on a report: Complete Questionnaire (works) and Edit Questionnaire (not working). When someone completes a questionnaire, that button disappears and the edit questionnaire button appears. Basically, once a questionnaire has been completed, I'm trying to edit that questionnaire that was completed, but I can't get it to work because the Record ID# of the questionnaire is not on the Gating table to use in the formula button. ------------------------------ Uchenna Ogbejesi ------------------------------3Views0likes2CommentsRe: Edit Record Formula Button
Thank you for this. I tried your formula and I was brought to a Not Found page. I think this is happening because the Record ID# for the child record isn't known on the parent record. Is there a way to get the Record ID# of the child record on the parent record? A summary field comes to mind, but it's not an ideal solution given it's flawed. ------------------------------ Uchenna Ogbejesi ------------------------------6Views0likes4CommentsEdit Record Formula Button
Hello everyone, I hope everyone is staying safe out there. I'm trying to create a formula button to edit an existing record on a different table. When I created the formula initially, it brings me to the form I'm trying to edit, but it looks like a new record and doesn't have any detail of the completed form. The way I'm trying to create this button is using the parent's record ID# and the related Record ID# for the child table to create a "match". Upon thinking about this, I'm not sure if there is a way to link the parent and child records. Does anyone have any ideas about this or has done something similar? Any ideas/help is greatly appreciated. ------------------------------ Uchenna Ogbejesi ------------------------------Solved19Views0likes8CommentsRe: Viewing Multiple Records in One Record
@Mark Shnier (YQC) I'm looking to see if this could be done rather easily for maintainability sake but doesn't seem like it could be. This really is a nice to have. ------------------------------ Uchenna Ogbejesi ------------------------------15Views0likes1CommentRe: Viewing Multiple Records in One Record
Yes, a form within a form I suppose. Is that complicated to do? It does not know the record ID#s of the 5 records, just a related record ID# from a table to table relationship -- the ID of parent table record. ------------------------------ Uchenna Ogbejesi ------------------------------1View0likes2CommentsRe: Viewing Multiple Records in One Record
It is not what I'm envisioning. I'm looking for a view of 5 tabs or the like to pull in data from the different records. Not sure if that makes sense or if it's feasible. ------------------------------ Uchenna Ogbejesi ------------------------------3Views0likes9Comments