Sum Issue

Get Help
1

Hi Guys,
I am doing Sum by adding 4 fields by creating this formula in input1+input2+input3+input4. So i am getting the solution in Preview mode ,but when i am sharing my app there it is not working.
(All feilds are converted in number format so not text is there)

image
image428×349 9.73 KB

Cache Memory
2

Hi @bhaveshsood,

Would you be able to include a screen recording showing the behavior?

Thank you and have a great day!

3

Hi Dilon,
Thanks for quick reply. This is the video,in the starting I started with Preview Look
This is the video link
https://drive.google.com/file/d/1bnOq0rAKHJcIxz5b_y-vIfe-XnUH64gy/view?usp=sharing.

Looking forward for the solution

4

Hi @bhaveshsood,

Thanks for the video!

If this is a published app, did you published changes through the publish tab? Would you be able to share a quick screen recording showing that screen setup?

Thank you and have a great day!

5

Hi Dilon,
Well the app is not published yet, the work is still in progress. This issue I am facing while developing.

6

Hi @bhaveshsood,

Thanks for the information!

Would you be able to share a quick screen recording showing that screen setup?

Thank you and have a great day!

7

Hi Dilon,
Sorry for the late reply, let me know when you are free so that we can set up a small video call, and you can quickly check and help me out what is the issue. In the meantime , I am sharing this video so that you can check it out also like the layout and formula. As per the Indian time you can tell I am available most of the time.And from yesterday the old data or cache memory is popping in random places of my app. WHich is troublesome because if it shares some confidential data it might be problematic. (even as user is entering dummy data in prototype version)
https://drive.google.com/file/d/1-rlmHucvzT2xbW2zNm6OCSC01zVq_nqQ/view?usp=sharing

Thank you for helping out

8

Hi @bhaveshsood,

Thanks for the video!

What is the formula added in the bottom input? Same SUM formula? It might be due to app cache, have you tried the custom formula in a text property? You want the user to edit the sumed value which you used an input? (you could use the change input value action to clear that input value before and then once adding values to other inputs should bring the sum into that input)
Also you want everytime a new user record which you make them signup instead letting them access their previous account through login? And also I saw that you have added the same visibility condition to the input + group which you can only keep in group level.

Thank you and have a great day!

9

Hi Dilon,

Use case:

I am building an asset distribution system where a user can assign a percentage of their assets to multiple nominees. The total allocation must equal 100%.

Flow:

  1. The user selects the number of nominees (e.g., 3 nominees).

  2. For each nominee, the user enters a percentage value (e.g., 40%, 30%, 30%).

  3. A “Proceed” button should only be visible when the total allocation equals 100%.

  4. If the total is not 100%, a message should appear:
    “100% allocation is not completed.”

Current setup in Adalo:

  • I am using a input field and putting this formula:
    Box1% + Box2% + Box3% + Box4% = 100
    as a visibility condition for the button.

  • Previously, I also used visibility conditions to show/hide nominee input fields based on how many nominees the user selects.

The problem:

The Sum formula does not always working.

This behavior feels similar to a “cache” issue, but I cannot ask real users to clear their cache before using the app.

Interestingly, the issue occurs far less frequently (around 96–98% success rate) when I remove visibility conditions from the nominee input fields. However, I would prefer to keep those visibility rules for a cleaner UI.

What I tried:

  • Publishing the app — the issue still occurs.

  • Removing visibility conditions from nominee fields — the issue reduces but does not fully disappear.

Expected behavior:

Please let me know if this is a known limitation or if there is a recommended workaround.

Thanks,
Bhavesh

10

Hi Bhavesh,

Thanks again for sharing information!

Upon checking your setup, I guess the issue would be the visibility condition as it’s based on a m2m relation count and it’s best to have a number property as a logged in user property (logged in user number property + 1) to keep it increasing upon adding each nominee (update logged in user action after the create action) which then you can use that property in those visibility conditions.(Five Tips for Improving Your Adalo App Performance | Adalo Blog) Try that and let here know!

Thank you and have a great day!

11

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.