Hi!
Iโm trying to make a report that pulls in data from โClient profileโ table based on a reference id from โApplicationโ table. When I try to save the workflow, the below errors occur. I believe you can use dereferencing in reports or canโt I?
Thanks in advance.
Solved! Go to Solution.
Try this.
Go to [Reference Id] field setting which should have been set as REF type.
Turn on โIsPartOfโ setting.
Try this.
Go to [Reference Id] field setting which should have been set as REF type.
Turn on โIsPartOfโ setting.
@tsuji_koichi thank you. It worked but not fully i think? The error is gone but there was no data fetched. Please find the below snap shot of my template.
and hereโs the result
Thank you for your help in advance.
Good. One step ahead.
As far as Appsheet returns NO error, expression should be working fine.
I just suspect there is no [Reference Id] value being selected for this [Full Name] for โDaria Gagarinโ. Are you sure there is value for Reference Id for the row of Daria Gagarin?
Wonderful! You are right! All good now! Thank you so much for your help!
Good to hear you solved problems.
Hi @tsuji_koichi or anyone whoโs free to help, sorry but I have encountered a problem again. Iโm trying to pull in data from another table aside from my โClient profileโ table. My table where Iโm pulling the other data from is called โEmploymentโ table with the same reference id. Please see the below error.
My report expression looks like the below.
Any help would be appreciated!
Thanks.
[Employment] field seems to be ref type, reference to child table and rows.
So you need to put deref expressions for address, Company name, job title , years in service, montly net pay.
[Employment].[Company name]
[Employment].[Address]
cont.
@tsuji_koichi Hi. Actually, โEmploymentโ table is like the โClient profileโ table and has the same reference id from โApplicationโ table. The Reference Id โIspartofโ of the โClient profileโ and It wont pull the data from โEmployment tableโ so I had to create another columns as Id for my different tables and turn on โIspartofโ but unfortunately appsheet doesnโt allow that. The below is my โApplicationโ table
My data model is like this, I have a โClientโ table with a key and that key is the key in all my tables: Client profile, Spouse, Employment, Co_borrower, Business and etc. What Iโm trying to do is put all those data in a report and send it via email. I have already accomplished (with your,@tsuji_koichiโs help) the Client profile. Now I need to pull in the data from my other tables but Iโm stuck.
Any help will be appreciated. Thanks!
Please place screenshot for your column setting for the target table where we can see all the column name and data type etc.
Here you go.
Iโm trying to pull in those data using the โReference Idโ which is my โClient profileโ key but the below error occurs.
thank you in advance!
I mean trying to pull in the data from each Ref_rows.
there is no [reference id] field right here.
Sorry. The โReference Idโ is in my โApplicationโ table which triggers the sending of the report once saved.
That Reference ID is actually my Reference column in my โClient profileโ table and in all other tables.
You need to make a relationship with this table with others first of all. For the moment, there is no ref relationships. Review tables and data schema globally.
Could you elaborate more please of making a relationship with other table? The below โReference IDโ is a reference column found in all of those tables. For example, the โReference IDโ ,8ea7bde3, is the reference in all of my tables (Client profile, Employment etc)
Or do you mean by making ref_rows in my โApplicationโ table?
Thanks.
Iโve been trying different methods but im still getting errors. Hereโs what I did:
Iโve created another column that is exactly the same as Reference Id. Both are of reference type and referencing to respective tables. But I still could not get it right.
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |