0

Limited to One form per table?

I can't see a way of creating multiple forms from the same table.

I also found an posting in this form that stated that each table has only one form.

So is that in fact the case that I cannot create multiple forms from the same table?

As an example of what I want to do: I'm creating a photo/negative catalog. While I have one table with all the fields related to a particular photo or negative and where they are stored. I had assumed that from the one table I could create A form where details of the photo could be entered and another form where I could enter details of the storage location. Is that not possible?

Would I have to create separate tables to accomplish my goal, say one for photo details and one for storage location details?

 

Thanks

6 replies

null
    • Sean
    • 3 yrs ago
    • Reported - view

    You might want to try the Tab layout element. The main problem with it is you can't use a field on more than one tab.

    • Dorich
    • 3 yrs ago
    • Reported - view

    Thanks. That's helpful. But as you point out its limited.

    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    You can use a choice field instead of tabs. This will allow you to control the visibility of each element on the form based on the item selected from the choice field, so you can use fields more than once.

     

    Try creating a choice field named "Show Form" with the "Show As" property set to "Switch". Add a choice value for each form name.

     

    Then set each form element's "Display field only, if" property to :

    contains(text('Show Form'), "Form 1")

    if you want it to be visible (substituting appropriate form name in place of "Form 1"), or to

    null

    f you want it to be hidden.

    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    Also, note that in print preview mode you can create multiple form layout for printing, by adding tabs.

    • Dorich
    • 3 yrs ago
    • Reported - view

    @ Choice Software

    Thanks. That's a really interesting solution I would never have thought of.

    • Michael_Chung
    • 1 yr ago
    • Reported - view

    Choices Software - Dean Westover

    Thanks for this. I used it in a dashboard form view and now I can carry out 99% of my needs on one form. 

    From an end user point of view, it worked like a dream. My only complaint is from a developer point of view. Having to add the script to every field and element is a pain.

    It would be fantastic if Ninox added a Header element where you could place fields and would sit above the tabs or a check box in the field setting that would "Show in all tabs".

     

    Once again, thanks for a great workaround. 

Login to reply

Content aside

  • 1 yr agoLast active
  • 6Replies
  • 858Views
  • 1 Following