Lotus Notes 7 - Auto-calculation for one column from an editable view - InViewEdit event -

-

i have problem gives me headaches lately. hope can find solution help.

i have view : "vwtest" embedded on form. editable view. view has 3 columns: number , cost , difference. 3 columns have default values field names exist on form called "fmtest", field names are: number , cost , difference.

on main form ( contains view ) there field ( computed ) called: totalvalue.

the view has 2 actions: addline , deleteline.

what want is:

let totalvalue = 5000

  • user complete first line of view:

number | cost | difference

1 | 50 | 4950 => 3rd column value calculated automatically difference between 5000 ( totalvalue ) , 50 ( value of 2nd column )

  • user complete second line of view:

2 | 60 | 4890 => 3rd column value calculated automatically difference between last 3rd column value view , 60 ( current value of 2nd column )

i think that's recursive algorithm.

the value of totalvalue exists, number type field.

hope find solution , resolve problem! appreciate , time!

after every save have cylce through entries belonging "this" main document , recalculate totals. assume, "lines" response- documents main document , embedded view categorized unid of main document...

dim ses new notessession dim db notesdatabase dim viewembedded notesview dim viwnav notesviewnavigator dim ve notesviewentry dim docline notesdocument dim docmain notesdocument  dim dbltotal double  set db = ses.currentdatabase set docmain = ... 'somehow main document, therefor need current code dbltotal = docmain.totalvalue(0) set viewembedded = db.getview( "vwtest" ) viewembedded.autoupdate = false set viwnav = viwembedded.createviewnavfromcategory( docmain.universalid ) set ve = viwnav.getfirst() while not ve nothing   set docline = ve.document   dbltotal = dbltotal - docline.cost(0)   if dbltotal <> docline.difference(0)     docline.difference = dbltotal     call docline.save( true, true )   end if   set ve = viwnav.getnextdocument(ve) wend

why loop? if modifies first line after second 1 , third 1 have been created? total 2, 3 , subsequent lines has change.

this code not typed in designer , might contain typos. not contain error- handling , can produce replication / save- conflicts if not used carefully..

hope helps


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more