Is it possible to have multi source repeating group?

Need help
1

is there any way to make repeating group get data from multi source ??

lets say that i have 4 data types ,

1- money used for health
2- money used for food
2- money get from work .
4- money get from selling .

i want to make 1 repeating group for both 4 data types , and sort all using date .

many thanks in advance for your help .

2

Use 4 and hide it based on conditions

3

wont work for me … im trying to make running balance using it .

4

Ok, On your RG provide conditional arguments, when to change the source

image

5

The short answer is no.

Won’t work because the source needs to match the data type.

Consider changing your data structure

Thing: Money

Fields:

  • Amount (number)
  • Type (text)
  • Date (date)
  • Debit/credit (could be yes/no, or for developer clarity can make text)

Then in your repeating group, pull ALL moneys. Do a dynamic sort and you will be able to change the source based on conditionals, filtering by type or by debit (money get) or credit (money used). Your running balance can be easily calculated with :filter for the different types, operators, date ranges. Make sure you learn the “group by” operator as well, I feel it will serve you well in this situation.

2 Likes
6

This topic was automatically closed after 70 days. New replies are no longer allowed.