0

An easy? help request

Hello,

I am quite new to Ninox and am trying to create a fairly simple database.  I will simplify it even further for this question.  I have xxx tables

 Table                                 Field(s)/datatype

Companies                       CompanyName (text field)

People                               Name (text field)

Bills                                    Payee (dynamic multiple choice from Companies)

                                            Payer (dynamic multiple choice from People Table 

                                            Amount (number)

                                            Date (date)

 

What I would like then create is a form that has another dynamic multiple choice PaidTo that is also from the Companies Table.  Then I would like a view that shows all of the records in Bills the Payee is in the PaidTo dmc.  Is there an easy way to do this?

 

thanks

9 replies

null
    • Fred
    • 2 days ago
    • Reported - view

    I would not recommend using dynamic choice fields to store data because of this issue.

    I've attached a sample DB. I use dynamic fields and buttons to update child tables that store the data. When Payee and Payer are empty then the Add button shows up. Otherwise you see the Update button.

    Now you can go to a company record and see all the bills that are linked to it. The same for People.

    When you are ready for dashboards, then we can move the dynamic fields and buttons to the dashboard so you don't have to store dynamic field data in your records in bills.

    forSkylinev1.ninox
      • skyline_verge_8d
      • yesterday
      • Reported - view

      .  Thank you so much.  I really appreciate the care you took with this.  The world needs more such people!

      • Rafael Sanchis
      • Rafael_Sanchis
      • yesterday
      • Reported - view

       Hi Fred.

      I download your example. Overlap the both Muliple Choice dyn.

      You have this Problem. On Chrome and Phblic Clound. N o problem on Android tablet

      • Fred
      • yesterday
      • Reported - view

      don't know what to say. Looks like a Ninox issue as there is nothing special in there. I wrote it in public cloud.

      here is how it looks in Edge in Public cloud.

      • Fred
      • yesterday
      • Reported - view

      When you get a chance please mark the post answered.

      • Rafael Sanchis
      • Rafael_Sanchis
      • yesterday
      • Reported - view

      Thanks Fred yes in Edge works, but in Chrome and FireFox don't work overlap de checboxes.

      • Fred
      • yesterday
      • Reported - view

      this is what is looks like for me in Firefox in Windows and Mac:

      The same as Edge for Windows.

      • Rafael Sanchis
      • Rafael_Sanchis
      • yesterday
      • Reported - view

       Thanks again Fred, In Android Tablet look good too, It only looks bad in Windows Chrome.

      The Multiple Choice dyn overlaps the two fields. 

      • Fred
      • yesterday
      • Reported - view

      Here it is for me in Chrome in Windows:

      Looks like this in the Zen browser as well in Windows.

      Looks the same for me regardless of browser.

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • yesterdayLast active
  • 9Replies
  • 37Views
  • 3 Following