John Halls

John_Halls

Somerset, England

Joined: Thu Feb 11 10:04:26 UTC 2021

My Posts

Latest Posts

Re: Delete record if fieldA := fieldB
@Gianluca Take away the dialogue and it works fine for me. That aside, I would not have the fiscal code held in a formula field. I would have the fiscal code held in a text field that is updated…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Delete record if fieldA := fieldB
Hi Gianluca The issue you have is that dialogue does not work in Trigger after update: It really needs to be used behind a button. The rest of the code was working for me. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Date of value specific changing
Hi. I would suggest putting this code in the table level Trigger after update: of the INTER table. if CONTRAT.'Date Cloture' = null and CONTRAT.'Solde Interventions' <= 0 then CONTRAT.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Date of value specific changing
Thanks. The Trigger after update has to live in the Inter table. The reference field INTER is the parent looking at the child. It will have an equivalent field from the child looking at the parent.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Date of value specific changing
Is Cumul Interventions the sum of hours from a child table linked to this table? If so, what is the link field called on the child table?
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Date of value specific changing
How is Solde Interventions calculated?
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Date of value specific changing
Instead of using a formula field, use a date field with a Trigger after update thus if Date = null and Number < 0 then Date := today() end if the number you are testing is a formula using a child…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: if, then not working within a function field script.
Add a temporary formula field with the following length(text('Business Process 1')) Then you can monitor its value when you are expecting it to be <1
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: ID of a newly (Create 'table name')
i.id or number(i) will give you the ID Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Multiple invoices for the same item
Hi Sam Your list of tables is a good start but you need a few more to complete the picture. Because a customer can own more than one pet, and a pet can be owned by more than one customer you need a…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: In Forms, search for string only returns one record
Do you see the navigation bar at the top right of the form? What happens if you cycle through these? Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
https://en.wikipedia.org/wiki/Italian_fiscal_code I would break down each part (surname, first name, etc) into its own field and calculation and then concatenate all the fields into the fiscal code…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Character Occurrences Count
@Alain Fontaine Thanks Alain. I caught the ones at the start and end but forgot about double letters. It's pushing the boundary of split's reason for being anyway but I was interested in finding a…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
@Alain Fontaine I must learn some regex. I came up with let mystring := "rockandrollwillneverdie"; let found := count(split("*"+mystring+"*","e"))-1; alert(found) Using the split function to replace…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Balance
Hi Luigi There was a similar question to this a couple of days ago. See my reply. https://forum.ninox.com/t/g9hbgqx/avoiding-a-circular-reference It requires a bit of coding,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Avoiding a circular reference
Hi Alex I had a go at this and, yes, it does seem that Ninox doesn't like that too much. It's not circular, but still... I changed OpeningBalance to be a number field,…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Finding the sum of the last entry given specific text in a field
Hi Alex Loops like this can be shortened to let a := this; let total := 0; for b in unique((select 'Bulk Inventory' where month(Date) = a.Month).Tank) do total :…
- John_Halls
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Search view Formula don't work
Try let xBusqueda := Busqueda; select Documentos where 'Ganado PLAN' = xBusqueda Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Short Contributors Bio
@Alan Cooke Great story Alan. Thanks for sharing. Can you tell me about your screenshot. What are the top row of buttons? How do they work? And the row below that?
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: Linking one record to one record
Hi Leonardo This might be overkill but you can create a pair of links between the tables, pointing in opposite directions. I tested this with two tables, Letters and Numbers In the Letters table,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
These would be good additions to have Mel Table level Trigger after load Record level Trigger after load Regards John
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: The New IPhone Display Mode
@Fred The new design is a game changer. You will love it!
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: Unique Field in a table
@Mel Charles Spot on there Mel
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Unique Field in a table
Hi Javier @Javier said: This way the client needs to enter only one time the customer information, and also has a way to search for the client in the database,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Formula don't give anything
Hi Rafael This line will never be true if Week = (select Documentos).Semana then Because Week is a number (or text) and (select Documentos).Semana returns an array,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 18 19 20 21 22 34

Welcome to the Ninox community

John Halls

My Posts

Re: Delete record if fieldA := fieldB

Re: Delete record if fieldA := fieldB

Re: Date of value specific changing

Re: Date of value specific changing

Re: Date of value specific changing

Re: Date of value specific changing

Re: Date of value specific changing

Re: if, then not working within a function field script.

Re: ID of a newly (Create 'table name')

Re: Multiple invoices for the same item

Re: In Forms, search for string only returns one record

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Balance

Re: Avoiding a circular reference

Re: Finding the sum of the last entry given specific text in a field

Re: Search view Formula don't work

Re: Short Contributors Bio

Re: Linking one record to one record

Re: All I want for Christmas!

Re: The New IPhone Display Mode

Re: Unique Field in a table

Re: Unique Field in a table

Re: Formula don't give anything

Overview