Apr 13, 2020 10:40 AM
I have a form that people register for a service. The registration is for 3 years. So when the customer comes back in 3 years to renew how can i handle this in my airtable database? Wont it have 2 entries the samenif this happens?
Apr 13, 2020 11:20 AM
Hey there! You would probably want to split this up like so:
Table 1: Customer details
Table 2: Subscription details
Then lookup the customer when they subscribe for the second time and you’ll then be able to see subscriptions split out by customer
Hope that makes sense
Apr 13, 2020 11:46 AM
Hi, tnx for the reply. U mean create 2 grids? One customer and one subscriptions? And the form which the people fill out to be the subscriptions form?
Wheb h say lookup you mean apply filter?
Apr 13, 2020 12:22 PM
I’m not sure what you mean by grids.
When I say lookup you would likely want to perform a lookup with an automation tool like Zapier.
Apr 13, 2020 01:34 PM
Ok tnx. Do the form the customers complete and submit will be connected to the customer table yes?
Then when they come back to renew they will use the same form. So how is the other table (subscription table) going to be populate d?
Apr 13, 2020 01:45 PM
Yes -That’s correct
And that’s definitely one way they can renew, but you may want to manage that using a renewal process rather than a form. Forms are normally recommended for an initial sign up only
Apr 13, 2020 02:53 PM
Tnz so much.can u indicate me how i can make a renewal process?
Apr 14, 2020 08:29 AM
You can access all entries within the WordPress admin area. To do this, hover over the WPForms link in the left sidebar and click on Entries in the menu. To view the entries of a specific form, you can click on that form’s title
Apr 14, 2020 08:41 AM
Tnx. But i mean in airtable. J dont use WordPress