Submit Button

Yeah, I know.

Not too sure if im trying to add too many fields in the string, the 'Name' field populates and so does the 'reference', but not 'Toolbox Talks'.'Toolbox Talk Title Subject'?

ive even made some changes as below to see if that works, but still not inserting...

let X := Subject;
let myField := Reference;
if cnt(select SignedList where Reference = myField) > 1 then
alert("Our records show that you have already signed this toolbox talk, no duplicate record can be created");
delete this;
sendEmail({
from: "****@****",
to: userEmail(),
subject: "Tritec Tool Box Talk Record: " + X,
text: "Hi " + Name + " You have tried to submit your electronic signature for a toolbox talk which our records show you have already signed, if you feel that you have NOT signed this previously then please contact management, Thank you."
})
else
sendEmail({
from: "****@****.com",
to: userEmail(),
subject: "Tritec Notification - Tool Box Talk Records",
text: "Thank you " + Name + " for reading and submitting your " + X + " toolbox talk, your unique refrence number is " + Reference
})
end

EMAIL REPONCE WHEN SENT:

Thank you Terry for reading and submitting your toolbox talk, your unique refrence number is p465eFKo7cfaYBkrCTT11

Thank you Terry for reading and submitting your ( MISSING 'Subject' Field) toolbox talk, your unique refrence number is p465eFKo7cfaYBkrCTT11

I think where my formula is creating a new record in 'SignedList' is not linking the two table together as it normally woudl do if i select it from a 'Link From' field as this field is now empty on the new record that is creates, any one know a work around for this?

BUTTON FORMULA:

let p := (create SignedList);
let t := TTRef;
let s := 'Toolbox Talk Title Subject:';
let result := dialog("THANK YOU!", "You have signed this tool box talk document and it will be added to our records.", ["OK"]);
p.(Name := userName());
p.(Job := "Test");
p.(Reference := userId() + t);
p.(Subject := s);
p.(Date := now());
p.(Time := now());
p.(Location := longitude(Location));
p.(Loc := latitude(Location));
if result = "OK" then Status := "Signed" end

You're a gent and scholler Steven, I appreacite your help on this.

Hi Steven, 

Not too sure if you can help, but i have the following formula as 'Trigger after update' in the 'SignedList.Reference' field, which is to stop duplicate records being created. Once they have signed I am looking to send the user an email a a reciept and record.

However the 'Toolbox Talks'.'Toolbox Talk Title Subject:' will not add to the email text. although the 'Name' and 'Reference' fields do.

Do you have any ideas?

Thank you.

let myField := Reference;
if cnt(select SignedList where Reference = myField) > 1 then
alert("Our records show that you have already signed this toolbox talk, no duplicate record can be created");
delete this;
sendEmail({
from: "terry@tritec-ltd.com",
to: userEmail(),
subject: "Tritec Tool Box Talk Record: " + 'Toolbox Talks'.'Toolbox Talk Title Subject:',
text: "Hi " + Name + " You have tried to submit your electronic signature for a toolbox talk which our records show you have already signed, if you feel that you have NOT signed this previously then please contact management, Thank you."
})
else
sendEmail({
from: "terry@tritec-ltd.com",
to: userEmail(),
subject: "Tritec Notification - Tool Box Talk Records",
text: "Thank you " + Name + " for reading and submitting your " + 'Toolbox Talks'.'Toolbox Talk Title Subject:' + " toolbox talk, your unique refrence number is " + Reference
})
end

Managed to sort it, just changed the name of the field from 'Subject' to anything else and it worked?

Managed to sort it, just changed the name of the field from 'Subject' to anything else and it worked?