0

Button for duplicate last records

I have table "Daly Estimation", and subtable "Hourly Estimation". I need formula for button, with will located in "Daly Estimation" table, to duplicate last record in "Hourly Estimation" and open duplicated record. in new record will change just Date Time

'Date+Time' := 'Date+Time' now ()

Regards

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Like
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    You can try something like:

    let lastRec := last('Hourly Estimation');
    let dupRec := duplicate(lastRec);
    dupRec.('Date+Time' := now())
    

    This assumes that the record with the highest record Id in the subtable is the actual "latest" record for your work flow. If not then you will need to filter the subtable selection so it gets the record you need.

    Like 1
    • Fred works fine, thanks a lot

      Like
Like Follow
  • Status Answered
  • 2 mths agoLast active
  • 3Replies
  • 24Views
  • 2 Following