ContributionsMost RecentMost LikesSolutionsHow to create an Automation that will trigger a script?I want to use the method of creating a trigger field to delete a record but do not want users to be configured to do deletes. I was reading some solutions that talked about having an automation that runs scripts, but when I try to create a new automation there is not an option for running a script. Is this possible? If so, where do I find it? Thanks, DeanRe: How to use the API_EditRecord to make date field blankThanks Coach.Re: How to use the API_EditRecord to make date field blankWell, operator error. I specified the field incorrectly. it needs to be _fid_44=NULL ... this works.How to use the API_EditRecord to make date field blankI need to set aDate/timedate field to blank using the APi_EditRecord and i have not figured it out. I tried _fid44=0, ='', =' ', =NULL, etc. What is the secret sauce? Thanks, DeanRe: How to change Button Labelnice.. now it works perfectly.... since I lost the button I will want to get an image like you were suggesting... thank you very much for all the help. I do not think I could have figured it out.Re: How to change Button Labelshould the field still be a formula url? I am getting this now. https://xx.quickbase.com/db/http:/<a href=javascript:$.get('https:/fixandpaint.quickbase.com/db/bn6bxjm9t?a=API_EditRecord&rid=15&_fid_23=16&apptoken=xxx',function(){location.reload(true);});void(0);><b><font size=+1>Update Status 'In Warehouse'</a> Re: How to change Button Labelhmmm... how would that be integrated with button such that when the button is clicked it runs the api_editrecord?Re: How to change Button Labelthanks for the help.Re: How to change Button Labelsure... I am using a variation of something you suggested in another post. btw... the link works to change the data but I don't know how to use the $buttonLabel? var text nextStatus = Case( [Related status] ,13,"16" ,16,"14" ); var text buttonLabel = Case( [Related status] ,13,"Update Status 'In Warehouse'" ,16,"Update Status 'Ready For Pickup'" ); var text URL = URLRoot() & "db/bn6bxjm9t?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_23="& $nextStatus & "&apptoken=dwnt9wipc3cvfcg6nvd3ba97ps4"; If($nextStatus > "" , "javascript:" & "$.get('" & $URL & "',function(){" & "location.reload(true);" & "});" & "void(0);" ) How to change Button LabelI have an Action button that when clicked changes status. Now, the button says "Action". I would like to have a rule or function that would change the Button Label to something more meaningful... like "Change Status to Ordered" or "Change Status to 'In Warehouse'" based on the current status. Any suggestions on the best way to do that? Of course, I do not want to permanently change the label value, but have it be dynamic based on the data in the record. Thanks, Dean