Trigger on a choice field
Hi to all
I have a button perfectly functioning on a table with this formula:
let x := dialog("Edit", "Edit Release", ["No", "Yes"]);
 if x = "Yes" then
     let xCurrRec := ID;
     let xReleaseNumber := 'Release Number';
     let xArtistID := 'Artist ID';
     let xReleaseArtist := 'Release Artist';
     let xRelease := Release;
 
let myRecord := (select Release where 'Release Number' = xReleaseNumber);
     myRecord.('Release Number' := xReleaseNumber);
     myRecord.('Artist ID' := xArtistID);
     myRecord.('Release Artist' := xReleaseArtist);
     myRecord.(Release := xRelease);
 
openTable("Release", "myRecord")
 end
I would like now to set these instructions on a trigger of a choice field called: Tools
I added the same formula with a new first line:

if Tools = 3 then
let x := dialog("Edit", "Edit Release", ["No", "Yes"]);
 if x = "Yes" then
     let xCurrRec := ID;
     let xReleaseNumber := 'Release Number';
     let xArtistID := 'Artist ID';
     let xReleaseArtist := 'Release Artist';
     let xRelease := Release;
 
let myRecord := (select Release where 'Release Number' = xReleaseNumber);
     myRecord.('Release Number' := xReleaseNumber);
     myRecord.('Artist ID' := xArtistID);
     myRecord.('Release Artist' := xReleaseArtist);
     myRecord.(Release := xRelease);
 
openTable("Release", "myRecord")
 end
end
  
but now nothing is working.
Any suggestions?
Thank You in advance
1 reply
- 
  
Sorry I did not check that is the alert that seem to make problems.
I deleted it and now seems to work
 
Content aside
- Status Answered
 - 2 yrs agoLast active
 - 1Replies
 - 71Views
 - 
    1
    Following
    
 
