ContributionsMost RecentMost LikesSolutionsAny Horizon Scanning Type Apps in the Exchange/Library of App Hi Everyone, I am in Regulatory Affairs and looking to build an app to manage horizon scanning of regulatory issues where graphs would be displayed based on the inputs from Regulatory experts. Anyone know if there are templates I can use? ------------------------------ Shelly Ann Aiken ------------------------------ Re: How To Create Groups of Usercan you advise on how to do that? So for example one of my user fields has the type (List - User) because there can be more than one contact for a supplier. I want only those in Supplier roles to be listed as options in the drop down. I do not see anything for picker in the field properties to do this. ------------------------------ Shelly Ann Aiken ------------------------------ How To Create Groups of UserHi. I need to create different user groups such as Supplier, R&D, Regulatory, etc so that when i add a user field to the form, its not just a drop down of all 100s of users in the app. Can anyone guide me where to start? ------------------------------ Shelly Ann Aiken ------------------------------ Re: Need Help creating a formula button to check a box then return to table home pageThank you. I will find a more relevant placement. i was just hoping it could be next to Save button. But its okay. at least it works :) ------------------------------ Shelly Ann Aiken ------------------------------ Re: Need Help creating a formula button to check a box then return to table home pageOne more thing, is there a way to move this button to where the Save &close QB built-in button is? ------------------------------ Shelly Ann Aiken ------------------------------ Re: Need Help creating a formula button to check a box then return to table home pageMike & Mark, you were both right. i had the fieldIDs mixed up. 529 is the ID for the button and 530 is for the checkbox. I made the change and its now working. Thanks a lot. I am teaching myself so you will see me on here a lot within the next 2 weeks. you guys are so helpful. Thanks. ------------------------------ Shelly Ann Aiken ------------------------------ Re: Need Help creating a formula button to check a box then return to table home page529 is the correct field ID. But it's not being checked and saved before the form closes - by clicking the formula button ------------------------------ Shelly Ann Aiken ------------------------------ Re: Need Help creating a formula button to check a box then return to table home pageHi Mike, now it run with no error. However it did not check the checkbox on the form before saving and going back to table home page. what am i missing? ------------------------------ Shelly Ann Aiken ------------------------------ Re: Need Help creating a formula button to check a box then return to table home pageI am still getting error. I am still new to this. 529 is the field ID for checkbox field Error: There are extra characters beyond the end of the formula. URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=cd9d9ctqt3qb2jdr7mybtrmbsf" & "&_fid_59=1" & "&_fid=529" //this is the checkbox field "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=td") ------------------------------ Shelly Ann Aiken ------------------------------ Need Help creating a formula button to check a box then return to table home pageHi, I am new to this. How do i create a button on a form called Archive so that when pressed, it will check a hidden archive checkbox then return to table home page. ------------------------------ Shelly Ann Aiken ------------------------------