0

Can I execute a script after place Date on field date

Can I execute this script after a place a Date on example 'Real 3'.

Appreciate.

let myID := this;
let k := sum('Attributes Documents'.Hours);
let h := sum('Attributes Documents'.Budget);
let newRec := (create 'Issues Revisions');
let newcd := CodDoc;
let newcl := Document;
let newrA := 'Attributes Documents'.'Real 3';
newRec.(CodDoc := newcd);
newRec.(Document := newcl);
newRec.(Date := today());
newRec.(Hours := k);
newRec.(Budget := h);
newRec.(Backup := myID);
newRec.('Real 3' := last(newrA))

 

Copy

5 Antworten

null
    • Rafael_Sanchis
    • vor 2 JahrenWed, May 3, 2023 at 6:29 AM UTC
    • Gemeldet - anzeigen

    If there is no answer, I assume that it is not possible.

    • T_Bartzsch
    • vor 2 JahrenWed, May 3, 2023 at 7:21 AM UTC
    • Gemeldet - anzeigen

    Hola Rafael,

    there must be an Trigger after Change on every Date field... did you try it? Normalmente this must work as well as on other fields. What is your goal exactly?

      • Rafael_Sanchis
      • vor 2 JahrenWed, May 3, 2023 at 7:57 AM UTC
      • Gemeldet - anzeigen

      T. Bartzsch Bartzsch work on Trigget after Change. Thanks.👍

      • Rafael_Sanchis
      • vor 2 JahrenWed, May 3, 2023 at 11:00 AM UTC
      • Gemeldet - anzeigen

      Rafael Sanchis 

      I modify something and work perfect.

      let myID := this;
      let k := sum(Hours);
      let h := sum(Budget);
      let newRec := (create 'Issues A');
      let newcd := CodDoc;
      let newcl := Document;
      let newrA := 'Real 3';
      newRec.(CodDoc := newcd);
      newRec.(Document := newcl);
      newRec.(Date := today() + 1);
      newRec.(Hours := k);
      newRec.(Budget := h);
      newRec.('Real 3' := first(newrA))
      
    • Rafael_Sanchis
    • vor 2 JahrenWed, May 3, 2023 at 7:50 AM UTC
    • Gemeldet - anzeigen

    My goal is when I insert a Date on a field 'Real 3' ejecute the script. and create another table with all issues for cliente review, by each document. I have 3 issues for client review Real 3,4,and 5 .