I am modifying the entry screen for UD12, which I will use for PPAP (part inspections, basically). For simplicity, I think I would like to go with Key1 being set as the current date-time when the record is created. Is there a way to do this in Application Studio? I am fairly new to this. I guess …

[image] JasonMcD: I’m sure this could be done in a BPM on save, but I thought this would be a simpler way… BPM is the simpler way and better practice.

It’s just to have a complete record when you save it. It also will be visible to the user as you said. It’s just a matter of preference really. If you want it when they actually hit save then Pre-processor is what you will want.

For starters, there’s a low (but not zero) chance of two people creating two records at the same time, causing a key collision. Second, having a deterministic key (e.g. an integer that counts up by 1 each record) can make it a lot easier to troubleshoot things if something goes wrong. Third, nothi…

[image] JasonMcD: I guess it would be some kind of Event? If so, could you provide guidance on that? I’ve been poring over the guides but still can’t wrap my head around this. For educational purposes, you would create an event on a trigger (found via Dev Tools in the browser) that would call…

If you want some simple code for the BPM, you can put this in a post-processing on update. int lastRecord_ID = 0; Ice.Tables.UD12 lastRecord = null; try { lastRecord = (from UD12Rows in Db.UD12 orderby UD12Rows.Key1 descending select UD12…

[image] klincecum: If you want some simple code for the BPM You don’t even need code for this. Post-processing on GetANewUD12 and add a set field widget.

[image] hmwillett: set field widget Perfect for him!

[image] hmwillett: You don’t even need code for this. I’m assuming you meant for the second part, because if you can do the first without code I’m all ears.

[image] hmwillett: Post-processing on GetANewUD12 and add a set field widget Yep, this part isn’t hard. I can do widgets all day, and I’ve already done something similar to this in a Function: [image] But now App Studio is, what, JavaScript? That’s what I infer from other things I have rea…

[image] klincecum: if you can do the first without code I’m all ears So… Not only could you all do this better than I could, but I might even have a better way to do this these days. But, I certainly do have a very rudimentary “autonumber” BPM in place - for 3 years now. (The 2 rightmost wid…

[image] JasonMcD: But now App Studio is, what, JavaScript? We currently don’t have access to any javascript functionality. I’m not sure if we are getting any, and if we do, at what level. Now the app itself is run off of javascript, but it basically reads widgets and config files out of hu…

Prepopulate Key1 in new record of UD Table - in App Studio

Kinetic ERP

hmwillett (Hannah Willett) March 7, 2023, 2:40pm 22

Kinetic Web browser Print Preview - Kinetic 202X - Epicor User Help Forum (epiusers.help)

Topic		Replies	Views
BPM to populate a field on New Epicor ERP 10 bpm , method-directives	2	824	August 24, 2023
Masking a UD key field to match a date field Epicor ERP 10	2	938	July 25, 2018
Force value into UD form key field Epicor ERP 10 e10	11	2127	February 7, 2022
Application Studio Pass Current Row Data in Event Kinetic ERP application-studio	2	2845	January 16, 2023
BPM to record changes in UD table? Epicor ERP 10 e10 , bpm , changelog	55	11967	June 11, 2020

Prepopulate Key1 in new record of UD Table - in App Studio

Related topics