
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 31, 2022 08:09 AM
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
