I have a problem that I’ve been trying to fix since yesterday. I have a repeating group full of job posts. I want to update the expiry date of all jobs posts all at once whenever a page is loaded. I would really appreciate some help. I have attached pictures below to help in better understanding.
On the screenshot above, I have a list of jobs. I need help on how to update the dates on the “Expires on” column for each job to the database whenever the page loads.
Any kind of help will be appreciated.
you can use bulk API to update the" expires on" field using the backend workflows.
or
you can use Database Trigger in backend to update a record when a change is made
if you want help with any of the above methods reply to this message
The main issue is how to extract that data from the repeating group so that I can send it back to the database. I have tried using backend workflows but it did not work
I pulled that data from a jobs scrapping API. After I’ve called the API, I send the results to the database. The API is sending back the job expiry dates in string format instead of dates. I am displaying the data in a repeating group then converting the date strings in date format. The main problem I am having is sending the dates in date format back to the database.
I have attached screenshots below
This screenshot shows how I am converting the date strings from string to date format.
The problem comes in when I try now to send the converted date displayed there as ''stringtodatetime A’s return" back to the database. For some reason I can’t access it.
I hope you understand the problem better.
So I have to call API again? This is going to be a problem since I already have over 2000 jobs on my website and I wanted to find a way to remove all expired job posts without deleting everything.