Jump to content

Search the Community

Showing results for tags 'update'.



More search options

  • 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


Found 16 results

  1. 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"?
  2. 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. Not sure if there's a way to do this there but it seems like it'd be cleanest if so. Any help would be greatly appreciated-
  3. William

    Simple Table Update

    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 website to be able to Update all the Training Sessions after Payroll. The SQL statement is fairly simple...but how and where to execute it in Caspio obviously is not....Any suggestions???
  4. 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 the standard 'data has been updated' message. So it seems to me I could put some kind of 'close window' function in the above js and put that in the 'message' section of the Destination wizard. I tried the below but it doesn't actually close the window/tab. <SCRIPT LANGUAGE="JavaScript"> function myFunction() { alert ('Your updates have been saved'); window.close(); } document.getElementById("caspioform").onsubmit = myFunction; </SCRIPT> Basically, I need, on Submit, the tab/window to close and a message to pop up saying data has been saved. Does anyone know how to do this?
  5. 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?
  6. mpnewby

    Upcoming Update

    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?
  7. 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.
  8. 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 Payments table I need the trigger to look up all other records in that same Payments table with the same InvoiceID and update them. I tried using the Where tabs with Field=InvoiceID Equals Field=InvoiceID but the trigger doesn't work. If I manually put in a number for the 2nd InvoiceID to test it the trigger does work. So the issue is the trigger being able to match existing record's InvoiceID value with the submitted/inserted record's InvoiceID value and update them. Does anyone know how/if this can be done? It seems like it should be simple so I must be missing something basic..
  9. 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 across multiple records we cant get JS to individually do a concatenation in each of the records involved. Am really interested in any ideas for this. Our latest thinking - please comment - is to use a Tabular report of searched records to display in std tabular form to the User. But to have an HTML block at the end that has a URL link they can click. This would open some kind of hidden web window/tab containing a Details record that we can apply the JS to (as advised above) for concatenating the two Notes field values and the date within each record. We have not quite got this to work and I would be really interested in views from this Forum. A key stumbling block is to arrange for a Parameter value that can be selected once - whilst at the Tabular report - and then reused/retained as the User works his/her way down the list by clinking on the link quickly opening/closing a Details form (using Auto Submit?). This parameter value we use to update a field with the records status. It and the values of the Notes fields that we concatenate and then update another field and really the record changes we are trying to accomplish. We have tried using a second datapage with a dropdown of the values that would hold a parameter value to pass over. However it loses its value after the first click. We were wondering if we could have somekind of dropbox field that we could set once and which would then keep its parameter value held whilst the User was clicking the html link block on the Tabular report and then activating the hidden web window/tab with the Details record. Any ideas from you experts out there :-)
  10. 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?
  11. 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.getElementById("EditRecordWhere_Su").value; var temp10 = temp11 + temp12; document.getElementById("EditRecordWhere_Text").value = temp10; } document.forms[2].getElementById("Mod0EditRecord").onmouseover=concatenate; </SCRIPT>
  12. MostlyJava

    Update Button For Detail Report

    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 to do this?
  13. 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 = document.getElementById("EditRecordID").value; var Company = document.getElementById("EditRecordCompany").value; var Company25 = Company.substring(0,25); var Position = document.getElementById("EditRecordPosition").value; var Date = document.getElementById("EditRecordDate_Open").value; var CompanyPosition = Control + ' - ' + Company + ' (' + Position + ')'; document.getElementById("EditRecordCompany_Position").value = CompanyPosition; if (Sched.Status == "Future Credit") { var DateControl = 'FC' + Date + ' - ' + Control + ' - ' + Company25; } else { var DateControl = Date + ' - ' + Control + ' - ' + Company25; } document.getElementById("EditRecordDate_Control").value = DateControl; } document.getElementById("caspioform").onsubmit=concatenate1; </SCRIPT>
  14. 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 that received First_name and Last_name as external parameters (hidden fields) and has a third hidden field that sets a Default value of [@First_name] [@Last_name]. I then redirect back to the original page. Not working though - any idea what I'm doing wrong? I'm building a project management tool and need to compare timelines on form exit. So I need it to see if the projected finish date is different to the actual finish date and - if it is - adjust some other dates accordingly. I also need to update some other fields, like 'Current_step' or 'Current owner'. Any ideas at all would be most welcome! Cheers. Tim
  15. reyemmaus

    Error Msg Creating Single Record Update

    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
  16. 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?
×