Caching data points that have not been submitted yet

Hello everyone,

:warning:This might be a bit confusing, but please bare with me.

So basically, I have two forms A and B.

1- Form B has a reference field that references a specific field in Form A.

2- Form A also has a reference field to Form B.


Action:

While filling Form A, I want to press “add record in Form B”.

This would naturally take me to fill Form B, BUT remember that Form B also has a field that is referenced from Form A.

I want to be able to choose the data that I had just collected in Form A (not submitted) to put it in Form B in the reference field.

The issue with references is that they only show you data that has already been submitted.


Would it be possible to request this as a feature? A way of “Caching” the data while doing entry in between two forms simultaneously ?

I will look forward to any feedback on this.

Thanks!

Hello Ahmed,

We acknowledge receipt of this feature request.

Could you please share more information about the use case, workflow, or scenario where this feature would be useful?

This will help us fully understand what it would entail, including any specific requirements, expected outcomes, or constraints we should consider.

Thanks,

Timothy

Hi Timothy,

Thanks for taking this into account.

I will provide a use case below.

Let us say we have two databases.

1 - Database A registers “Participants”

2 - Database B registers “Training sessions”

I am registering a person that is attending one of our training sessions, and so naturally I would use form A to do that.

For us to know which individuals attended which training session we have a reference field in form A that asks for the Training ID in form B ( or any other detail of that training).

However, as a user I have not added that training into database B, and so intuitively, when I come across the reference field in A I would just “press add record in form B” and it would take me to form B to fill it.

Here is the catch :hook:

Form B also has a reference field to A and asks for the Individual ID that attended that specific Training, but since the individual is not yet registered in A, I cannot find their ID in the reference field.

This entails generating the ID of a record before it gets submitted and also keeping the data saved somewhere before submission.

I hope this makes sense.

If not, I would be glad to provide more details.

Best,