AutoFill or Lookup: add date before time

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
mpol_ch
User
Posts: 877
Location: Switzerland

AutoFill or Lookup: add date before time

Post by mpol_ch »

Hi,

I am having a field as time (08:00).
I want to use this field in another table (auto fill or as lookup) with add date in front of it exp: 27.07.2022 08:00 .

How can do this or what is the best way to get it?

  Table Employee (Source Table)
  Id: 34
  Name: Lomor
  Start time: 08:00
  End time: 19:00

  Table Bulk (Target Table)
  Id: 2
  EmployeeId : 34 (auto fill)
  Name: Lomor (should be filled automatically)
  Start time: 27.07.2022 08:00 (should be filled automatically)
  End time: 27.07.2022 19:00 (should be filled automatically)

Right now when I use Autofill then some fields are not filled.
mpol_ch


arbei
User
Posts: 9284

Post by arbei »

AutoFill just fill the field value to the target input as is,. If you want to add something else, you may modify the value yourself by adding a handler in Start Script, e.g.

$("#x_EmployeeId").on("autofill", args => { // Check and change the id to your actual element ID
//console.log(args); // Check the data available in Console panel first
if (args.target == "xxx") args.data = "..." + args.data; // Change the data for a target
});

Post Reply