Add multiple records to database using a form with common information.

Ask the community
,
1

The actual detail of what I wish to do is to have a form where the user puts in their details (username, area, etc.) once then can write a list of locations and for that information to be put into a database as individual records. So once submitted they’ll create multiple records each with their details and the individual location they listed.

This database will then be connected to a map that will show each location and the name of the person that locations were added by.

I’d then also like to have buttons which change which records show (based on the area field - but this is for after I have compiled the database

Is this at all possible?
Thanks in advance :slight_smile:

2

Hi,
You can use address input to collect location. Not to show all inputs, you can create a collapsible form (e.g. the user enters one location, clicks plus if he needs another one, and another one expands).
You also need to create a variable to store the information about how many times the plus was clicked. And then create a loop that will make an insert () into the database with a different address field on each iteration.

As for displaying multiple locations in Google Maps, please see the relevant post here .