Formula field not showing on table view column, only visible on form field window
I have this formula created as field:
let clc := this.LocConsum;
(select 'update DGR' where LocConsumVRG = clc).Done
In edit columns when I drag the formula from available columns to visible columns after I click ok, it`s not adding to my table view column, but it visible only in form window.
How can i add my formula into my table to be viewed as column?
8 replies
-
does anyone have any idea why the formula refuses to appear as a column? it is only visible in the form window.
-
Do you go in administration mode before you make those changes? (Red wrench) This is necessary in order to make the changes permanent.
Steven.
-
Hi, thank you for answer, Yes, I did that,
-
If i drag my formula from available columns to visible columns, after i click ok it goes back. with administration red wrench on.
-
Does the result of the formula contains more than one record? (I think so with the select command)
Then I'm not sure if you can display that in a table. If it is always one record try putting it like this:
let clc := this.LocConsum;
first((select 'update DGR' where LocConsumVRG = clc).Done)Steven.
-
let clc := this.LocConsum;
first((select 'update DGR' where LocConsumVRG = clc).Done)Worked, but my formula column is blank, only in form window shows my result.
I have:
Table1-ColumnA containing different numbers ex:5000343245, and ColumnB containing text ex: iV18 (all column)
What i need is: If numbers from Table1-ColumnA finds in Table2-ColumnA, then show text from Table1-ColumnB to Table2-ColumnB(my formula field)
Thank you
-
You solved the problem, thank you
let clc := this.LocConsum;
first((select 'update DGR' where LocConsumVRG = clc).Done)This ” first( ” was the first problem,
and the blank result was ”writable if” there was Lock like "yes" (deleted that) and now working.
Thank you for your help Steven.
-
Still having issue with this.. Formula appears only in the specific row after I made a change into the line. The rest column is blank, if I change something in second line, formula appears, an so..., and when i select the table it is very laggy, show a spinning circle about 4 minutes, i have 1000entries.
What i need is: If numbers from Table1-ColumnA exist in Table2-ColumnA, then text in Table 1-ColumnB
Content aside
- 4 yrs agoLast active
- 8Replies
- 1331Views