Technical Help / "Display field only, if" with multiple choice
Hi! I need to show field if some options of multi choice was chosen (one or two or even three) I tried to use chosen function: chosen('multi choice field') => ["Option 1", "Option 2"] but it actually doesn't work even with one option Here how I use script: The function "Display field only, if" works with this script and multi options starts to work in this script, but... But, there are no logic of
Technical Help / How can return a value with a own function?ä
I apologize! I just now took another look at your function, but this time it is on my computer and not my phone. I didn't realize those were comments until just now. I have a question. In this section... "De 13h30 à 18h00";if heureEnMinutes > 810 and heureEnMinutes <= 1080 then myReturnHtmlBarreHeures := myReturnHtmlBarreHeures + "<span class=" + "'apresmidi'" + " style=" + "grid-column-start: " +
Technical Help / Create table with static column?
is a record within the workflow. If we need to order parts, then this currently enables us to link it both to the customer, and view it in the purchase order table directly. Recently, we have started taking on inspections for insurance companies. We need to generate the report for each customer job as previously explained, and then if the insurer authorises the repair or replacement part, have a
Technical Help / How do I input a csv table list into a multiple choice values table? I have a 100 choices and I don't want to type them all out.
"drdlayton": I think you mean a multiple choice FIELD, because, as far as I know, there is no such thing as a multiple choice "table". (If I'm wrong about that, please tell me. I want to know.) Like "S Moore" above, I don't think it is possible. On multiple choice dialog I don't see any way to import: Many, many questions here asking for help to import odd data sets into Ninox. My solution -- and
Technical Help / Create new database based on existing, or clear data from database
Whether your trial runs out has nothing to do with the problem :-) What you want is - correct me if I'm wrong - to duplicate your database in a way that all print-layouts, tables, fields, views, relations, formular etc are retained - but there a no records in this dublicate. - You can do that. I'll explain how. And(!) you want the ID of the first record in your duplicate database to be 1. - I unde
Technical Help / Progressive number from the last one
Hi I am looking for a way to let the invocie number be progressive starting from the last one creted. Now I am using this formula: if 'Tipo di documento' = 1 thenlet y := year(Data);let c := cnt(select Tabella1 where 'Tipo di documento' = 1);Testo := "FE" + y + format(c, "000000")elseif 'Tipo di documento' = 2 thenlet y := year(Data);let c := cnt(select Tabella1 where 'Tipo di documento' = 2);Test
Technical Help / Phone Number Formatting?
Halio, below is my latest code (with lots of ideas taken from Sean). It adds a "+" to any string of numbers over 10, adds the (###) ###-### formatting to any string of 10+ numbers, and completes any string under 10 digits with "x" as a placeholder for the last digits so you can quickly see that you are missing digits in the string. For you to have every number start with "+00" , and not any other
Technical Help / Subtable - ordering system
First... LOL... So, I created a new tab (Add Item) at first following your idea but in the end I deleted it and now I have theese fields (Search, Qty, button ete) at first place at my main form. I added fields for Discount and Price. I added and a Cancel button. Now I will use some logic to it: e.g. if I don't type any Price it will copy the Price from the Articles table and, of course, look up th
Technical Help / Is it possible to link automatically (via a function) fields in two tables that contain the same text?
And, just to be explicit now about the steps I did to make it work: Starting point: two tables exist (full of data) with fields that are not linked but contain data to link. 1) create a new "to child" relationship field in the parent table 2) create a button in the parent table with a script: let parentId := (select parent).Id;let parentField := (select parent).field;let parentCt := count(parentId
Technical Help / Renumbering Subtable Records
I have a table named 'Apps Project' and a subtable named 'Trial Summary' that I want to be able to renumber with a button. This is only necessary if/when I've deleted records to throw off the numbering. For example: I have T1, T2, T3, T4. I delete T1 and T3 and I'm left with T2 and T4. I want to be able to renumber those trials as T1 and T2 with the button formula. I figure the best way of handlin