Sotirios Zormpas's Profile | Ninox Community

Badges

Latest Posts

Re: Field labels in RED color
Hi, you can't change the color of the field's label, but you can change its 'Required' option to "Yes." This way, the border turns red when the field is empty (see the screenshot).
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Number of days between 2 days of appointment
Hi, For the second day, you will need: date(endof('Appointment') )
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: how to adjust what is returned from a link to another table
@mark. robinson , I tried also myself and I can say that there is not a convesional way to display "anything" into the Reference Field if there is not a link with a record in the parent table (the…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: how to adjust what is returned from a link to another table
@mark. robinson , I’ll think about it later
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: how to adjust what is returned from a link to another table
can you try the following to see whether it works? At the moment, I don’t have access to my laptop to check. if not 'PUT HERE THE REFERENCE FIELD NAME' then "None" else if not 'Assessment Date' then…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: how to adjust what is returned from a link to another table
@mark. robinson Hi, regarding your first objective I think the code could be further simplified: if not 'Assessment Date' then "Waiting assessment" else Name end
- szormpas
- 1 yr ago
- 2
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
@James Hi, here are some comments I hope you'll find helpful: You forgot the "<= xend" at the end of your code above. If you want to see the '2nd Fit Date' then you should add a new column in the…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Forumla Conversion
Hi @david , could you upload a sample database with some data?
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Formulate View field from multiple date entries?
Hi @James and @Fred , I've uploaded the 'ninox export (sample DB).ninox' into my workspace (cloud) to test. I noticed that the 'Fitting Date/Time' is an appointment field and not a 'datetime' one.…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Argument with Ninox AI and reference field
@Yoyo Gam Hi, what is the "link" between the invoice and the payment table? Can you discribe in more words what exactly you are trying to accomplish? Can you upload a sample database?
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Script Error on line 15
Hi @Rafael , I not sure what exactly you try to accomplish but can you try the following lines? let selectedCategories := numbers(Categories); let associatedRates := [0][false]; associatedRates :…
- szormpas
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Regarding the issue of storage space.
Hi, one possible solution is to re-import the downloaded backup archive. Then, you can delete the original database. Over time, as you develop your database,…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Argument with Ninox AI and reference field
Hi, in order to add a Reference Field, you first have to establish a "many-to-one" relationship. Open the edit fields dialog starting from the "child (many)" table,…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: CSS Framework & Ninox
@我是我的我 hi, try the following script: let recordId := record('2',1); html("<!doctype html> <html lang='en'> <head> <meta charset='utf-8'> <meta name='viewport' content='width=device-width,…
- szormpas
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: CSS Framework & Ninox
@我是我的我 Both have pros and cons. Bootstrap seems straightforward and uses component classes, but it is more restrictive, and you should consider its enormous size.…
- szormpas
- 1 yr ago
- Learn and share
- Reported - view
Re: CSS Framework & Ninox
@我是我的我 hi, I good starting point is the Boodstrap documentation page for tables: https://getbootstrap.com/docs/5.0/content/tables/ If you want a blue header then use contextual classes to color…
- szormpas
- 1 yr ago
- Learn and share
- Reported - view
Re: Size of database - Delete images fields and files
Hi, Ninox does not delete attachments if there are previous automated or manual backups. Could you try to delete all unnecessary backups first? This post provides a detailed explanation.…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Previous record
@George Sova Hi, If I understand your intention correctly, a solution would be to place the following code in the 'Trigger on new record' field: let x := number(this); let y := record(YOUR TABLE,…
- szormpas
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Choice (dynamic) Combobox Behavior
@Mike Nichols Hi, put the following code inside 'UnitSelector' Trigger after update option: let x := number(UnitSelector); Unit := record(Sandbox,x).Unit
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Ninox & regional date format
@Nick Hi, at the very least a written section in the documentation would be useful so that users can easily find the instructions for regional time and date settings.
- szormpas
- 1 yr ago
- Learn and share
- Reported - view
Ninox & regional date format

Hi everyone, many users faced issues with the regional date format after the Ninox update to 3.12 when accessing their application in the cloud using a Windows PC.…
- szormpas
- 1 yr ago
- 5replies
- 250
- 1
- Learn and share
Re: GPT for Ninox
Hi Jacques, I played with GPT a bit and found it very useful. It's an extra tool to help us with Ninox scripting. Thank you very much!
- szormpas
- 1 yr ago
- Learn and share
- Reported - view
Re: How do you Create & Popup a New Record with multiple fields prepopulated
Hi Matthew, try the following: let myEM := this; let New_EM := (create EMailer); New_EM.(Reservations := myEM.Reservations; Template := myEM.Template); popupRecord(record(EMailer,number(New_EM.Id)))
- szormpas
- 1 yr ago
- 1
- Get help
- Reported - view
Re: New Member Introduction - Seeking Guidance and Tips
@mitcheljohnsons135 A warm welcome from me as well
- szormpas
- 1 yr ago
- 1
- Get help
- Reported - view
Re: This is how I run ChatGPT in Ninox app
@Tomasz Winiarski Thank you so much for sharing! Let's see what our members can create with the help of AI. I was wondering if in the future Ninox is considering incorporating some of the AI…
- szormpas
- 1 yr ago
- Learn and share
- Reported - view

1 16 17 18 19 20 21 22

Welcome to the Ninox community

Sotirios Zormpas

Re: Field labels in RED color

Re: Number of days between 2 days of appointment

Re: how to adjust what is returned from a link to another table

Re: how to adjust what is returned from a link to another table

Re: how to adjust what is returned from a link to another table

Re: how to adjust what is returned from a link to another table

Re: Formulate View field from multiple date entries?

Re: Forumla Conversion

Re: Formulate View field from multiple date entries?

Re: Argument with Ninox AI and reference field

Re: Script Error on line 15

Re: Regarding the issue of storage space.

Re: Argument with Ninox AI and reference field

Re: CSS Framework & Ninox

Re: CSS Framework & Ninox

Re: CSS Framework & Ninox

Re: Size of database - Delete images fields and files

Re: Previous record

Re: Choice (dynamic) Combobox Behavior

Re: Ninox & regional date format

Re: GPT for Ninox

Re: How do you Create & Popup a New Record with multiple fields prepopulated

Re: New Member Introduction - Seeking Guidance and Tips

Re: This is how I run ChatGPT in Ninox app

Overview