Accessing External Data

[egilley]

I am trying to show graphics in a Submission Form, based on specific data, and so i'm inserting HTML block with "if" JS's...

 

They work perfectly when the data is already saved in the current table.  I'm using:

var cb_punchin = '[@field:L1_time_in]';

 

But that doesn't work if the data is coming in from another page into a hidden field in my submission form.  That data hasn't been saved in the current table yet.

 

Is there a way to access saved data from a different table?

Or a way to grab the data from the external data coming in?

 

I'm learning JS in little bites... help with this would be very much appreciated.

 

[MayMusic]

If you are receiving the data from another page not the table source you should be receiving it in this format: [@L1_time_in]

[egilley]

That's it!  OMG that was so easy!  I feel like I should have known that, somehow?!

 

Thank you!

[MayMusic]

You are welcome

[cheonsa]

Hello, 

Just to add in the previous comment, you can use a Select Statement in a Calculated value to get information from the other table. https://howto.caspio.com/datapages/datapage-components/calculated-values/

As per MayMusic's suggestion, you should receive the field as [@L1_time_in]. It means that it is a parameter. Make sure that you also pass the value from the other DataPage. 

https://howto.caspio.com/parameters/parameters/

[Kurumi]

Hi - Just wanted to share this solution. If you would like to get and display a field value/external parameter on an external HTML page, you can follow these steps:

1. Add an HTML code as a holder of the parameter, for example:

<span id="user"></span>

2. Insert a JavaScript, call and display the parameter in the holder.

<script>

const queryString = window.location.search;
const urlParams = new URLSearchParams(queryString);
const userParam = urlParams.get('param');
document.getElementById("user").innerHTML = userParam;

</script>

The param is the name of the parameter from an external URL.

For reference: https://stackoverflow.com/questions/71727647/displaying-url-parameter-values-as-text-in-an-element-on-webpage-question-from