ContributionsMost RecentMost LikesSolutionsRe: Do you want to start a local QB builder community?Vancouver, BC anyone? ------------------------------ Gary McDonald ------------------------------ Re: Assigning User based on # of assigned recordsThis is great thank you. I ended up figuring out a solution but it was not as elegant as this...I ended up with an extra table that I didn't need using a Max record ID summary on the one record to get the User into the table...but then did the automation just like you showed above...seems to be working great. Thanks again for your help. ------------------------------ Gary McDonald ------------------------------ Re: Assigning User based on # of assigned recordsFor sake of this argument and to make it as easy as possible lets say I add a new record one at a time. ------------------------------ Gary McDonald ------------------------------ Re: Assigning User based on # of assigned recordsThere are 19 Users in the Table but only 7 of them are adjusters being assigned to claims. The key field in that table is User ( it is a User field ) ------------------------------ Gary McDonald ------------------------------ Assigning User based on # of assigned recordsI have a table of Records ( Claims ) that I have been assigning a User to from a User table that tracks the number of records each User has assigned to them. I want to automatically assign the user who has the least number of records to the next record I create in the Claims table. For Example Mike 74 claims Tom 73 claims Mary 67 claims Jane 87 claims The next record I create in the claims table I would like to assign Mary. Any thoughts or suggestions on doing this? Thanks in advance. ------------------------------ Gary McDonald ------------------------------ Re: Is it possible to create a ""Save and Keep Working"" button from a formula URL field?Ok...that's embarrassing. I forgot the form setup does not automatically default to Save and Keep Working. That has to be done before trying this awesome formula out. Very sorry for wasting your time...thanks again.Re: Is it possible to create a ""Save and Keep Working"" button from a formula URL field?Ok thanks. I tried to add a New field in a completely different application and paste it in there...and it doesn't work there either. I'll putter around and see what I can come up with...I'll let you know if it gets solved.Re: Is it possible to create a ""Save and Keep Working"" button from a formula URL field?I removed the space before Onclick as well...it still does not work.Re: Is it possible to create a ""Save and Keep Working"" button from a formula URL field? Re: Is it possible to create a ""Save and Keep Working"" button from a formula URL field?The Formula is as follows "<b><font color=Red><font size=6><div style='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>>>[Values have Changed. Click Here to Update!]<<</div>" This works in one application and not the other. I copied the formula from the application that does NOT work into a new field I created in the table of the Application where the formula does work and added that field to the Main Form...it works perfectly there. So I have two fields now where it works in one application and I can't get it to Save and keep working in the other application? The Applications are set up exactly the same way from everything I can see?