s.addinsell
-
Issue to drag and drop columns of a 2 relational tables
Hi Having created a relation between 2 tables in a base I go to "modify" (gear tool) and I try to drag a column from the right window (available columns) to the left window (visible columns) but it…
-
Recover a field ?
Hi I have 2 tables in a database. I would like to recover an erased field from one of this table to the other. Can someone tell me the way to do it ? Thank you
-
To colour with conditional style with the id ?
Hi, Is there a way to color sommes values in a column with the conditional style with the id ? Normally one use the same letters of some names to color them.…
-
Magic trick with palmed values…
Hi, I added 5 new names in a base and it is impossible to see them. Even if I sort my id raws in ascending order this 5 names are not displayed…Their id numbers are missing.…
-
Math symbol missing in a formula ?
Hi I try to select names wich are displayed only one time. So I use a formula for duplicates like this one : let myV := 'Bird name'; if cnt(select 'table name' where 'Bird name' = myV) > 1 then…
-
Error in a formula ?
Hi I have this formula with a button : let t := ""; for i in (select 'Oiseaux famille genres espéces') order by 'Premier mot' do if t = i.'Premier mot' then i.('Premier mot':= "xxx") else t := i.…
-
Duplicates… Ninox… Excel…
Hi I try to select names wich are displayed only one time. So I use a formula for duplicates like this one : let myV := 'Bird name'; if cnt(select 'table name' where 'Bird name' = myV) > 1 then…
-
A black line in a rectangle
Hi I want to create a transparent rectangle in the form view I create a formula I enter : html("<hr>") I get a rectangle with a blalck line inside I go to "style" on RGB I select "background color"…
-
Issue with a formula
Hi I have an issue with a formula wich extract the first word of a coumpound word : substr(Nom, 0, index(Nom, " ")) That works perfectly but not with one name.…
-
To copy-paste values from a record to other ones ?
Hi Is there a way to copy-paste values from a record to other ones ? EG I have a record with some fields that I’d like to copy to twenty empty fields of twenty other records.…
-
Two fields stuck In the form!
Hi In the form of one of my base I have an issue with two fields. These two fields are side to side and it is impossible to separate them : they are stuck ! If I try to detach one,…