COLUMN NOT SHOWNING

 

 

Please help with this, i have a column which is not showning in edit view ,details view mean whiles everything is correct,but when i change the column formula to date type  it only show in the edit view but not in the details view 

i have virtual column, name DT Lastest reading with everything works perfect with the same formula

i just want the value in the DT lastest reading to duplicate in the real column called DTM PREV.MONTH CON.(Kwh)

COLUMN NOT SHOWINGCOLUMN NOT SHOWING

0 6 73
6 REPLIES 6

Hi Fred,

We need more details to fix this. If I understood correctly : 

DT Lastest reading > the column type is Date 

DTM PREV.MONTH CON.(Kwh) > you want it to keep it as a Date and returns the same value as DT Lastest reading

Note that as DTM PREV.MONTH CON.(Kwh) is a real column, it will only be updated when you update the row.

Then :

  1. Either you keep it as it is (and if the formula is good, it'll update if you edit any value in the form). 
  2. Either you replace it with a virtual column to duplicate the value automatically
  3. Either you want to replicate only the value at a B moment, then you need to create an action to update this row. But we need more details about how your app works to know where you need to put it (either through automation (time based, when a row is added), or after you fill a form). 

Thanks so much for the quick respond,,

please how do i implement the item B

Either you replace it with a virtual column to duplicate the value automatically

DT Lastest reading  is not a date type

Well just add a virtual column in your table, with the same data type as DT Lastest reading, with [DT lastest reading] as formula. 

 

i want the value in the real column not virtual column, with the virtual column everything works fine

Then you need option C. Real columns will not update even if they are formula based unless an actual edit/save action occurs on the row containing such real column.

Thank you so much

Top Labels in this Space