I am curious to know if there is any software out there that is able to create dynamic pdf forms like Designer. I know there are a lot of pdf creators but I am curious to know if there is anything that is able to layout forms with all the different field types that Designer does? I am just curious as my employer is asking about what options we have for an upcoming project.
There may be other form design tools out there. It all depends on what you want to do with them. If you want to create Adobe PDF Forms your options are AcroForms - the are Forms that are designed pretty much any way you want to i.e. InDesign, Illustrator, Word etc. You would convert them to PDF then overlay form fields on them. This has been around since the mid 1990's and works well. One benefit is that the form can be displayed on a hand held device such as a smart phone or a tablet. Where there is scripting capability it is still more restrictive. Without knowing what your end goal is I cannot say whether it will meet your needs
The second Adobe option is Adobe LiveCycle Designer. This tool can create a more advanced PDF Form. You can use the tool to design the form from scratch but can also import a form from other applications as a starting point. For this you would still need to convert to PDF first then import. LC Forms are much more robust and can take advantage of much greater capability. You can have Dynamic forms - meaning a form that can add/remove rows and flow from page to page something that Acro Forms cannot do. You can also attach it to back end systems as well as webservices, data etc.
If PDF Forms are not that important to you then there are other options but they would all pretty much require a tool to fill them out for example some people create a form in MS Excel. If your user has Excel they can fill in the form. Same with Word.
One note, I have used LC Designer for years and yes it is not the most perfect tool but for designing intelligent PDF Forms it is the best currently available. I am happy to answer other questions.