April 6, 20178 yr Newbies Sorry I am a novice and I am really hoping someone can help please! I have attached a screen shot We have a timesheet on our database, I need to create another field/script/no idea? My Manager wants it that when a specific task type is entered, another field comes up with keywords that relate to each different task type. For instance: Someone adds Strategy as a task type, another field will open with the options Scope; Estimate; Wireframe Then on the next line they choose Implement as a task type, the other field will then open with the options Technical build; Upload; Layout; Amends; Sign off I can't work out how the field will change dependant on the task type selected, the only way I can do it is that it will bring up all the keywords related to every task type, not the specific ones And I probably haven't made much sense either?
April 6, 20178 yr I think what you are looking for is a conditional value list. If so, there are many examples and sample files available by search.
April 6, 20178 yr Try these two searches using google site: fmforums.com conditional value list site: fmforums.com dynamic value list
Create an account or sign in to comment