Form using XANO and drop down foreign key (that populates on page load)

Ask us anything
1

Hello,

I created a form where one drop down menu is linked to my venues (which is a referenced table). I created a variable that loads the most recent venues when the form is loaded. This is all working great.

When I go to submit my form, XANO is looking for the sequential IDs of the venues not the name. However in PREVIEW mode when I select the venues, because I have multiple choice;

  1. It creates a new index for the variables that are not aligned with the original sequential IDs.
  2. When I populate my Get Venues array, the index is there, but instead of getting an venueName: X , id: 0 I am only seeing the venueName as a variable with the Index as a header.
  3. Since the ID is not separated from the venue name I cannot map it as an option in the value per item section.

image
image574×1156 48.2 KB

Lastly, everytime I try to submit my form, even when I remove this venue section, I am getting a success message however it only sends a blank row to Xano (none of my fields are being sent). I originally created my form with the beta AI function because I needed front end design help however I think there are some things here that may need to be fixed.