Blog  |  Support  |  Forums

Search Results for 'form.getRecords'

Tap Forms – Organizer Database App for Mac, iPhone, and iPad Forums Search Search Results for 'form.getRecords'

Viewing 15 results - 16 through 30 (of 148 total)
  • Author
    Search Results
  • #50249
    Daniel Leu
    Participant

    This works for me:

    function toHrsMin(sec){
       let h = Math.floor(sec / 3600);
       let m = (sec / 60) % 60;
       return h + ' hr, ' + m + ' mins';
    }
    function Accum_Tot() {
       var records = form.getRecords();
       var currentRecordIndex = records.indexOf(record);
       if (currentRecordIndex > 0) {
          var previousRecord = records[currentRecordIndex-1];
      var previous_total = previousRecord.getFieldValue('fld-44acc9d2314f41beb3f2257ace5bae01');
       } else {
          var previous_total = 0;
       }
       var today = record.getFieldValue('fld-44acc9d2314f41beb3f2257ace5bae01');
       var total = today + previous_total;
       console.log("Today: " + toHrsMin(today))
       console.log("Previous: " + toHrsMin(previous_total))
       console.log("Total: " + toHrsMin(total))
       return total;
    }
    Accum_Tot();
    • This reply was modified 12 months ago by Daniel Leu.
    • This reply was modified 12 months ago by Daniel Leu.
    • This reply was modified 12 months ago by Daniel Leu.
    • This reply was modified 12 months ago by Daniel Leu.
    • This reply was modified 12 months ago by Daniel Leu.
    • This reply was modified 12 months ago by Daniel Leu.
    • This reply was modified 12 months ago by Daniel Leu.
    #50176
    Fernando DS
    Participant

    At last this is the script that works:

    function modifyFieldsBasedOnCondition() {
    var fieldId1 = ‘fld-28b97ce8ab4f4f57a83aefa7e91f17fe’;
    var fieldId2 = ‘fld-c2fd26ae62c1445692b3a0abc1e89158’;

    for (var record of form.getRecords()) {
    var valueField1 = record.getFieldValue(fieldId1);
    var valueField2 = record.getFieldValue(fieldId2);

    if (valueField1 === 4 && (valueField2 === null || valueField2 === “”)) {
    record.setFieldValue(fieldId2, “Buen disco.”);
    console.log(“Campo fieldid2 actualizado en el registro con campo fieldid1 igual a 4 y fieldid2 vacío.”);
    }
    }

    form.saveAllChanges();
    }

    modifyFieldsBasedOnCondition();

     

    Thank you Brendan and Daniel for your valuable help.

    Bye.

     

    #50169
    Daniel Leu
    Participant

    This works for me:

     function modifyFieldsBasedOnCondition() {
    
    var fieldId1 = 'fld-28b97ce8ab4f4f57a83aefa7e91f17fe';
    var fieldId2 = 'fld-c2fd26ae62c1445692b3a0abc1e89158';
       for (var record of form.getRecords()) {
          console.log(record.getFieldValue(fieldId1));
          console.log(record.getFieldValue(fieldId2));
          if (record.getFieldValue(fieldId1) == 4 &&
             record.getFieldValue(fieldId2) == undefined)
          {
             record.setFieldValue(fieldId2, "Buen disco.");
             console.log("empty record found");
          }
       }
       form.saveAllChanges();
    }
    modifyFieldsBasedOnCondition();
    • This reply was modified 1 year, 1 month ago by Daniel Leu.
    • This reply was modified 1 year, 1 month ago by Daniel Leu.
    • This reply was modified 1 year, 1 month ago by Daniel Leu.
    • This reply was modified 1 year, 1 month ago by Daniel Leu.
    • This reply was modified 1 year, 1 month ago by Daniel Leu.
    #50167
    Fernando DS
    Participant

    Just another try, without errors in console, but not works.

    function modifyFieldsBasedOnCondition() {
    var fieldId1 = 'fld-28b97ce8ab4f4f57a83aefa7e91f17fe';
    var fieldId2 = 'fld-c2fd26ae62c1445692b3a0abc1e89158';
    
    for (var record of form.getRecords()) {
    if (record.getFieldValue(fieldId1) == 4 &&
    record.getFieldValue(fieldId2) <= (0))
    record.setFieldValue(fieldId2, "Buen disco.");
    }
    }
    
    form.saveAllChanges();
    
    modifyFieldsBasedOnCondition();
    • This reply was modified 1 year, 1 month ago by Brendan.
    #50160
    Fernando DS
    Participant

    Well, I’m going to paste it here.

     

    function modifyFieldsBasedOnCondition() {
    var fieldId1 = 'fld-28b97ce8ab4f4f57a83aefa7e91f17fe';
    var fieldId2 = 'fld-c2fd26ae62c1445692b3a0abc1e89158';
    
    for (var record of form.getRecords()) {
    if (record.getFieldValue(fieldId1) == 4 &&
    record.getFieldValue(fieldId2) == "") {
    record.setFieldValue(fieldId2, "Buen disco.");
    }
    }
    
    form.saveAllChanges();
    }
    
    modifyFieldsBasedOnCondition();
    • This reply was modified 1 year, 1 month ago by Brendan.
    #50104

    In reply to: Javascript Help

    Daniel Leu
    Participant

    In my case, the checkbox field is called ‘selected’. You just need to assign the field id of field Added_to_VR-Mailing on line 3 of the code below.

    // This script selects all records
    
    function selectAll(){
    const selected_id = 'fld-xxxx';
    var records = form.getRecords();
    
    for (var index = 0, count = records.length; index < count; index++){
    var myRec = records[index];
    myRec.setFieldValue(selected_id, true);
    }
    
    document.saveAllChanges();
    }
    
    selectAll();

    The code loops over all records and sets the checkbox value to true.

    • This reply was modified 1 year, 1 month ago by Daniel Leu.
    • This reply was modified 1 year, 1 month ago by Daniel Leu.
    • This reply was modified 1 year, 1 month ago by Daniel Leu.
    #50016

    In reply to: Open record as result

    Daniel Leu
    Participant

    I got it working after some edits. It shows as well that form.selectRecord(someRecord); works :). The issue was results vs results_name. The former contains the found records while the latter contains the matching names.

    A remaining issue is when you get more than one match. Since you match on the name and then use results_name.indexOf(name) to find the index, you will always stop at the first found entry. This needs some refinement.

    //var myForm = document.getFormNamed(‘Test’);
    //var records = myForm.getRecords();
    var records = form.getRecords();
    var search_term = Utils.copyTextFromClipboard();
    var result_count = 0;
    var results = [];
    var results_name = [];
    var selected;
    function show_name( name ) {
        form.selectRecord(name);
    }
    function copy_result_multiple( name ) {
        if ( name == true ) {
        let index = results_name.indexOf(selected);
            console.log( 'Index:' + index );
            console.log( results_name[index]);
            show_name( results[index]);
        } else {
            console.log( 'Cancelled' );
        }
    }
    function multiple_results( all_results ) {
        let prompter = Prompter.new();
        prompter.cancelButtonTitle = 'cancel';
        prompter.continueButtonTitle = 'Show Name';
        prompter.addParameter('Select Result ', 'selected', 'popup', results_name)
        .show('Multiple Results Found', copy_result_multiple );
    }
    function search_records( haystack , needle ) {
    var name_id = 'fld-5ecd60d90a8246f4853175f6fc6aaabe';
    //var name_id = 'fld-1acb38c0b51b44698849501407b51722';
        var rec;
        for (rec of haystack) {
        var name = rec.getFieldValue( name_id );
        if (name && name.includes( needle ) ) {
                results.push( rec );
                results_name.push( rec.getFieldValue( name_id ) );
                result_count++;
            } else {
            if (! name) {
           console.log("Empty field: " + rec.getUrl());
            }
            }
        }
        if( result_count == 0 ){
            Utils.alertWithMessage("No Results", "No results were found for the search term: " + needle);
        } else if ( result_count > 1 ){
            //multiple results
            console.log("Found " + result_count + " matches");
            multiple_results( results );
        } else {
            //single result
            console.log("Found one match");
            show_name( results[0] );
        }
    }
    search_records( records , search_term );
    • This reply was modified 1 year, 2 months ago by Daniel Leu.
    • This reply was modified 1 year, 2 months ago by Daniel Leu.
    • This reply was modified 1 year, 2 months ago by Daniel Leu.
    • This reply was modified 1 year, 2 months ago by Daniel Leu.
    • This reply was modified 1 year, 2 months ago by Daniel Leu.
    #50008

    In reply to: Open record as result

    David Gold
    Participant

    Hi Daniel (or OP)

    I would like to be able to do this also. I have some code below (not sure exactly how to insert a code block). I’m trying to do what you’ve said in line 11 with function show_name. Basically I want to be able to search the name field and when I get a result (whether multiple or single by selection in prompter) it then opens the record in Tap Forms. Can you tell me how to make it work?

    Really appreciate any help as my javascript knowledge is limited.

    var myForm = document.getFormNamed(‘Test’);
    var records = myForm.getRecords();
    var search_term = Utils.copyTextFromClipboard();
    var result_count = 0;
    var results = [];
    var results_name = [];
    var selected;
    function show_name( name ) {
        form.selectRecord(name[0]);
    }
    function copy_result_multiple( name ) {
        if ( name == true ) {
            console.log( ‘Index:’ + results.indexOf( selected ) );
            console.log( results_name[ results.indexOf( selected ) ] );
            show_name( results_name[ results.indexOf( selected ) ] );
        } else {
            console.log( ‘Cancelled’ );
        }
    }
    function multiple_results( all_results ) {
        let prompter = Prompter.new();
        prompter.cancelButtonTitle = ‘cancel’;
        prompter.continueButtonTitle = ‘Show Name’;
        prompter.addParameter(‘Select Result ‘, ‘selected’, ‘popup’, all_results)
        .show(‘Multiple Results Found’, copy_result_multiple );
    }
    function search_records( haystack , needle ) {
    var name_id = ‘fld-1acb38c0b51b44698849501407b51722’;
        var rec;
        for (rec of haystack) {
        var name = rec.getFieldValue( name_id );
        if (name && name.includes( needle ) ) {
                results.push( rec.getFieldValue( name_id ) );
                results_name.push( rec.getFieldValue( name_id ) );
                result_count++;
            } else {
            if (! name) {
            console.log(“Empty field: ” + rec.getUrl());
            }
            }
        }
        if( result_count == 0 ){
            Utils.alertWithMessage(“No Results”, “No results were found for the search term: ” + needle);
        }else if( result_count > 1 ){
            //multiple results
            multiple_results( results );
        }else{
            //single result
            show_name( results_name[0] );
        }
    }
    search_records( records , search_term );
    #49998
    David Gold
    Participant

    I’ve had a go at it cutting and pasting from some other scripts but can’t work out why it’s not working. Am getting an error in the console saying:

    var myForm = document.getFormNamed(‘Boral’);
    var records = myForm.getRecords();
    var search_term = Utils.copyTextFromClipboard();
    var result_count = 0;
    var results = [];
    var selected;

    function copy_name( name ) {
    Utils.copyTextToClipboard( name );
    }

    function multiple_results() {

    var joined = ‘–multiple_matches–‘;
    var res;
    for (res of results) {
    joined = joined +
    res.name;
    }
    copy_comments( joined );
    }

    function search_records( haystack , needle ) {

    var name_id = ‘fld-1acb38c0b51b44698849501507b51722’;
    var rec;

    for (const rec of haystack) {
    if ( rec.getFieldValue( name ).toLowerCase().includes( needle.toLowerCase() ) ) {
    results.push( { location: rec.getFieldValue( name_id ) } );
    result_count++;
    }

    }

    if( result_count == 0 ){
    console.log( ‘No results found!’ );
    }else if( result_count > 1 ){
    multiple_results();
    }else{
    copy_name( results[0].name );
    }

    }

    search_records( records , search_term );

     

    • This reply was modified 1 year, 2 months ago by David Gold.
    #49866
    Brendan
    Keymaster

    Hi Brian,

    I think this will take a bit of work. There is an API called record.addRecordToField(someRecord, field_id); in Tap Forms. You’ll need to call that to add the record to your Link to Form field.

    Now the tricky part is to get the record that you need from the linked form. That would be the someRecord in the above API.

    You will also probably need to use the var records = form.getRecordsForSearchTerm("search term"); API call. Now, the form you use will need to be the Link to Form field’s form. So to get that, you’ll need to call the document.getFormNamed('My Movie Library'); API and assign it to a variable (not named form).

    For example:

    var link_to_form_field_id = 'fld-......';
    var linkedForm = document.getFormNamed('Linked Form');
    var records = linkedForm.getRecordsForSearchTerm("some unique course code");
    var linkedRecord = records[0]; // assuming your course code is unique you'll get just one record back
    record.addRecordToField(linkedRecord, link_to_form_field_id);
    form.saveAllChanges();
    

    Hopefully that’ll get you what you need. I haven’t tested this code (just off the top of my head), but it should generally work. You may need to do some testing to check to see if you actually get records back.

    • This reply was modified 1 year, 3 months ago by Brendan.
    #49839

    In reply to: Convert 2 fields

    Brendan
    Keymaster

    There’s no function getSelectedRecords(). There is a form.getRecords(); function though.

    The current record can be obtained by simply referencing record.

     

    So get rid of the var record = form.getSelectedRecords()[0]; statement.

    For "sourceField" you’ll need to put in the field ID of the field you want to get the value from. Tap Forms will display the field ID when you select it. Or just select the field and click the ID button to have Tap Forms generate the line of code for you.

    Also there’s no record.save() function. You want to use form.saveAllChanges() instead.

    #49794
    Daniel Leu
    Participant

    In one of my forms, I encountered an issue of  missing parents. The contact field should contain the infos from the parent. This form script loops over all records of a form and checks if the contact field contains records. If no record is found (eg, length == 0), I set the select field. Afterwards, I can use a smart filter to find all these records where the select field is set to 1. This way, I can verify that these records are indeed the once I want to delete. Maybe this helps you!

    function Select_No_Contact_Parent() {
    
       const contact_id = 'fld-xxx';
       const select_id = 'fld-xxx';
       for (rec of form.getRecords()){
         let contacts = rec.getFieldValue(contact_id);
          if (contacts.length == 0) {
           rec.setFieldValue(select_id, true);
          }
       }
       document.saveAllChanges();
    }
    Select_No_Contact_Parent();
    • This reply was modified 1 year, 4 months ago by Daniel Leu.
    • This reply was modified 1 year, 4 months ago by Daniel Leu.
    • This reply was modified 1 year, 4 months ago by Daniel Leu.
    #49127
    Daniel Leu
    Participant

    Re: Form script:

    You just need to loop over all your records and then assign the values on each one:

    
    function wc_attributes_update() {
    
      // definitions
      var year_id = 'fld-bcf37649c9ee4332b7100a9589110f96';
      ....
    
      for (rec of form.getRecords()){
        rec.setFieldValue(attribute_3_value_s_id, model);
        rec.setFieldValue(attribute_4_value_s_id, gauge);
        rec.setFieldValue(attribute_5_value_s_id, container);
        rec.setFieldValue(attribute_6_value_s_id, era);
        rec.setFieldValue(attribute_7_value_s_id, railroad);
        rec.setFieldValue(attribute_8_value_s_id, brand);
        rec.setFieldValue(attribute_9_value_s_id, collection);
        rec.setFieldValue(attribute_10_value_s_id, tca_grade);
      }
      form.saveAllChanges()
    }
    
    wc_attributes_update();    
    

    This example works on all the records. If you only want to update the ones from a saved search, you might use form.getSearchNamed('Genre: Action & Adventure').

    #49097

    In reply to: Simple previous

    Daniel Leu
    Participant

    I don’t really understand what you would like to calculate. But here are my 2 cents:

    You get the error:
    > “Tot$/dwr: ReferenceError: Can’t find variable: previousRecord_total, line:(null)”
    because the variable previousRecord_total is not defined. It should be previousTotal and the statement should be a line lower.

    > var previous_total = previousRecord.getFieldValue($_grp);`
    getFieldValue() needs a field id and not a value.

    For the previous calculation, the field id is the id of the script. You can get it from the form inspector panel > field > select field and look for the ID under the description section.

    I would change as well how the first initial value for currentRecordIndex == 0 is handled:

    var previous_total = 0;
    if (currentRecordIndex > 0) {
       var previousRecord = records[currentRecordIndex-1];    
       previous_total = previousRecord.getFieldValue(totalId);
    }
    

    Now previous_total is initialized to 0. If there is an earlier record, it is set accordingly.

    With these changes, my field script now looks like this:

    function Add_Previous() {
        var $_dwr = record.getFieldValue('fld-c1faad7124f8400bbf9e55c477b101ef');
        var $_grp = record.getFieldValue('fld-72156bcc2515453d80a4649d30cb938f');
        var totalId = 'fld-9bc44cd8a52547fcab897dbfa04afcc2';
    	
        var records = form.getRecords();   // calls function getRecords()
        var currentRecordIndex = records.indexOf(record);
    
        var previous_total = 0;
        if (currentRecordIndex > 0) {
           	var previousRecord = records[currentRecordIndex-1];    
           	previous_total = previousRecord.getFieldValue(totalId);
        }
        
        console.log("dwr: " + $_dwr);
        console.log("grp: " + $_grp);
        console.log("previous total: " + previous_total);
       	
        var total = $_dwr + previous_total;	
        console.log("Total: " + total);
    	
        return total;
    }
    
    Add_Previous();

    Hope this helps!

    #48974

    In reply to: days between dates

    Daniel Leu
    Participant

    I got several errors when I tried to run your code. This touched-up version works for me:

    var date_id = 'fld-xxx';
    
    function Days_Between_Dates(){
    	console.log("Days_Between_Dates() called ...");
    
    	var days = -1;
    	var records = form.getRecords(); // calls function getRecords()
    	var currentRecordIndex = records.indexOf(record);
    
    	if (currentRecordIndex > 0) {
    		var previousRecord = records[currentRecordIndex-1];
    	} else {
    		return -1;
    	}
    
    	// get the two dates
    	const today = record.getFieldValue(date_id);
    	const previous_day = previousRecord.getFieldValue(date_id);
    	
    	// calculate the difference between the two date objects
    	days = Math.round((today - previous_day) / (1000 * 60 * 60 * 24));
    
    	console.log("today: " + today)
    	console.log("previous day: " + previous_day)
    	console.log("difference: " + days)
    	
    	return days;
    }
    
    Days_Between_Dates()

    In Javascript, the Date object represents the time in milliseconds since January 1, 1970, UTC. So the difference needs to be divided by milliseconds-per-day.

    I changed the return value to -1 for the first record.

    When reporting a syntax error, it’s helpful to have the entire message.

    When posting code, please encapsulate it in back-ticks. This way it is easier to copy&paste it and it looks prettier. Thanks!

    Cheers & happy hacking!

    • This reply was modified 1 year, 10 months ago by Daniel Leu.
Viewing 15 results - 16 through 30 (of 148 total)
 
Apple, the Apple logo, iPad, iPhone, and iPod touch are trademarks of Apple Inc., registered in the U.S. and other countries. App Store is a service mark of Apple Inc.