Hi,
I have Different Tables which I would like to be viewed & entered from One view.
How shall I achieve this.
I tried REF_ROWs(โTable nameโ, โText Valueโ) but, itโs not showing in the form from which I call the tables.
Thank you.
Solved! Go to Solution.
Hi @Kanha_PM_Office Is your Sleep & Dreams Ref marked as "Is Part Of "
Please provide more detail on your intent. Are you trying to create a launcher?
Ok.! Sorry about that.
I have Two Tables,
Through Project form, the Supervisor enters the details like, Project type, Location, Work Description, etc. Along with it , we need to include Labors worked in that project.
Instead of entering every details of the Project as mentioned above separately , for that particular project details, I would like to have the reference to Labor, where Labor details like Id, Time, Name, Type, etc would be entered separately.
This is very similar to Order Capture Sample App, but couldnโt get it working.
Iโve tried it with similar other app, where in One form, I would like to Call or Reference other tables which denotes different forms.
Hope this is clear.
One way of solving this is having creating an action i.e Labor form Action that opens Labor form, whereby you set the initial values in the Labor form using the formula Linktoform(โLabor formโ, โProject IDโ, [Project ID] )
โProject IDโ - is a column in the labor table that refs the Project table
[Project ID] - The value of Project ID in the opened Project form
On the โProject formโ, go to Behavior, event actions - choose the Labor form Action - this means on saving the Project form, it automatically opens the Labor form, sets the Project ID column with the value from the project table, and you can fill the remaining information
Ok. Let me try this Jeremy!
Thank you for your suggestion.
Hi @Kanha_PM_Office Is your Sleep & Dreams Ref marked as "Is Part Of "
No.!
But, for me I donโt have any connection from Sleep & Dreams Table to Daily Sadhana like how they have Orders Id & Order Details! (i.e., I am not calling Daily Sadhana from Sleep & Dreams).
I just use the latter to call the former as an everyday task list.
Given the similarities between Order Capture and your app, itโs probably best to consider the problems you had with Order Capture. What sort of problems did you have?
Hi, Actually, I tried the same but, itโs not showing in the Form View.
Attached Screenshot of the same for your perusal.
Formula for Virtual Column : REF_ROWS(โSleep & Dreamsโ, โEntry Idโ)
I have even tried as โTextโ type.
The form looks like this.There is no option linking โSleep & Dreamsโ table.
This is how the โSleep & Dreamsโ Form looks.
Thank you.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |