Jump to content

Search the Community

Showing results for tags 'Update'.

  • 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 18 results

  1. Hello all, I have an Update datapage where, on Submit, I need to 1) show a popup message saying the changes were saved and 2) close the window or tab of the host page. I set the 'destination' of the datapage to 'Close Window' and put the below js in the footer to show the message. <SCRIPT LANGUAGE="JavaScript"> function myFunction() { alert ('Your updates have been saved') } document.getElementById("caspioform").onsubmit = myFunction; </SCRIPT> The problem is the js seems to block the 'Close Window' function and the page just refreshes to 'same form' and shows
  2. I'm trying to create a trigger that will add fields to a bunch of related tables based on the new CCTAproject_id that is entered on the parent table. It won't let me get rid of the ID field for some reason so I'm guessing that is a necessary field. My solution was to take the max existing value in the ID field and add a 1, so that new records increase sequentially by 1. I get an error when using this method, "Column '#inserted.CCTAproject_id' is invalid in the select list because it is not contained in either an aggregate function of the GROUP BY clause, (error code: SQL8120). But if I r
  3. Hi all, I cannot seem to overcome an issue with the use of Javascript on a bulk edit screen. There is a basic little script I wrote to control when users should be notified about changes done in bulk. It should simply prevent notifications from being sent if the user did not alter the initial delivery status of a product. While the script itself executes just fine upon each change to the delivery status field, the value that gets inserted into the text field which toggles the actual notifications isn't being saved when I hit "Update". It works if I manually type in Yes or No, bu
  4. Hello! I have an app that serves like a ticketing system. The tickets are either "Open" or "Closed". The field that handles the "Open"/"Closed" value I've set to hidden in my Results and Details page. Aside from default functions of the Update button in the details page, can I add another function to it such that when a user clicks the Update button it will set the hidden field to "Closed"?
  5. Hi, I have a tabular datapage that I'm using Bulk Edit to update selected records. When the 'Update' button is clicked I need to redirect to another url (using some parameters passed). I've tried a number of methods but can't seem to get it to work. - tried a custom 'update' button in an html block but it doesn't actually update the selected records (perhaps this is because and 'Update' on a Bulk Edit isn't the same as on a Details page?) - tried to modify, in Localization, the Bulk Edit text with html code for the redirect url but it just shows the html markup in the button.
  6. I have a yes/no field in one of my Tables that stores Completed Training Sessions that my Trainers perform. I use the "Sent to Payroll" yes/no checkbox field to gather the sessions for submittal to payroll.(I only count unchecked fields) After I submit payroll, I would like to do a bulk update of this Training Sessions table and check all the "sent to payroll" boxes to yes...so they will not be counted twice when I run payroll again. I have repeatedly tried to get some help from Caspio for this fairly simple update function...Ideally I would like to deploy a button on my websit
  7. Is there a way where we can modify the "Update" button? I would like to add a functionality on it wherein it updates the records then close the window afterwards. Is this possible?
  8. Just a little feedback. Apps being down all day on a Saturday is very unfortunate. The new release has a schedule release of February 10th. We use apps I created and Saturday is a very busy day for us. Why wouldn't you schedule a maintenance like this over night?
  9. Hi guys, I have what will probably be a simple question but I can't seem to work it out. Essentially I have a Checkbox called ConstructionContractAvailable? and what I would like to have happen is when a field called Prime Contractor is not blank that Checkbox will uncheck. All of this is in the same table and datapage. When I try it I get the Recursive Call warning. All I want is when there are words in the section called Prime Contractor the checkbox unchecks itself. Is this possible? I've included a picture of what I did (that didn't work). Any advice would be great.
  10. Hi, I have a table that I need to update records related to the ID value when a new record is inserted. When a new record is created a field called 'InvoiceID' stores (via parameter passing) a value. That value might be used multiple times in the table (for example, this is a Payments table linked to an Invoice table. The InvoiceID (unique- one) from the Invoice table is stored (many) in the Payments table for each Payment record for the same invoice. So for 5 Payments records there might be InvoiceID=2 used 3 times and InvoiceID=4 used 2) . When a new record is inserted to the
  11. We have a requirement for our Users to be able to update v quickly a large number of records within a tabular type report. The Bulk Edit/Update on its own wont work for us as we need to - when updating each of the records - to concatenate two Notes fields together along with a system date within each record and update another field. We can do this quite easily with JS in aa single Details Page (simple JS concatenating the two different notes values and adding today's date). However this approach does not seem to work on the Bulk Edit/Update - as whilst we can change a common field value ac
  12. On my table, I have a header titled "tags." I wanted to change the title to "Keyword." I edited the table on Caspio and changed the field name to match. While this updated correctly, the two datapages pulling from this table did not update to match (they still show "tags" instead of Keyword). Any idea how to fix this?
  13. I see many JS examples, but none addressing multiple datapages on the same webpage. I have two text variables that I want to concatenate in the 3rd datapage on my update webpage. I'm using the code attached in the footer of the detail page to no avail. I've tried several alternatives on the last line but none worked. The error associated with the last line below is "Object doesn't support property or method 'getElementById'. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var temp11 = document.getElementById("EditRecordWhere_Sa").value; var temp12 = document.getElementByI
  14. Hello there, I want to add some additional buttons to the report. The thing is, those buttons are not aligned with the UPDATE button that comes with the report, so I want to recreate that button to be able to align it with the rest and desable (display: none) the one that comes with the form. I was already successful with the submission one: <a href="javascript:window.submit()">SUBMIT</a> <script> function submit() { document.getElementById("caspioform").submit(); } </script> But I still cant find the way to do this for the UPDATE one. Does anyone knows how
  15. Hi, I have an update form that contains 2 hidden fields. Depending on the changes made in the form, the value of the hidden fields needs to change. One of the fields is a dropdown what controls placement on a report. I have added the following javascript to the footer. Any changes I make to the data are saved in the table, however, the hidden fields never change. Hopefully someone can spot the error in my code. Thanks, Bill <SCRIPT LANGUAGE="JavaScript"> function concatenate1() { var Sched.Status = document.getElementById("EditRecordStatus").value; var Control = docum
  16. Hi - this appears to be a solution to many issues, so I need to figure out how to direct a form submission to a different datapage so that it updates one or more fields automatically. There are two main instances where i want to do this: I have a new user form which creates a user_ID autonumber and passes it as an external paramater, I have fields for First_name and Last_name (both passing as external parameters on exit) and want to then create a full name by sticking them together. The way I presumed to do this was to direct to a 'Name creation' datapage which is a single record update th
  17. Please help with following error when creating a Single Record Update Form "Your datapage must be authenticated or you must pass an identifying unique ID as a parameter. To update the record based on a unique ID parameter, be sure you have enabled Advanced Options and Parameters. " I have checked Advanced Options and Parameters boxes but I still get this message. Rey
  18. I have a table with a linked table with the updates of the transaction regarding a particular row in the main table. Since I cannot update, is there a way to append the linked table and have the view only look at the last record with the unique link, so I am only looking at the latest appended record?
×
×
  • Create New...