ContributionsMost RecentMost LikesSolutionsRe: Creating a list based on another field Thanks Matthew. Yea,we didn't like this entry method due to the fact that you could add "Resources" in the Project Assignment as many times as you wanted. The data at the end of the day wasn't accurate. When you look to see how many projects X worked on for the month, that number would be completely off because she may have been entered in multiple times. Not to mention the additional headache of having to clean up child records when parent records were deleted. Re: Creating a list based on another fieldDo you mean if Project Manager is always listed as project manager on specific tasks? If so, no, they aren�t consistent. Project Managers can sometimes play the role of Writer and Writer can also play the role of Project Manager.Creating a list based on another fieldI have been trying to achieve this for years and we?ve done a few things to work around the issue. I have a team of people I want to dedicate to a project. I then want only that list of people to be selected within the tasks. I created a List-User field then created another field converting the list user to text. This gives me all the people selected on one line separated by semicolons. When I then go to create a multi select field based off the text field I only get one checkbox with all the people selected from the List-User field on one line. I feel like I?m so close. Is there a way to convert the text field into a list? Would the multi select field pick that up? I really wish this would be a part of one of the updates. It seems like something pretty basic for a project management app. We?ve tried the team member table connected to the project table. I found this very clunky. It had its flaw were you could add the same person as many times as you wanted to a project. At the moment we have about 9 different List-User fields labeled Project Manager, Designer 1, Designer 2, Website, etc. then on the task have a multi select list with all those roles. This works for us right now, but I also find this to be very clunky. Any help? Re: URL Formula Button Refresh current page not RedirectThat worked perfectly! Thank you so much!Re: URL Formula Button Refresh current page not RedirectSorry. I really just want each time a person clicks to change the status button that the page refresh and stay on the same page. Can I still use this code? If so, how would I use it?Re: URL Formula Button Refresh current page not RedirectI have an if statements set up, like the following, how would I apply this java to this? If([Status]="Ready to Start", URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#] & "&apptoken=b2ef6ijciijsibdf9dftgdjtdhm3" & "&_fid_15="&URLEncode("In Progress") & "&_fid_284="&URLEncode(Today()) & "&rdr=" & URLEncode(URLRoot() & "db/bkpvkgvbb"), [Status]="In Progress", URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#] & "&apptoken=b2ef6ijciijsibdf9dftgdjtdhm3" & "&_fid_15="&URLEncode("Completed") & "&_fid_285="&URLEncode(Today()) & "&rdr=" & URLEncode(URLRoot() & "db/bkpvkgvbb") & "&_fid_29="&URLEncode(Today()), null)Re: URL Formula Button Refresh current page not RedirectHi, Can you explain how I would set this up with a status change button?