0

Control panel data check

Hi there. Not a coding question as such. has mentioned using control panels to enter data into the database which I am researching. I have watched the Nioxus videos on this and can see that it looks like a great way of simplifying the UX. 

is there a way to do data checking of this data prior to it being entered into the system?  2 thoughts I have:

1.). A client makes an enquiry. Currently that is entered into the Clien table. Then the client is select and put into the relevant charter. If I were to move this to a single page input could I see if the client is already in the database?

2.). We have skippers who drive our boats. They are put into the charter details at time of booking. Am I able to see if they are in fact available for this charter from the Control Panel entry?

Thanks for all the help you guys are giving me. It is so appreciated

3 replies

null
    • Fred
    • 5 mths ago
    • Reported - view

    For a dashboard/page to work as data entry you need to have a button. In the code for the button you will put in checks to see if records or other data already exist.

    For the client, one way is to create a dynamic choice field to client table and then the user can search and if they don't see the user then they can click on a New Client button and the proper fields will show up and they can add the client. You still probably want to add data checks to the Add New Client button in case the user was not paying attention during the search.

    For the skippers, I'm not sure what you want exactly, but on their page can show anything you want.

    • John_Wilmans
    • 5 mths ago
    • Reported - view

    Thanks Fred. This is along the lines of what I was thinking. Thanks for your help mate.

    • Mel_Charles
    • 5 mths ago
    • Reported - view

    John

    Here is a very simple way to check if an account (client) already exists.

    in the case it is just sitting in a formula field in in the example below it tests CustID field. However this can easily be adapted to text aginast a cutosmer name field etc and referenced to Tablename.Field from a dashboard (or the new PAGES)

    let a := upper(Custid);
    if cnt((select Customers)[upper(Custid) = a]) > 1 then
        styled("A/c Code is in use !", "red")
    end

    First record already exists

    When trying to add next record with same Custid detail

Login to reply

Content aside

  • Status Answered
  • 5 mths agoLast active
  • 3Replies
  • 49Views
  • 3 Following