confused making function.. please help me

thomas

hello
i just tried another day to make function like automation in Airtable. but, it's not easy and i'm about to give up..

for the last time, i would like to ask help.

1.situation
i'm building private car care reminder service.
• Table A : carwiki, each car has its own care interval information.• car_id : 1 / washing interval every 3days / and so on
• Table B : mycar, a user add one's own car to get reminder.• mycar_id 1 : user_id 1 / car_id 1 / recent washed day... 
• Table C : reminder, a user gets reminder generated by one's cars interval days• reminder_id 1 : user_id 1 / car_id 1 / next car washing day... 



2. Problem im facing
i wanna know how to set up function to generate reminder automatically with function. because i have no idea how to fetch each cars interval using relation in function stack maker. 

i tried like this
1. input : myplant info (from frontend.)

     : user_id, car_id, recent washed day...
2. calculation ---- this step, i can't load interval days from car_id table. i have no idea how to to day with data relation in function stack..
3. create record --- still.. cannot do that. it's too hard.

please let me know more details steps... 

once i get what i have to do by steps, i even can make a tutorial videos for people like me who are not really used to backend system.

Sean Montgomery

Hey ,

If you have something this specific, then I recommend you join office hours, so we can walk through this in person. We do this twice per week and help everyone who joins. All you need to do is show up and participate with the group.

https://calendly.com/xano/officehours