Skip to main content
Forum
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
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3811
posts
606
likes received
5
followers
Badges
Latest Posts
Re: Automatically change a select field based on a date from another field
@Sébastien Guillet said: And if I want to automate the function when opening the database (and no longer with a button), where should I add the code? Is it the same or does it have to be adapted…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Automatically change a select field based on a date from another field
@Sébastien Guillet said: I have the following error which appears: Expected symbol: end at line 4, column 3 For forgot the end to close the if statement. Add an end at the very end of the code.…
Fred
Fred
2 yrs ago
Get help
Reported - view
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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs ago
Get help
Reported - view
1
87
88
89
90
91
153
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
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
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics
