zapier - airtable: need alert on changes in data
so we have synced our new sign ups e-mail using zapier. whenever a new user fills in the form, and submits it, we get an e-mail. have created a zap for it.  our sign up form includes an id option. at times people sign up, and add the id to their form later. in this scenario, we get no information or update. have to manually check the airtable sheet to see if the id has been added. is there a way to automate it using zapier? whenever a user updates their entry, we get a e-mail using zapier that the data has been updated? thanks!
hi @checkout,if i was in your shoes. i would create a new view in your airtable for the records with completed ids. the use the airtable trigger “new record in view” select the correct view and create your action email from there.kind regards,https://www.seundebiyi.com/
> 
> i want to create ap application which generates popup alerts at the day of event ocurs as well as a day before the event will occur in a specific time interval as well.. events are stored in database and they are all date fields .. so i want to link those fields to create popups .. help me .
> 
> 
> 


In order to help you, you must first provide us with what you have achieved. We do not write code for you, simply correct and enlighten on mistakes. > Hi pliz assist me, I need a code that can allow the login form to search for pin number stored in another form example when a customer enters the pin number and clicks ok button the login form searches if the pin number exists in the bank details form ..thanx in advance
> 
> 


post code hi david, thank you for question. these are called alerts, and show payments that have come into and out of your account. the cards you see should be dragged and dropped on the slideby grid in the row for that particular customer or supplier (it doesn't matter which date, as slideby will automatically move this to the correct incoming/outgoing payment date). please visit this page to learn more about alerts and how these can be matched to any invoices and estimates you have created. [@thesocialgrowth](/u/thesocialgrowth) you need to enter the “update item & tags” section, write a “message to the reviewer” and then “save changes” to request a new review.

updating details does not trigger a new review, as detail updates do not require approval. well, i raised an issue with id support whom escalated it with engineering or something and it's now working. they did say they'd text me updates and haven't received anything from them so whether they did anything or whether it just started working.. who knows. 

but yeah, looks like the answer is calling / talking to support. hmm.  you can use ticket rules to mute the ticket as soon as it gets created.  you can have it look for tickets from that particular email address and mute them as they come in. tab visibility is currently only based on the user profile sheet. if you want to control tab visibility from a value in another sheet, you need to use relation/lookup, relation/rollup, or single value columns to bring in whatever value you need into the user profile sheet.

[https://docs.glideapps.c…](https://docs.glideapps.com/all/reference/design-and-structure/visibility-conditions#tab-visibility) hi erin

a website restart is required to pickup some changes to settingitems in the portal, id recommend giving it a restart and it should show.

regards
joe Try this:  


```
UPDATE table1
SET
    table1.firstname = table2.firstname,
    table1.lastname = table2.lastname,
    table1.email = table2.email
FROM
    table1 JOIN table2
ON
    table1.userid=table2.userid
``` first of all log in to the ovhcloud control panel. next go to your dashboard and click on “contact management” in the banner on the right.  
on this page click on the pencil icon and enter the new contact details. then confirm your request.

**tips and tricks**  
before configuring or changing any contact details you should state the account users. to do this please go to the “user management” section.