Need first name and last name fields in softr to export to embedded acuity scheduling form

Ask the community
1

Preformatted textThe embedded form code I’m using

is:

<script>
let acuityUrl = 'https://app.acuityscheduling.com/schedule.php?owner=16320413&ref=embedded_csp"';

if (window['logged_in_user']) {
  acuityUrl += '&firstName=' + encodeURIComponent(window['logged_in_user']['softr_user_full_name']);
  acuityUrl += '&last_name=' + encodeURIComponent(window['logged_in_user']['last_name']);
  acuityUrl += '&email=' + encodeURIComponent(window['logged_in_user']['softr_user_email']);
  // Add more fields as needed
}

const iframe = document.createElement('iframe');
iframe.src = acuityUrl;
iframe.style.width = '100%';
iframe.style.height = '800px';
iframe.style.border = 'none';
iframe.title= 'Schedule Appointment'
document.currentScript.parentNode.insertBefore(iframe, document.currentScript.nextSibling);
</script>
<script src="https://embed.acuityscheduling.com/js/embed.js" type="text/javascript"></script>

The code works BUT obviously pastes the logged in user’s full name in the first name field in Acuity.

Ignore the current last name line as it’s not yet right.

The email field does work!

What I need is a first name field and last name field for the logged in user in softr. I’ve been told by softr support that the user name field can’t be broken down to first and last names and I can’t map the user name field to a concatenated field in AirTable, can only map to a text field. What parameters in softr can I use to make my form code prefil my acuity form with the first name and last name pf the logged in user. By the way, I asked Acuity if I could edit there scheduling form and use a full name field instead of a first name field and last name field and unfortunately, that form is not editable. So, I have first name and last name fields in Acuity but only a full name field in Softr. Please help!

2

Hi! can you try this?

{LOGGED_IN_USER: yourFieldName} is supported for getting logged-in user data. So find the field names for your first and last name, and update accordingly.

3

The AirTable field names are firstName and lastName. I tried acuityUrl += '&firstName=' + encodeURIComponent(window['logged_in_user']['LOGGED_IN_USER:firstName']); and acuityUrl += '&firstName=' + encodeURIComponent(window['logged_in_user']['{LOGGED_IN_USER:firstName}']); Neither worked. Coding isn’t my sstrong point, as you can guess.

4

Might I suggest using our conditional forms instead? And then sending those results to your automation / API call so you can get the exact details you need without coding? It’s not my strong suit either!!

5

Unfortunately, I don’t have conditional forms in my plan.

6

Can you try this:

<script>
let acuityUrl = 'https://app.acuityscheduling.com/schedule.php?owner=16320413&ref=embedded_csp';

if (window['logged_in_user']) {
  let firstNameData = window['logged_in_user']['FirstName'] || '';
  let lastNameData = window['logged_in_user']['LastName'] || '';
  let emailData = window['logged_in_user']['softr_user_email'] || '';

  acuityUrl += '&firstName=' + encodeURIComponent(firstNameData);
  acuityUrl += '&lastName=' + encodeURIComponent(lastNameData);
  acuityUrl += '&email=' + encodeURIComponent(emailData);
}

const iframe = document.createElement('iframe');
iframe.src = acuityUrl;
iframe.style.width = '100%';
iframe.style.height = '800px';
iframe.style.border = 'none';
iframe.title = 'Schedule Appointment';
document.currentScript.parentNode.insertBefore(iframe, document.currentScript.nextSibling);
</script>
<script src="https://embed.acuityscheduling.com/js/embed.js" type="text/javascript"></script>

To be inserted in the header custom code of the page settings.

Also, do a test in live mode, not only within the preview mode.

In these two lines below, careful, FirstName and LastName are the exact field names in my users table. You would need to change your airtable fields “firstName” and “lastName” by “FirstName” or “LastName” – Or any other field names that are not firstName or lastName – otherwise it will mess everything up.

  let firstNameData = window['logged_in_user']['FirstName'] || '';
  let lastNameData = window['logged_in_user']['LastName'] || '';
7

Please try but If any problem, I can go to your Softr workspace and solve it in one minute.