Hi Hardy - Glad the button is working. What Mel suggest is still two steps away, I am breaking down the steps so you can understand what is going on. Plus it is always a good to test scripts like this in a button that you can control before applying it. The next step is to add an if statement before the code so it will only create a new record when 'Received By' = 1 or 2 or 3. We will stay with th
I believe Fred had some more thoughts for what we're currently working on, but I'm just curious. Would I need to put each script in the respective field under trigger after update? How would the code look for the if 'received by'=1,2,or 3 look?
Hardy Depending on what the field (Receive by) is - ie text field I would have though you could test for the script to run on trigger after update on that field. so instead of having the code in button you put it in that field and pre test it to say if 'required by' = 1 etc then run the script!
I corrected my code and made sure my fields were exactly the same and it is working now. Will the button need to be pressed every time a new record is created to have it copy to "Received" or is there a way to automate that? Thank you so much for your help
Migrate pst to office 365 using the two most suitable approaches securely. You will get here manual Azure AzCopy method step by step. Furthermore, PST converter software is provided here to import PST to Office 365 without taking too much time. Its demo version offers 50 emails conversion for free in Office 365 and also selected format. Visit Here: https://www.techietruck.com/migrate-pst-to-office
Hallo zusammen, ich habe eine - hoffentlich - einfache Frage. Ich erstelle eine Print-Darstellung, die den Status der erteilen Aufträge und dazu erhaltenen Lieferungen zu einem Projekt auflistet.Die Auflistung der Aufträge (Spalte 1) und eingegangenen Rechnungen (Spalte 2) funktioniert auch soweit. Allerdings passt die Reihenfolge der Zeilen nicht mehr, sobald zu einem Auftrag noch keine Rechnung
I might want to recommend outsider programming to change Zimbra over to PST utilizing Vartika Zimbra Converter. The product upholds various document organizations like PST, EML, EMLX, HTML, PDF, NSF, and OLM and so forth this product additionally upholds email servers, for example, Office 365 and Exchange Server account and so on the product permits the client to change over Zimbra mail things lik
what you wrote should work. i noticed that there is a space after "newReceived.". There shouldn't be any spaces. let curRec := this;let newReceived := (create Received);newReceived.('Ordered by' := curRec.'Ordered by'); When you type newReceived. then start typing the name of the field does it bring up the field name for you to select?
Yes I have the same fields on the Received table. What would be the correct way to code that to have the data copy over to the Received table when we input in the Orders table?
Just wondering, did you create the same field and field names in the Received table? The second post code doesn't work cause you have a semicolon after newReceived thus ending the line. What you wrote is telling Ninox to take the data in Paid and copy it to same Paid field.
I have made some progress. I currently have the following code: let curRec := this;let newReceived := (create Received);newReceived;'Ordered by' := curRec.'Ordered by';newReceived;'Ordered on' := curRec.'Ordered on';newReceived;Vendor := curRec.Vendor;newReceived;'Order type' := curRec.'Order type';newReceived;'Ordered late' := curRec.'Ordered late';newReceived;'Received by' := curRec.'Received by
Update: I found the button option under layout, however when I am inputting the code in does not recognize my field names. For example: let curRec := this;let newReceived := (create Received);newReceived. ('Ordered by' := curRec.'Ordered by'); This is what I have so far and it is saying field not found
Hi Hardy - A button is a "layout element". If you go to Edit Fields you will see on the right side Add layout element. From there you can add a button. When you double click on the button field you will then add code to the On click section of the button.
Thanks for responding. I am fairly new with Ninox, and I'm not sure exactly where I need to put the code above. What sort of button are you referring to?
Hi, Thanks again.I am an experienced VBA programmer and maybe I think too much in that direction.I can create a query in VBA with several linked tables and I can select several fields from each table. I can also save this query for later use.Now when I do a Datasheet view (View) of this query, I get a table with all the fields selected in the query. Regards Michel
There is no "Move" command so you will have to hard code the copying of data field by field from the Orders table to the Received table. There will also be many steps to get to your desired results so let us take it one step at a time. First make sure you are in a DB that you can mess with as you will be testing out creation of records and deletion of records. To test the creation of a new record
Do you want this 3rd table to be a "dashboard" that you can use view info from other tables? You can view this video for the basics on how to create a dashboard: https://www.youtube.com/watch?v=nUqGl84gh08 If you don't want a dashboard, then what is the purpose of the 3rd table? What kind of data are you wanting to track in this new table?
I am trying to "hide" records in my main table (Orders) by having them move to sub table (Received) when the field (Received by)= 1, 2, or 3. I am not sure how to write the code correctly to get it to do what I want.
In a "select" statement, the square brackets may always be used instead of a "where" clause. But there is more: they can also be used to filter related records, or to filter the elements of any array containing handles to a set of records. The "unique()" function must receive an array as its argument, but the element of the array may be of any type - well, I did not test it with all the possible t
Sean - now I got it- and it works perfectly. I'm building my own Ninox-manual as I go along in Notion (since Ninox seems to change code snippets) - and many times I've wondered why all the "gold" of this forum isn't being gathered to, and published in, the documentation.... Anyway - thanks a lot 🙏 Mel - it seems we've been walking the same path - and have come to the same conclusion,,, functional