Jump to content

kgraham2121

Members
  • Content Count

    8
  • Joined

  • Last visited

  • Days Won

    1

kgraham2121 last won the day on July 30 2019

kgraham2121 had the most liked content!

About kgraham2121

  • Rank
    Newbie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Assume following Table schema: Hi, My desired work flow Insert a date record into tbl_Inventory Count_Dates On INSERT, tigger the following: Loop through tbl_Inventory_Items - a list of each item to be counted - and insert a copy of each item into tbl_Inventory_Count_Detail, along with default value of 0 for Count of each record. This results in a record including new id, Count_Date(which triggered the event), Material_id, Material_Name, and Count (Set to 0). The purpose of this is to be able to filter tbl_Inventory_Count_Detail by Count_D
  2. Hi @CraigSZ, Thx for this response - apologies for delay acknowledging... Hoping you can answer a couple questions about this solution... 1. In the StockCountDetail table - when you say link to StockCountMaster table - do you mean like a join/creating a view? I think understanding this point is key to me understanding solution. I'm struggling creating a new record for each material item for any given count date -in a bulk way- thus creating the filter/view I can present in the Grid view. 2. I think I may have some questions about syntax for the looping in the trigger once
  3. When using Date/time field in X Axis of Chart (in my use case its a Chart/Tabular Report Combo Datapage) the date on X axis is in mm/dd/yyyy hh:mm:ss format. I need to remove the time component but can find any place to change it...
  4. @CraigSZ Thanks for the response. The Grid Edit view is exactly the look and feel I am going for. Where I am still a little stuck is - These physical counts are a recurring event. Trying to determine best way to present the Grid method uf data entry, without having to overwrite every field each time, i.e. Count on Jan 1, then on Jan 8, count again. Ideally user comes to datapage and it's a "Clean slate" each time. Also the Materials list is dynamic - can have additions and deletions. Want the data entry page to have all existing items. I feel like the answer is simple - but I'm just stu
  5. Hi, I am creating an inventory management workflow. Components: Materials List/Table Contains ~200 SKUs/items that we order. Unique identifier is Material number. Also includes Qty/pack, Unit Price, Material Description, Expiration, etc... Consumption/Ordering Tool Tabular Datapage that lists each item, # consumed in last X Days, and some calculations, based on consumption rates, how many would need to be ordered to replace what was consumed, for X number of Days (User Defined) Final piece I'm having trouble figuring out is a simple way for user
  6. @kpcollier - Maybe a triggered action? I do something similar in an Audit Log/Audit Trail Process. We have a group of Yes No questions on a checklist our billing group uses. We log any changes to any of the questions on the checklist - including timestamp/user. I am not a trigger expert - but seems something to this effect would work: On update of record, if #inserted value of your'Take Me!' button field is Yes and Original value was No, then insert Userstamp into 'Assigned to' field. Hope this may help a little...
  7. Thank you @Glitch, 1 trigger per action really simplifies this - thanks for that direction. I'm on to the 2nd step - identifying changes and inserting into Details Table. I understand joinging #inserted with Source(Orders Table). I feel like I may need a 2nd join and I'm not certain where to do it. Let me explain: Desired output to Details Table includes: 1 record for each change for each Summary ID(Foreign Key)...i.e. user updates 3 fields in source table. Part I of trigger inserts into Summary Table - Stamping with Summary ID, plus Time and User Stamps. We want Part
  8. Hi, I'm trying to to created a triggered action that populates and Audit Log Summary Table (1 record per event - ) and an Audit Log Details Table ( 1 record per changed Field/Column). Workflow is upon Insert or Update to Orders Table want to Log Changes. Trying to keep Log tables as simple as possible. Assume following Table Structures: Orders Table: Accession ID (Primary Key) Editable fields 1 Editable fields 2 Editable fields 3 Editable fields 4 Editable fields 5 Last Modified - Timestamp Last Modified by - User Stamp Audit
×
×
  • Create New...