Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Duplicate a quote a change its number
Depending on how many fields that need to be duplicated, you can always put the Quote# code into your button so it will do the exact same thing as when you create a new record.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Trigger on create with numeric fields
@Mario Cuzzi can you post screenshots of the edit fields window for each table?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger on create with numeric fields
Can you post a sample DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger on create with numeric fields
Just to verify that Monto and 'Monto Prov' are actual number fields and Fecha in both tables are date fields.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Well that was dumb of me, you said so in your post. First step is to get a list of selected choices. You can try: unique(Table1.text(multichoicefield)) This will show you the dynamic value name of…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: 🆙 Ninox E-Invoicing
Is this for both public and private cloud?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Is the Muliple Choice field in Table1 a simple or dynamic field?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Mimic spreadsheet
@gyannes Glad to hear it works out. When you have a moment, please mark the post answered.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Mimic spreadsheet
One possible solution is attached. I'm not very good with Ninox charts so hopefully someone who is more knowledgable can help out there. I'm sure you can do something like you post in an html table.…
Attachment
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: How to write code for data filtering?
@我是我的我 said: test.2 is the second method that was discussed (it did not correctly output the total for the specified date). You wrote: let getCopy := (select Data); let Onlyname :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 Using the DB you uploaded, are you saying: date(time) doesn't give you just the date?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 I’m talking about just the name of the date+time field.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna Please mark the post answered.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: goto another record from calendar
You may have to look into@Sotirios Zormpas great html calendar in his dashboard post. Since it is HTML based you can probably redirect to where you want to go.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna use@John Halls
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@John Halls Of course, I put my parenthesis in the wrong place. I was trying to do something like this. Thanks for the simpler way.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@John Halls I get an function not defined error message of number, number, string.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code for data filtering?
@我是我的我 said: is there another way to achieve the functionality I mentioned by only editing the code? Using the DB you attached, if you wanted to search for only two dates in the Data table you could…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Delete view tabs
@Kate What version of the app are you using? I'm on 3.13.6 and have no issues. I can two finger click a view or I can control click on a view and I get the submenu.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna Silly me. I didn't follow the docs myself. 😄 You can only use numbers in datetime(). So you have to do a bit of math to get the hour and minutes into a human readable form.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
That is because you didn’t tell Ninox what time to add. Try: date+time field := date(year(date+time), month(date+time), day(date+time) + 7,time(date+time); Here is the documentation for datetime().
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic printing and join tables
@AlexisO i’m sorry. i thought you were going to use a json so you can use dynamic printing. what is still not working for you?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Print Report Layout
I just updated and was able to access the print layout in both local DB and iCloud DBs.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Avoid new records
@Pascal P. It seems like it is a bit late to pop up a message after the new record is created, but let me answer your question. Be aware that once you move your DB into the cloud for multi-user…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Avoid new records
@Pascal P. Is this in a button? Is this in a dashboard? Or in a data table? Are you checking another table or the current table?
- Fred
- 1 yr ago
- Get help
- Reported - view

1 27 28 29 30 31 154

Welcome to the Ninox community

Fred

Re: Duplicate a quote a change its number

Re: Trigger on create with numeric fields

Re: Trigger on create with numeric fields

Re: Trigger on create with numeric fields

Re: Dynamic multi-selection in the subform: Display of selected and unselected items.

Re: 🆙 Ninox E-Invoicing

Re: Dynamic multi-selection in the subform: Display of selected and unselected items.

Re: Mimic spreadsheet

Re: Mimic spreadsheet

Re: How to write code for data filtering?

Re: How to write code for data filtering?

Re: How to write code for data filtering?

Re: adding eg 7 days to a date+time field

Re: goto another record from calendar

Re: adding eg 7 days to a date+time field

Re: adding eg 7 days to a date+time field

Re: adding eg 7 days to a date+time field

Re: How to write code for data filtering?

Re: Delete view tabs

Re: adding eg 7 days to a date+time field

Re: adding eg 7 days to a date+time field

Re: Dynamic printing and join tables

Re: Print Report Layout

Re: Avoid new records

Re: Avoid new records

Overview