Possible to bind table manager to a an external invoice app?

Possible to bind table manager to a an external invoice app?

Posted by: g.kiriazidis on 19 February 2022, 9:50 am EST

• 

  g.kiriazidis

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 February 2022, 9:50 am EST - Updated 3 October 2022, 9:25 am EST

  Reading about the new table manager I would like to ask if the possible scenario is possible .
  
  I have a web app that generates invoices .
  
  The invoice has a header and details for entering line items and various calculations for taxes, dicounts etc.
  
  Can I use table manager and the calculation engine to build my calculation model , with formulas and then bind the model to the ui elements in the invoice app (using javascript).
  
  So that when a user changes an input field in the line items table the calculations are automatically updated based on the model and calculations defined.
  
  So that I can avoid having to write javascript in the ui for these calculations.

  Attached is a screen shot of my sample web app UI.

  

  1438×767 151 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 21 February 2022, 2:32 am EST

  Hi,

  Currently, it is not possible to use the calculation engine to build you calculation model. You can handle the events like EditEnded and ValueChanged and use the evaulateFormula to calculate the formula and update the UI.

  evaluateFormula method: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CalcEngine~evaluateFormula.html

  editEnded Event: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Events~EditEnded_EV.html

  valueChanged Event: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Events~ValueChanged_EV.html

  Regards.

• 

  g.kiriazidis

  • Post Options:
  • Link
    Copy

  Posted 21 February 2022, 6:26 am EST

  ok,
  
  thanks for the update.