RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: emailing list of contacts not changing the firstname in list
Off the cuff.... Try this: ('Emailsend' is an extra yes/no field if you haven't got one in your table Customers) let sendmails := select Customers where 'GDPR Status' = 1 and 'Send Email' and…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: emailing list of contacts not changing the firstname in list
Change to: let xFirst := recipient.FirstName .... Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: How do I make a multiple choice box dependent on the value of a specific field?
Hi Stefaan, Here it is: https://www.dropbox.com/s/qhrs8f6htf2sctj/Used%20Cars.ninox?dl=0 Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: How do I make a multiple choice box dependent on the value of a specific field?
Maybe these cascading dynamic choice fields could help you Stefaan :…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Something like: let d := if weekday(today()) = 3 then today() + 4 else if weekday(today()) = 4 then today() + 4 else today() + 2 end end;if cnt(select JobDockets where DispatchBy = d) > 0…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Changing the Inventory template
Well I don't totally agree Fred (no offense), from a seller point of view, I would only put the serial number when selling the guitar. Because when you purchases 100 of the same model of guitars,…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Changing the Inventory template
Actually, you only need the serial number when selling?Then I would only put an extra field for the serial number in the child table of 1_Client Orders (Sales in your data model)No need for an extra…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Splitting data or trimming where a space is
I knew there was a simpler alternative with regex, but I don't know enough about that. It works very well. Well done and thanks Alain.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Splitting data or trimming where a space is
Hi Aaron, In plain text (to copy/paste): for s in select 'Splitting text and number' do let i := 0; let f := -1; while f = -1 do f := index(s.FullText, text(i)); i := i + 1 end; s.(Color := substr(s.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Testing a due date from the Global Trigger after open
Have you already tried to make a variable of the date first?: let d := today() + 2if cnt(select JobDockets where DispatchBy = d) > 0 thenalert("Sending Email")end or with square brackets...…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Variant of a new product to the invoice
That's weird, maybe it's a Ninox bug? I can't explain it.
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Variant of a new product to the invoice
I think you use formula fields to fetch the data? Formula fields are always updated when things are changing in the source. Best practice is to use static fields instead and use a trigger to fill…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: function is not defined: removeAllButDigits(String)
As I didn't make the '0_SVG_Barcode_GS1-128_Lite database' myself, I can't help you any further. Does the original still creates barcodes? Then you should check this one for missed formula's.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Would someone help make me a better coder?
Code can be shortened: let m := Month2021;select InvoicesE2021 where year(Date) = 2021 and month(Date) = m Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: function is not defined: removeAllButDigits(String)
The function you want to use is a self made function/script in the global script definitions of the data base. put this in that field to let it work: function removeAllButDigits(mixedString :…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Email multiple attachments
If this helps, I see in your code let att: = files (this) too much spaces, after':' and after 'files',try this:let att:= files(this); Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Getting value instead of index on choice field
number(text(interval)) gives the nummeric value of your choices
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Email multiple attachments
The pdf is created but not available when sending the mail. After creating the pdf you can use the function sleep() to create a pauze till the pdf is available. E.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Auto create records in sub-table
Tested and found another fault, this works: let me := this;let arr := ["code1", "code2", "code3", "code4", "code5", "code6", "code7", "code8", "code9", "code10"];for i from 0 to 10 do let p :…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Auto create records in sub-table
You can also leave the counter-part in jour example and use the i. new.(WPQCDK := i);
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Auto create records in sub-table
Oops, 'creation code' should be Name
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Auto create records in sub-table
John, we can make an array for this. let me := this;let arr := [code1,code2,code3,code4,code5,code6,code7,code8,code9,code10]for i from 0 to 10 do let p := (create TOPICS); p.…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Auto create records in sub-table
John, let me := this;for i from 0 to 10 do let p := (create TOPICS); p.(TRAINING := me)end Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Email multiple attachments
Sorry, I didn't look at your code in detail. I suppose there are no other attachments in the record except those two made with the code, then you can use: let att := files(this);......................…
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view
Re: Bild aus anderer Tabelle in Printengine über select-Befehl darstellen?
You can use: record(ImagesTable,1).Image1 In this example I have a table with all the images in the first record (with Id1) where i pick Image1 Steven
- Ninox partner
- RoSoft_Steven.1
- 4 yrs ago
- Get help
- Reported - view

1 28 29 30 31 32 65

Welcome to the Ninox community

RoSoft_Steven

Re: emailing list of contacts not changing the firstname in list

Re: emailing list of contacts not changing the firstname in list

Re: How do I make a multiple choice box dependent on the value of a specific field?

Re: How do I make a multiple choice box dependent on the value of a specific field?

Re: Testing a due date from the Global Trigger after open

Re: Changing the Inventory template

Re: Changing the Inventory template

Re: Splitting data or trimming where a space is

Re: Splitting data or trimming where a space is

Re: Testing a due date from the Global Trigger after open

Re: Variant of a new product to the invoice

Re: Variant of a new product to the invoice

Re: function is not defined: removeAllButDigits(String)

Re: Would someone help make me a better coder?

Re: function is not defined: removeAllButDigits(String)

Re: Email multiple attachments

Re: Getting value instead of index on choice field

Re: Email multiple attachments

Re: Auto create records in sub-table

Re: Auto create records in sub-table

Re: Auto create records in sub-table

Re: Auto create records in sub-table

Re: Auto create records in sub-table

Re: Email multiple attachments

Re: Bild aus anderer Tabelle in Printengine über select-Befehl darstellen?

Overview