Hi,
Iโm trying to pull in 3 data sets from โBusinessโ table by <Start:Business><<[Business name]>><< End>> from an โApplicationโ table. I have the below set up.
Any suggestions?
Hi @LeventK thank you for this. I had to restructure my data to be able to pull things from tables. And I have actually learned some limitation of the < < Start > > like the formula is only working horizontally. My question though is why does it erase data from the table where I pull in data from when I delete the key, which is my entry, in โApplicationโ table. Hereโs how the structure looks like.
The above is my application table where I choose โClient Idโ and serves as the key as well.
The above is the table where I pull data from.
The data in the โBusinessโ table gets erased when I delete an an entry in my โApplicationโ table.
This workflow works like the below:
Any help will be appreciated. Thanks.
@MEC
Please check and verify if your ref column is set with isPartof property set to ON. If so, when you delete a parent record, related child records are erased as well.
@LeventK Thank you for your help. Working perfectly now!
Youโre welcome. Glad to hear that you have solved the issue.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |