lewisandrea Posted December 9, 2019 Share Posted December 9, 2019 Hi! I'm new to the forum and I don't know if this is the right place, if I'm not sorry. I am developing a database for a project in my school subject and I can't finish could they help me? The teacher asked us to create a formula so that following the SSN criteria and randomly and automatically the filemaker gave this number. The example he gave was as follows: When creating a new record student A automatically received the following SSN: ###-##-1234 which according to the same criteria is valid, repeating the same step student B automatically received the following SSN: ##-##-1235 which according to the criteria is the same. Link to comment Share on other sites More sharing options...
Ocean West Posted December 9, 2019 Share Posted December 9, 2019 it is unclear what you are asking. Link to comment Share on other sites More sharing options...
lewisandrea Posted December 9, 2019 Author Share Posted December 9, 2019 (edited) Basicamente, é criar um gerador SSN no criador de arquivos, mas atendendo aos critérios definidos pelo SSA Whenever we create a new record it automatically enters the number generated in the field. Edited December 9, 2019 by lewisandrea Link to comment Share on other sites More sharing options...
Ocean West Posted December 9, 2019 Share Posted December 9, 2019 I think you are requesting that the data entered be formatted to match ###-##-#### https://www.briandunning.com/cf/872 Format.fmp12 Link to comment Share on other sites More sharing options...
Fitch Posted December 9, 2019 Share Posted December 9, 2019 Welcome to the forums. Starting with the basics: are you asking where to set auto-entry options? That would be under File > Manage > Database, then choose a field, click Options..., click the Auto-Enter tab, and then either use the "Serial number" option, or if you need something more complicated, use "Calculated value." I suspect that you want to do something complicated like roll over the three groups of digits independently but it's not clear from your question. You haven't told us exactly what you mean by "criteria." If you literally mean use the hashtag character followed by a 4-digit number that increments, you could just use the Serial number option. It can include an arbitrary text prefix. PS: the field should be a text field, not a number field. Link to comment Share on other sites More sharing options...
lewisandrea Posted December 10, 2019 Author Share Posted December 10, 2019 Hi Such a thing only in filemaker https://theonegenerator.com/generators/documents/ssn-generator/ When creating a new record he gives the SSN automatically and randomly. Thanks for the help Link to comment Share on other sites More sharing options...
Fitch Posted December 10, 2019 Share Posted December 10, 2019 That site looks shady. I'm locking this discussion. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1592 days old. Please don't post here. Open a new topic instead.