plafontaine44
-
how can I remove an item from an array?
I have found idxRemove() but unable to make it works... let say: let A := sort((select Achats).total_vente); idxRemove(A,2) tell me that the function not defined...number... Thanks!
-
How can I use an array in constraint formula?
I need to exclude some items that correspond to a selection : (select table)[xxxxx].ID So It gives me a list of ID but in constraint, it look to take a single value...…
-
How can I apply a constraint on all results : (select table) [ xxxxx ] ?
I need to have a constraint but to be applied on multiple results. number(b.ID) != (select Achats)[number(Atelier.ID) = number(a.Atelier.ID)].Contact.ID I wish to exclude all contact ID that…
-
I need to run a formula on each field of a table...
I have a table with some ''class'' and each ''class'' contain some contact. I need to set a constraint that prevent the selection of a contact already in the actual ''class''.…
-
is it possible to get the ID of a sub table ?
I have a table with some entry...I wish to get the contact in this table and find it s ID on the contact table. the contact table is simply added to the actual table, not composite.…
-
How to prevent calculated field to been updated?
I have a table with some data and each time I add a new line with new values, the last entry become ''actual''. So I can have a follow like : taxes were 5% but since last week it s 6%....…
-
is there a way to count number of item within a selection field?
I have a selection field and I wish to use to number of item inside to check if all those item are used in the table. For example: selection field = red, blue and green table entry:…
-
is there a way to have a ''master'' table that have all other table as composite table?
It would be cool to have only one form to manage all the db field... to do so, it need a link between all table... any idea?
-
is there a way to make a view table with each row discribing some field?
I need to explain I think! :) I have a table with some purchase. Like this: purchase 1 = product1, product2, product3, product4 each product have its qty and price...…
-
is there a way to set the value of a number field with a formula or a button?
I have a field filled by the user with the amount given by a client with a method selection (cash, credit...). But It could be possible for a client to give some cash and pay the rest with a credit…
-
is there a way to ''exclude'' the actual field to avoid circular reference in formula field?
I have a field : Group then I have a formula field and I wish to add a formula to set the right group... let t := this;if cnt((select Achats)[text(Livraison) = "Sous-Groupe" and number(Atelier.…
-
table got blank...until i exit and return...and blank again...and formula do not refresh sometimes
I lost all data to blank table...until I exit and return...and some field wont update...and long time loading between operation! I have a good connection (gigabite) and no problem on other site!…
-
formula error! Format issue with formula!
I have a $$ field and when I use it in a formula, the field stay undefined... sum(total_vente, prix_shipping, taxes) each field in the sum are $$ format...…
-
formula field wont show formula result
I have a formula wich have work for some time and then stop working. Only thing I change is to add some field but nothing linked to the formula. I think that it seem to be a field type issue.…
-
is there a way to set currency format in formula field ?
I have a formula that sum values... and I would like to set it with the same format of incorporated in number field... thaks!
-
is it possible to sum field under condition?
I would like to sum fields within my table but only if they correspond to something... for exemple, I have product with 2 different type, let say type A and type B.…