Jump to content

Search the Community

Showing results for tags 'insert record'.

  • 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 2 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. Hi, I am trying insert a record which has a auto number. I am trying return auto-number in my response but it returns nothing. can anyone advise on this. table :TBL_TEST{uid autonumber,ID string ,NAME string} function CallWebAPI1() { var params={"ID":"1","NAME":"test"}; request.open("POST", "https://XXXXX.caspio.com/rest/v1/tables/TBL_TEST/rows", true); request.setRequestHeader("Authorization", "Bearer "+ accessToken); request.setRequestHeader("Accept", "application/json"); request .setRequestHeader("Content-Type", "application/json;charset=UTF-8"); request.send(JSON.stringify(params)); request.onreadystatechange = function () { if (request.readyState == 4 && request.status== 201) { var response = request.responseText; //request.responseText returns empty here. } } }
×
×
  • Create New...