0

pick records one-by-one

Hi,
I try to build a rental database. I would like to pick some records (rentable items) one by one from a table to another table where the dates (appointment), the contact and the price (sum) are presented. Is it possible to do this in Ninox without coding?
Thanks in advance.
Peter

5 replies

null
    • totalenglishlugo
    • 4 yrs ago
    • Reported - view

    Hi Molnar,
    I have some questions for you:
    Do You have some experience with databases?
    Do You have some programing knowlodges?
    You need first study your project needs, do you made it?

    For example for a simple project you need to cretate somes tables

    Assets (to rent if the asset is disponible or not....)

    Customers (with the needs customer form fields)

    Rent (the customer that rent a Asset and the calculations for generated invoices)

    But you need to watch a lot of things, user permisions, print a invoice and more a control pannel.

    If your project is small is possible, but if you need to do calculations really you need 

    code some things.

    • Alejako
    • 4 yrs ago
    • Reported - view

    Hi Molnar,

    I back to paste the answer from my user. I am watching from another Ninox account
    I have some questions for you:
    Do You have some experience with databases?
    Do You have some programing knowlodges?
    You need first study your project needs, do you made it?

    For example for a simple project you need to cretate somes tables

    Assets (to rent if the asset is disponible or not....)

    Customers (with the needs customer form fields)

    Rent (the customer that rent a Asset and the calculations for generated invoices)

    But you need to watch a lot of things, user permisions, print a invoice and more a control pannel.

    If your project is small is possible, but if you need to do calculations really you need 

    code some things.

    • molnarpeter
    • 4 yrs ago
    • Reported - view

    Hi Alejako,
    thank you for your feedback.
    I don't have much experience with databases, but have some basic programming, scripting skills.
    The project would be very simple: I have a table with the rental items (category, name, accessories, net. price, vat calculations, etc.) and there is a rental table (basically an event) where the personal information (name, address, pickup-date, return-date, id scan, signature) are. I would like to add records here from the items table one by one per rental event.
    Now I have some success by making a Sub-table to the rental table and connecting it to the items table, but I thought there must be a better way.
    I couldn't find a way to drive a Multiple choice field by a table. Maybe this could do the job for me, but if I understand that correctly this is an upcoming feature.
    All the calculations are working now including the daily rate, discounts, and total cost.

    • Alejako
    • 4 yrs ago
    • Reported - view

    Hi Molnar,

    If I understood your need when a customer rent some thing is possible the customer will want rent 2 or 3 or more items, from this you need to link a  table N to 1. Do your think this maybe your problem?

    • molnarpeter
    • 4 yrs ago
    • Reported - view

    Yes, that's correct. I will check my linking tomorrow. Thanks!

Login to reply

Content aside

  • 4 yrs agoLast active
  • 5Replies
  • 812Views