G

Technical Help / Copier - coller le contenu de plusieurs champs dans deux table.

Désolée mais j'ai oublié un"s" à table surtout quant il y en a deux.

G

Technical Help / Copier - coller le contenu de plusieurs champs dans deux table.

Bonjour, J'ai mis en place une base avec deux tables. La table "A" contenant des champs noms, adresse, etc…, et, la table "B" contenant des champs non, adresses, et d'autres. Je souhaiterais que la première table qui s'ouvre soit la Table "A" Pour faire soit une nouvelle entrée ou faire une recherche, puis copier l'ensembles des champs de la fiche ouverte dans la table "A "et de créer un nouvel en

A

Ideas & Suggestions / Dialog with text input

it would be really useful to have a dialog in the scripting language which prompts a user for some text.

K

Technical Help / Formula to add 5 days to a date

Thank you Jose and Mconneen :), it works and will help me chasing late payment :)! As you seem to be pretty good with Ninox :), could you please help me with another issue please? My clients have different payment terms. For example on of my client always pay at the end of the month or another one always pay at the end of the month, on the 5th of the following month. I'm trying to figure out how t

Ninox Profile

Technical Help / Calendar Options Tab?

@Mr K... While I cannot be certain.. I do recall a security pop up a long .. long (ok one more long) time ago when I first installed Ninox on my Mac.

Ninox Profile

Technical Help / Alert and colour

if you call a hidden screen (openTable() with a color tab and use a button in the interface it may work.

Ninox Profile

Technical Help / Alert and colour

No not possible without a hack

P

Technical Help / In For - Where - Do Script - Add a loop

Thanks, it works great ! Just getting used to the syntax :-) P.

Ninox Profile

Technical Help / I'm looking for a way to filter and delete records after import

Did you look at the Delete records section here?? https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

Ninox Profile

Technical Help / Calendar Options Tab?

That fixed it. Thanks. Sad that the app does not know to tell me to do that, or suggest that it is the problem.

J

Technical Help / I'm looking for a way to filter and delete records after import

Thanks Jose, But I don't want to have to flag records. Do you know how to tell me how to delete all the John's and Mary's

Ninox Profile

Technical Help / Trigger after update - ImportFile from URL - Doesn't work

Hello Ninox community! I have a scenario in INTEGROMAT to NINOX and everything works ok, including the URL of a file in a Ninox URL field. Problem: I need that, automatically ("trigger after update" I guess?), the URL field executes the code: let a := 'Profile Picture URL' importFile(this, a, "Profile.jpg") 'Profile Picture' := file(this, "Profile.jpg") For some reason is not working. The code wor

Ninox Profile

Technical Help / Automatic progressive number WHEN IMPORTING - Urgent help!

Hi Nick, I added to your code a filter (between characters "[]") and it worked good. It took only the recently imported fields. Although it works as a temporary solution, I will also check @Mconneen experience point of view :) (or at least, I will try to figure it out) Thanks to all for the help

J

Technical Help / I'm looking for a way to filter and delete records after import

I'm not an expert but I'll do my best. I created a simple table TABLE1 with the following fields:N - type numberName - Type textFlag - Type Yes/Nofilled with the following records:10 John Yes20 Lewis No30 Mary No40 Peter No50 Paul Yes Records 10 and 50 are supposed to be deleted because they have the Flag field marked "yes". The following statement will delete those records:delete select TABLE1 wh

Ninox Profile

Technical Help / trigger at the update with integromat

Good morning, I use this formula to send a push notification on my iPhone let webhookURL := ""https://paste-your-webhook-url.here;let data := {RecordID: ID};http("POST", webhookURL, {'Content-Type': "application/json"}, data), but it only works with a button, no way to do with the trigger at the update, someone would have an idea if the problem comes from this command or from my integramat scenari

Ninox Profile

Technical Help / Calendar Options Tab?

@Mr K... I was able to recreate this by REMOVING Ninox Security & Privacy Calendar permission. If you make sure it is checked.. then restart Ninox.. You should be good to go.

Ninox Profile

Technical Help / Automatic progressive number WHEN IMPORTING - Urgent help!

@SoulMaker ... As a best practice.. You should import to a staging / import table.. and not your base transaction table. Yes.. you can define a match key... and yes.. the import will do an insert or update based on the match key.. but from an Old (old) IT guy.. best practice is staging table.. edits for data quality .. then insert / update based on matching criteria .. Still .. when creating new r

J

Technical Help / I'm looking for a way to filter and delete records after import

I get sales data from my vendors website by exporting the data to excel .CSV files. There are 10 differant vendors so I have 10 Excel files. There is data in some of the fields I want to filter out. (I do it manually in the excel file now) I would like to use the "Trigger on create or Trigger after update" but I"m open to any suggestions. EX: I want to delete all the records with the name "John, P

J

Technical Help / In For - Where - Do Script - Add a loop

You should use first let number := 1 ;to set number variable and its initial value. then use only number := number + 1 ; For instance the following code:let arr := ["a", "b", "c"];let number := 1;for i in arr do let number := number + 1 ; numberend produces the following output in Console:222 While with this code:let arr := ["a", "b", "c"];let number := 1;for i in arr do number := number + 1 ; num

J

Technical Help / I'm looking for a way to filter and delete records after import

Can you explain your needs with more detail? "importing records into fields???"