Sotirios Zormpas's Profile | Ninox community

Badges

Latest Posts

Re: how to adjust what is returned from a link to another table
@Fred it seems that the beach stimulate my Ninox brain!!
- szormpas
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Field labels in RED color
@Vermaji , you can do the following: As @Alan Cooke suggests, you can create labels by using formula fields. Put inside them something like: html("<strong style='color:red;'>Customer Name</strong>").…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Field labels in RED color
@Alan Cooke hi, or you can put the field name as a placeholder like the screenshot below
- szormpas
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Field labels in RED color
@Vermaji , I agree with you. It would be nice to be able to change the appearance of the labels in all fields and have the "Style" option available in them, as is done with the "Formula" fields.…
- szormpas
- 1 yr ago
- Get help
- Reported - view
Re: Number of days between 2 days of appointment
@pabodart , I'm glad you found the solution!
- szormpas
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Number of days between 2 days of appointment
@pabodart can you share with us your whole function or can you be a little more specific about what you are trying to achieve?
- szormpas
- 1 yr ago
- Get help
- Reported - view
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

1 16 17 18 19 20 21 22

Welcome to the Ninox community

Sotirios Zormpas

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

Re: Field labels in RED color

Re: Field labels in RED color

Re: Field labels in RED color

Re: Number of days between 2 days of appointment

Re: Number of days between 2 days of appointment

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

Overview