hello i’m using google sheet but i have problem to embed the tally form.
I want to pass logged-in user data to google sheet.
how can i fix it? I really appreciate it in advance
<script>
let tallyUrl = 'https://tally.so/embed/n99kNp?alignLeft=1&hideTitle=1&transparentBackground=1&dynamicHeight=1';
if(window['logged_in_user'] && window['logged_in_user']['softr_user_email']) {
tallyUrl = tallyUrl + '&record_id=' + window['logged_in_user']['softr_user_email'];
}
document.write('<iframe src="' + tallyUrl + '" width="100%" height="800" frameborder="0" marginheight="0" marginwidth="0" title="My Application"></iframe>');
</script>