You’re offline. This is a read only version of the page.
100
Hi,
I want to flow a field from Table1 to Table2 based on few conditions and display it in a list page which is based on Table2.
I wanted to create the field has a flowfield but the 'conditions' for the field fetches more than 1 record. I suppose, we cannot just show the first record field value from the filter conditions using a flowfield?
Should i rather create field has a variable in page and populate it onopen/onaftergetrecord of the page?
or create physical field in the table and populate it onopen/onaftergetrecord, which is the best approach for this?
Thanks
Johnson Patrick
but why though? when i have flowfield defined on the table.
You can use Calcfield on OnAfterGetRecord trigger of that page.
Hi,
Thanks for your reply. The two mentioned approaches doesnt work for me, as i need the value to the physically stored in the table and trying to fetch all the values onpageopen was causing me too much delay in opening the page.
I followed the flowfield Lookup method and even though the conditions on the FF fetched multiple records, it always displayed the field of interest on the first record.
See below my code for the FF :
Hi,
If the conditions for the field in Table2 fetch more than one record from Table1, creating a flowfield might not be suitable. Here are two alternative approaches you can consider:
Create a field as a variable in the page: You can create a variable in the page and populate it with the desired value during the OnOpen or OnAfterGetRecord trigger of the page. This approach allows you to control the logic and fetch the specific value based on your conditions.
Create a physical field in Table2: Another option is to create a physical field in Table2 and populate it during the OnOpen or OnAfterGetRecord trigger of the page. This approach stores the calculated value in the table itself, allowing you to reuse it without recalculating each time.
The choice between these two approaches depends on factors such as the complexity of the logic, the need for data persistence, and performance considerations. Evaluate your specific requirements and determine which approach suits your scenario better.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (