Matthew Luck
-
Export Import File
Hi, I need to produce a file that has references to the same record but on multiple lines. It is for an import file into our web software. The file is:…
-
Find repeating characters in a string
Hi, I want to find the index of a string segment in a string, say ther 3rd comma in a list oif comma seperated values. I want to create a string that will return eveything up to that index value. i.e.…
-
Use Update Trigger to Chnage the value in Linked Record
Hi, I hope you can help. I want to change the value on a linked table field Features.'Features (English)' to the value "Disposable". It is driven by a change in a field on the Products table with…
-
Check Code syntax
Hi, Does this code look OK? Basically it checks if the code exists, compares two prices and update a field with the lowest, for all products in the system.…
-
Update Field in another table after update
Hi, I am trying to update a 2nd table with a new record and add the SKU field from the first table. Table 1 (Products) has a table reference to Table 2 (Stock Take Tracker).…
-
Can you use Zapier to update a field in Nixox from a csv in dropbox?
Hi, I can export a csv to dropbox every hour. The file will contain the SKU (or Ninox ID if I need it) and a number. I want to pull this number into a Ninox field (overriting the existing value).…
-
Linking a Table by a Field
Hi, I have two tables, one is Products and the other is attributes. There is a 1:N Product to many attributes relationship. I have created a table refence on the Product table to the attributes table.…
-
File Name Pattern of Image Import
Hi, I want to import product images to Ninox. The file pattern is URL/SKUa.jpg. When I create the image file I add a letter a,b,c,d etc to the end of the image SKU, but before the file extenstion (.…
-
Find Highest Letter (a being the lowest) from table
Hi, I have a product code ABC followed by a single letter a,b,c. A product can be: ABCa ABCb ABCc If there is a 'b; ending there must be an 'a' as well etc.…
-
Calculate Sell from Margin %
Hi, This is one for the mathmaticians out there. Sell £100 Purchase Cost £50 Selling fee (i.e.Amazon) of 15% of £100 = £15 Margin = (100 - (50+15))/100 or ((sell-cost)/sell) The question is,…