Fred

San Francisco, USA

3418
539
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Button to make record
How is CASH DESK and LIST OF PLAYERS related? Is thE field "Customers", from the original post, the field in CASH DESK? So a record in CASH DESK is linked to only 1 record in Customers (or LIST OF…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button to make record
@iliper LTD said: now I have a button and a formula that does everything well, it enters a record in a table 'Cash in/ot'. But this entry is not linked to the visitor's account.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
@Rafael said: For both Question is YES Well you made me think about a solution for the formula field part. I've attached a DB with my changes. It is, of course,…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button to make record
To make things easier for me to understand can you give me: 1) the table name where the button is in 2) the picture you post is that from the table with the button? if not what is that table name?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Using tags for searching
Are you unsure how to add a new column in a table view so you can filter it?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button to make record
@iliper LTD said: We created a button separately from all tables through it we make entries in all tables. But there was a problem in order to make a record in the tables of the client.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
Do you need the data from Documentos to be a text field in your Next7days table? Can you add a view element in Next7days and use that?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
@Rafael said: create new table Next7days Where copy your Formula ? and where the select Documentos [newfield = 1] I'lost now, sorry I guess I made too many assumptions.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Select all choice in a multiple choice (dynamic)
@Web Name said: And then why is it just for the current record? Usually a trigger after update of a field only affects the record you are on. Are you asking to make the trigger affect ALL records in…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: View not showing top line on update
I get the same thing on my iPad with my iCloud DB. I don’t get everywhere, but I do see it at times. I haven’t checked on my MacOS.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Select all choice in a multiple choice (dynamic)
Sorry, misread your post. Here is what you can put in your trigger after update: let allTable := (select Table1); if YN then dMC := allTable end Change the following references to match your…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Select all choice in a multiple choice (dynamic)
You can try something like: let selDMC := for loop1 in numbers(dMCfieldname) do record(tablename,loop1) end This will put all selections of a dMC into an array.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Using tags for searching
@iliper LTD said: the department name is formed from three tags Perfix, number and group. Are each of those in separate fields? If not, can you give an example of the data?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button to create empty field
@pirinisz said: but in the original table I want to be able to add a 2nd or 3rd reference to the table "names"!!!! It sounds like you created the reference in the opposite direction.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Button to create empty field
I have not seen any function that allows a user to create a field through a button. What you are describing is trying to track multiple instances of similar data to a record.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
So it looks like you are trying to use a view element in another table. If you create the formula field and put my code, then you can just search on my field for the view formula:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: NB - Account issues - renewal
Sorry to hear that Ninox has made it difficult for you to upgrade. You should contact Ninox directly for help with subscriptions.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
Here is something quick off the top of my head: let dcheck1 := workdays(Date1, DataDate); let dcheck2 := workdays(Date2, DataDate); let dcheck3 := workdays(Date3, DataDate); let dcheck4 :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
Try creating five new formula fields (one for each Fecha) and put this in the formula: days(FechaPx,DataDate) You will see numbers from positive (days before the DataDate) to negative (days after the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Need to show only the Deliverables that will be issue in the next 7 Days.
@Rafael said: Need to show only the Deliverables that will be issue in the next 7 Days, from the DataDate. Help me understand what you want a bit better.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button that fills a table
I have no idea how to create a random text generator. Maybe someone way smarter than me can figure it out. But for the record creation you try something like: let selAll := (select tableName);…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Filter "OR"
In the filter you can put something like this, assuming it is a text field. ="supplier" or ="partner"
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Using tags for searching
@iliper LTD said: I want to create a table and separate fields for tags, and specifying the name of the tag, the table should display all the data of the department that correspond to the tags.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Copy and open new record
You don't need to close the current record. Just put the openRecord command inside the if statement: let x := dialog("NEW DAY TEMPLATE", "Do you want create template for a next day?", ["No", "Yes"]);…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to create records automatically
@Web Name Good to hear. please mark the post answered if you are happy with the solution.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view

1 84 85 86 87 88 137

Welcome to the Ninox community

Fred

My Posts

Re: Button to make record

Re: Button to make record

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Button to make record

Re: Using tags for searching

Re: Button to make record

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Select all choice in a multiple choice (dynamic)

Re: View not showing top line on update

Re: Select all choice in a multiple choice (dynamic)

Re: Select all choice in a multiple choice (dynamic)

Re: Using tags for searching

Re: Button to create empty field

Re: Button to create empty field

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: NB - Account issues - renewal

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Need to show only the Deliverables that will be issue in the next 7 Days.

Re: Button that fills a table

Re: Filter "OR"

Re: Using tags for searching

Re: Copy and open new record

Re: How to create records automatically

Overview