Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Show value in Choice (dynamic)
@iliper LTD Good start. Can I recommend that you look at your previous post where you learned about the record() command. Here is the link again.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Show value in Choice (dynamic)
Take what you learned in your previous post and extend it to the new subtable. Post your code, if it works or not and we can help troubleshoot.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formula for deriving the value
Since Salary is dynamic choice field you can use the record() command to get that record and then you have access to all of the data. record(Salary,number('Choice (dynamic)')).Number1
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Dynamic Choice/Multi-Choice
@RoSoft_Steven Wow, that would be awesome. I haven't heard anyone talk about this yet.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Forgot the part of showing the data: let selected := unique(Table1.numbers(multichoicefield)); let allPossible := select tableroot; let notSelected := allPossible[(var v := this; not selected[= v])];…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
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

1 26 27 28 29 30 153

Welcome to the Ninox community

Fred

Re: Show value in Choice (dynamic)

Re: Show value in Choice (dynamic)

Re: Formula for deriving the value

Re: Dynamic Choice/Multi-Choice

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

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

Overview