BugTrapper

Joined: Sun Nov 18 10:02:19 UTC 2018

My Posts

Latest Posts

Re: Sum Qty in selected field for each Value in Arrray
where ' Sheet SKU #' = i).Qty
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox Update
Sorry, at 2 p.m.
- BugTrapper
- 5 yrs ago
- Learn and share
- Reported - view
Re: Button to add record and populate choice
Script for such a button is similar as this: Let newrecord:=create 'FilesTable'; newrecord.type:='Compliance'; newrecord.choice:=1; if 1 is the number of choice for Department A
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Ninox Update
Today at 3 p.m. I believe is a discussion about change requests and so on in the Ninox live stream stream with CEO Frank Boehmer. But I give no guarantee that it really will take place.
- BugTrapper
- 5 yrs ago
- Learn and share
- Reported - view
Re: Sum Qty in selected field for each Value in Arrray
Let sum:=0; For i in ArrayProductCodeNumbers do sum:=sum+first(select orders where CodeNumber=i.CodeNumber).Qty end
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Calendar Invites?
I am realistic, Ninox is only a Database system with scripting language and Rest API. So Ninox is not built for working with all 3rd party products. Is AirTable be able to do so ?…
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: expire date
expiredate:=date(year(startdate),month(startdate)+duration in month, day(startdate));
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Calendar Invites?
with Integromat or Zapier
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Untertabelle Summe
Let sum :=0; for i in select Tabelle8 do sum:=sum+i.Berechnung; end; Berechnung:=sum*0.19; Du solltest Deine Tabellen und Berechnungsfelder sinnvoller umbenennen, sonst wird es irgendwann chaotisch.
- BugTrapper
- 5 yrs ago
- Learn and share
- Reported - view
Re: Doppelter Datensatz vermeiden
let i:=this; if cnt(select Kunden where Vorname = i.Vornamen and Nachnamen=i.Nachnamen) >1 then alert("Name existiert schon !");
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Cloud Services
I beliieve yes
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: How do i copy a drop down list from one database into another one?
Not possible I believe
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: "Readable if" for specific user group
user() = 'editor' or userIsAdmin()
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: locking a field
You can hide the field with a yes/no button. Set the name of the yes/no button to 'Hide' and in the field comfiguration dialog set s script to 'show only if' or similar to Hide=true
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Automatic email sent on a specific date. Is that something possible to do with Ninox?
No, timers do not exist in Ninox. You could only write a script, that checks, if you open the database, if someone has birthday and display the name on your dashboard or send an email automatically
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: 500 Internal Server Error
This was an API problem by Ninox
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Best way action to selected records
Make a button "Send", as a script for this button try this: for i in select contacts where yes/no = true do sendmail(...) end
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: display problem!
There is an example database 'Linktable' inside the webinar team. Maybe you take a look ?
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: converting trail database
No need for converting.
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: display problem!
ID_prix_1:=Nr; instead of number(xxx) gives you the id number of the actual record.
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: problem returning an ID
Try .Nr instead of .ID
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: Use a number in a choice field as a multiplier of a number field?
number(replace(text(Choicefield),"%",""))*Numberfield
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: How to update a view automaticcaly ?
There are many views and it is not really clear, what he meant. I thought time periodically refresh and this is not possible. If it is a view inside a form, you are right.
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view
Re: How to update a view automaticcaly ?
Automatic refresh is not possible, only a trigger, if database will be be opened (in options of database)
- BugTrapper
- 5 yrs ago
- Get help
- Reported - view

Welcome to the Ninox community

BugTrapper

My Posts

Re: Sum Qty in selected field for each Value in Arrray

Re: Ninox Update

Re: Button to add record and populate choice

Re: Ninox Update

Re: Sum Qty in selected field for each Value in Arrray

Re: Calendar Invites?

Re: expire date

Re: Calendar Invites?

Re: Untertabelle Summe

Re: Doppelter Datensatz vermeiden

Re: Cloud Services

Re: How do i copy a drop down list from one database into another one?

Re: "Readable if" for specific user group

Re: locking a field

Re: Automatic email sent on a specific date. Is that something possible to do with Ninox?

Re: 500 Internal Server Error

Re: Best way action to selected records

Re: display problem!

Re: converting trail database

Re: display problem!

Re: problem returning an ID

Re: Use a number in a choice field as a multiplier of a number field?

Re: How to update a view automaticcaly ?

Re: How to update a view automaticcaly ?

Overview