lotus notes - Run Time design change in lotusnotes -
i need change name , formula of columns of embedded view in lotus notes dialog box.i need change column name , formula when combo box value in dialog box changes.i added lotus script change column name , formula on combo box value change , added code reopen dialog box.
dim w new notesuiworkspace dim view notesview dim col notesviewcolumn set view = db.getview("test") j= 0 ubound(sboxcolname) set col=view.columns(j) col.title=sboxcolname(j) col.formula=sboxcolformula(j) next call w.viewrefresh()
but view column not updated in next open, gets updated when open view in designer , save view. when open view in designer can see column updated in design. there way embedded view column updated in runtime
in past used code in server agent, has worked fine. changed datetime value in column coloring rows (copy column , change formula). after had send command rebuild view in db.
set view = db.getview(*viewname*) set clm = view.columns(3) set newclm = view.copycolumn(clm, 5) call view.refresh() newclm.formula = {@if( [} & today & {] > @date(dtcontol); 255:0:0;-1 : -1 : -1 : -1 : -1 : -1)} call view.removecolumn(4) commandtext = {load updall } & db.filepath & { -t } & view.name & { -r} call session.sendconsolecommand(db.server, commandtext)
on client: maybe call ws.viewrefresh() sufficient