Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

ISO Date in Prefill form and Email with Prefill link to approver not working

Topic Labels: Integrations
152 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi

If I prefill Event Date using the following URL – It dose’nt populate the date in ISO Format. Please suggest.

URL:

Formula used:

CONCATENATE(‘https://airtable.com/shretOBZs7fKCPqk7’,'?prefill_Business+Ticket+Approver+Email=’, {Business Ticket Approver Email},‘&prefill_Event=’, Event, ‘&prefill_City=’, City, ‘&prefill_State=’, State,‘&prefill_Tickets+Requested=’, {Tickets Requested}, ‘&prefill_’**&**ENCODE_URL_COMPONENT ( ‘Event+Date’ ) & ‘=’ & ENCODE_URL_COMPONENT ( {Event Date} ), ‘&prefill_Venue=’, Venue )

Also I want to send the prefill URL to approver for approvals and I configure email automation the Prefill URL is breaking down to this? Please suggest?

https://airtable.com/shretOBZs7fKCPqk7?prefillBusiness+Ticket+Approver+Email=rama.motwani@wwecorp.com&prefillEvent=CMB&prefillCity=Madison&prefillState=WI&prefillTickets+Requested=10&prefillEvent%2BDate=2022-11-13T00%3A00%3A00.000Z&prefill_Venue=Alliant Energy Center

Thanks

Rama

0 Replies 0