Jump to content

Search the Community

Showing results for tags 'loop'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 3 results

  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_Date and use as a data source/view for a Tabular report datapage that allows user to enter a dated physical count for each item. @CraigSZ - I think this is similar to the direction you suggested in earlier post. Hoping I can do this all with a looping triggered action - Just not sure on Syntax. Any help would be greatly appreciated...Thx...
  2. What I hope to do, is autofill a table based on submitted start and end date of a project. The routine to be developed should create a record in the Milestone table for each 6 months period the projects lasts. i, mx, dur as integer dur = Round((DateDiff("m",[SA_StartDt],[SA_EndDt])+1)/6+0.3,0) = number of records to be created For i = 0 to dur mx = i * 6 Proj_ID // Period_No // Period_StartDate // Period_EndDate // Budget [Proj_Recno] // i + 1 // DateAdd(month, mx, [SA_StartDt]) // DateAdd(month, mx+6, [SA_StartDt]) // [SA-Awarded]/dur) Can I set this up as a trigger action on the table? or do I need to write a bit of Javascript and add this to a button? In both cases, I would appreciate some pointers. Floris
  3. LWSChad

    Automation

    Hello all! I have a brain twister here .... there's gotta be a way. CCarls3 got very close with Email Trigger of Multiple Records, but rather than simply sending email notifications, how can we automatically create multiple records based on the results of a query (or displayed on a DataPage)? I hope to automate the scheduling of Tasks. Please consider the following scenario: ScheduledTask - ScheduledTaskID - Scheduled Activity - Due Date Workflow (Parent table that describes an automated workflow) - WorkflowID - WorkflowName WorkflowStep (Child) - WorkflowStepID - WorkflowID - Scheduled Activity - Days from Today (easily converts into DueDate) [Workflow -< WorkflowStep / One - to < Many] Worklows are groups of WorkflowSteps WorkflowSteps create ScheduledTasks Any puzzle solvers have a good idea how to accomplish this? (without sending emails to Zapier's parser) Thanks!!
×
×
  • Create New...