Log In

Log In



Not registered yet?


Reset password Activation link
Forums
Tag "update records"

Updating records

Publication date: August 15, 2018

When I attempt to update the existing records, and have checked the “import” and “Update” buttons, and click on “apply”, I get a red bar message that I “didn’t have sufficient records or unique records” and no changes are made. I am using the NAME as the unique column and all records have an entry in that column.

I tried it again with only one record, knowing that the same (but slightly different) record exists in the database.

Got the same error msg, “You have chosen to update existent records with new data by unique key. But you have few similar records with this key in your database. Please, make sure you have unique values in your database for this key or choose another key.”

About exclusive editing control

Publication date: August 16, 2018

Scenario: I just published a table to a small group of teammates, in order to collect information and track updates. In some cases more than one colleague would update the same record at the same time, as a result one’s submit would overwrite the other’s, incurring loss of (possibly very important) data.

default value coming back when editing

Publication date: August 16, 2018

https://mytaskhelper.com/apps/bBWQjDoSjki4j0AaJdOSks/widgets/ctFuFcSfnczlunW5dcPXaU?view=ctFuFcSfnczlunW5dcPXaU
https://mytaskhelper.com/widgets/bBWQjDoSjki4j0AaJdOSks/ctFuFcSfnczlunW5dcPXaU

Dear

when updating data through a general table widget (first link) we are transferred to a form widget (second link)

when we do this on line 45 for example, the default value for R&D owner is shown again, although this value was filled in previously as Pierre Yves
for other lines, where Maarte is R&D owner, the value stays.

any idea what is wrong?

Kind regards

Robrecht

One Record Updating, Another Not?

Publication date: August 16, 2018

Please have a look at the following link. Search for end time after yesterdays date (10/11/14)

https://MyTaskHelper.com/apps/ddOXqjW7zcOQBcRgRdU8kg/widgets/aEW5ZdTe5cUidcJIfjWRLW?view=aEW5ZdTe5cUidcJIfjWRLW

Then for comparison have a look at its clone form. ANd search the same.

https://MyTaskHelper.com/apps/ddOXqjW7zcOQBcRgRdU8kg/widgets/dcHmkqW7jnWQ0CeL1Ezxm_?view=

Why is one form not being updated and yet the other is? Both are being entered through the same make and model mobile phone.

Edit Not Updating

Publication date: August 16, 2018

https://mytaskhelper.com/apps/ddOXqjW7zcOQBcRgRdU8kg/widgets/aEW5ZdTe5cUidcJIfjWRLW?view=aEW5ZdTe5cUidcJIfjWRLW

Click on a record to edit, click update nothing…Wait a few minutes and can sometimes update, other times have to wait for ages

Global Update Records Function

Publication date: August 16, 2018

Can you allow the global UPDATE ALL RECORDS function to write a default file for fields that are a graphic image, this is a real issue that MTH does not seem to permit. The problem is that some records have been written without the default images and as I have used these extensively it means that I am going to have to manually update records on behalf of clients.

Checkboxes appearing incorrectly in records

Publication date: August 16, 2018

Suddenly when a record is updated or a new entry is made the database is recording every checkbox as a value even though they are NOT checked. Please solve this problem! Thanks.

Multiple update deletes records

Publication date: August 16, 2018

I selected a large group and chose ‘update selected’.
Then i chose ‘customers’ (as an example), typed what I wanted customers to be, and (out of habit) pressed enter.
This instantly deleted a large number of records.

field missing from update

Publication date: August 16, 2018

when I go to update my Schedule project my working on field does not show. I have it enabled it just disappeared.

Import status emails: receive email when database updated

Publication date: August 17, 2018

Currently you have a feature that will send an email when a single record us updated. Could you add a feature that will send a simple email that states that the entire database has been updated? I update my database daily with a .csv file that updates records based on key data fields. Sometimes the records are updated but sometimes they are not. I would like to receive and email to let me know that the new .csv file has been uploaded – even if there are not changes. I have an automated desktop bot that uploads this file and I need to know that it actually ran in case it runs when I am not present.
Thanks

SQL Bulk-updates for records

Publication date: August 20, 2018

Right now if we want to make a large update to existing records it appears the most efficient way is to export the table, clear it, apply the update externally, and then reimport the table.

Can SQL be exposed for power users to update existing records?

Read,write and not delete

Publication date: August 20, 2018

Is it possible to add the following option to the existing options for inviting team members to a project: Access to read and update, but not delete records?

Email notifications about updated records to form submitter

Publication date: August 20, 2018

Is there a way to have MyTaskHelper send an email to the original Submitter each time the record is updated? I would like to send an automatic email when the administrator of the application updates the original submission.

Update existing entries via import (match on record ID)

Publication date: August 20, 2018

This is a must-have feature that was incredibly useful in DabbleDB. As a application developer, it is often necessary to have users outside the database update information that is inside the database. In this situation, it is critical to be able to bulk update existing records. There are also cases where it is simply faster to manipulate/update data in bulk in Excel and import it back into the database.

Here’s the link to the DabbleDB description of the feature: http://blog.dabbledb.com/2008/10/plays-well-with.html

Mass Update - All / Subset

Publication date: August 20, 2018

I’d really appreciate being able to perform a “mass update”, allowing me to update a Field with a particular value for either ALL the records, or, a subset of the records, based upon some criteria, e.g., I’d like to update ALL the records to have an “Ethnicity” = “Nepalese” (since all of them, at the present time, should be set this way, though, soon, there will be other records set with a different value); also, I’d like to set some of the new indicator-type fields (which are replacing a legacy “Status” field) to a value, based upon the contents of this Status field, e.g., if Status has a “B/Nep” in it, then, the indicator for “Baptized Elsewhere” should be set to “Y”.

Initial Value

Publication date: August 20, 2018

When I define a Field, I’d like to set it to an initial value (this is a very commonn feature for databases), as I don’t really want to have to update ALL the records to do this.

Data Updates via Cell Phone

Publication date: August 20, 2018

Please add the ability to send adds and changes via a cell phone.