Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3409
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Automatically change a select field based on a date from another field
@Sébastien Guillet said: However, I don't understand what I should do next. I know how to create a button but I don't know what I have to add as code so that it can modify the status of each row of…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: But if i want to introduce in addiion to these, client and product id? Take a look at the DB with the Quick View table to see how to add user selected parameters.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Automatically change a select field based on a date from another field
Try the days() function. This will get you the number of days in real numbers. Then you can add a for loop function. There is no way in Ninox to trigger something based on time.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Automatically change a select field based on a date from another field
an appointment field titled "Date du dernier rendez-vous" which matches on the date of the last activity recorded for each account on the activity sub-table How is the field 'Date du dernier…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: For the graph/statistici the table where start from is MOVIMENTI i suppose? That is correct. Take another look at the db file I upload a few days ago to see samples of some codes.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: with apple, you didn't need to do anything special to have barcode reading, right?it just works? that is correct. no special software needed.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Automatically change a select field based on a date from another field
do all your appointment times always fall within the same day?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea sadly there is nothing I can help with on Android or another product. In iOS the scanning tool is built into Ninox. You may want to email Ninox directly.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
Ok take a look at v3. I changed delivery to returns. There is the item/quantity options and the multi scan option. I left the view element so you can see it working.…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea for the driver, do you want single item and qnty or multiple scan?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
Here is my latest sample. The Kitchen tab now has two parts, you can scan a single item and enter a specific quantity or you can "scan" in multiple product ids.…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: For the Export/Import boffins out there.
boffins? I would like to learn the history behind this. :)
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: how to project this db
@stef. idea said: Ok.The dropdown (or radio) with 100-150 client on a mobilephone (the operator is moving around and will use a smartphone) it isn't very hand. That is very true.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: for what i undertand those fileds in the new table don't work with barcode reading right? Actually the Data Entry table allows the use of the barcode scanner in iOS.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Wrong ID in Multiple Choice?
Try putting numbers() around 'Note Type'. concat(NOTES[numbers('Note Type') = 9].Note) This is only find records with only the 9th choice selected. Since it is a multiple choice field,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: i had an idea about the barcode I actually don't need a table for client and a table for product That is one way to go about it. I think it would be good to have client and product…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: No sort/filter in view element in iOS v3.7.8
@Sam said: Yes. Did you find a solution? Ninox just need to update the app. I’m on v3.8.7 and if you just tap the column name then you can filter/hide/add.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: the whole db Any self designed DB from a beginner will always be a work in progress. My personal DB has changed so much from when I first started.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: linked table marked red in field list
@stef. idea If you delete the formula in the Show data as then it will default to show the record Id and the first two or three fields from the Vendite table. Which might not be what you want to see.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: a part that...do you think is it a good structure?it seems so o me Are you asking if the choice field is good structure? or the dashboard? or your whole DB?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: linked table marked red in field list
@stef. idea I can't answer that question as I don't know what you info you want to display.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: linked table marked red in field list
There is an error in a code in the reference field. Take a look at your Show data as section and you will see a red box around it. The last letter "J" tells you there was a field name here and now…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: how to project this db
Looking at your Month field, you didn't create the month names in chronological order. You need to have Gennaio as selection 1, Febbraio as 2, Marzo as 3.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
Can you make it work with just a month field like in my code? Since you have a dynamic choice field, getting data from it is not as straight forward as a simple choice field.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: how to project this db
@stef. idea said: definitely there is somehting not working in your db you are correct. I didn’t take into account the year field in the formulas. I was thinking I would use the year,…
Fred
Fred
1 yr ago
Get help
Reported - view
1
71
72
73
74
75
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
