Chapel of Praise
-
Join on non-key field to update records
2nd try. I can't figure this out, but I think it should be simple. ITEM Import Table: Item ID, Available quantity, Import Timestamp. Target Table: Item: Item ID (not Ninxo ID but parent system id.…
-
Update Field to Show Item Balance from Import
I would appreciate coaching on this update, as I can't seem to make it work. Each planning period I get a csv file that has ITEM ID and ITEM Available Quantity.…
-
Is there a syntax for 'select distinct'?
If I have rows of transaction date and I want to extract distinct (each member 1 time) list from a column, is there a "select distinct" syntax like there is in SQL?
-
Select statement behaviors...
I am working to piece together my understanding of the SELECT statement in Ninox. REQUEST 1: Does anyone have a few examples where they use the 'Join()' command? I'd like a few working examples.…
-
Parent - Child Record Update Example. Code Help to Complete Needed.
I hope this will be enlightening for others, in addition, to help to me. Thank you in advance. I appreciate the help I’ve received. Nonetheless, I am working in circles.…
-
Creating a dependent Child record. Use of 'this' statement.
I would like to create children records when there is a status change in the parent. I can get everything to populate but the foreign key of the parent. Volunteer --> Timesheet.…