AnsweredAssumed Answered

Conditional or dynamic value list?

Question asked by bburdeen on May 27, 2015
Latest reply on Jun 27, 2016 by ucharles

Title

Conditional or dynamic value list?

Post

Still new to FMP... Not sure if I'm looking for a conditional value list or a dynamic value list or maybe something completely different.

How can I create a dynamic dropdown list that shows numbers 1 to 133 and updates with each new record, not showing the numbers that were previously used.

Example:
User1 adds a new record. With this record User1 enters miscellaneous information and then selects number 5 from a dropdown list. Done.

User2 adds a new record. With this record User2 enters miscellaneous information and then selects number 4 or 6 since number 5 was previously selected by User1 it is not even available from the dropdown list.

Outcomes