Calculation based on lookup
Hi, I have the following I am trying to achieve FormA.Product_ID FormA.Weight_Per_Item FormB.Product_ID is dropdown/lookup from FormA data FormB.Quantity FormB.Total_Weight trying to get this to populate based on FormA.Weight_Per_Item * FormB.Quantity Any help would be appreciated
Adding a field from another form database on success
A visitor fills out the form Landing_Page and enters a Promo Code. On success I need to look up the entered Promo Code and match it to the promo code library form called Promo_Code. After a match I need the associated consultant from that promo code record (in the Promo_Code database) to be added to the record that the visitor just created when they completed the form. Please advise how to do this
how are subform entries related to the parent record?
I want to be able to use a custom action to add a sub form record but don't understand how the sub form record is related to the parent record. My custom action adds a subform record but it doesnt seem to be related properlly. I have a custom action that opens the sub form but seem to be missing the part that will relate the new sub form entry to the parent record that the custom action was executed on. The custom action code im using is: void Payment(int ID) { openUrl("#Form:Payment?Request_ID="
Picklist within subform
Good afternoon, I have a picklist inside a subform wich I dynamically populete base on a lookup field. Is there any way to select one item on the picklist?? I try row.<fieldlist>.select(value); But the system answer: <fieldlist> does not exist in this form Thanks in advance for your answer. Ricardo
Customer Portal Basic Questions
How can a user change his email? Are there plans to customize the sign-up from with more fields? Upon sign-up, there seems to be no way to control where the user lands in the application. True? Since I'm building the app in my own account with an intention to export the ds file to my customer, will my customer have issues with the customer portal aspect upon ds file import? Cheers, John Whitney
zoho.loginuserid not working for customer portal
A few hours ago if I logged in to my customer portal app, a form with Email=zoho.loginuserid; would correctly display the email of the user. Now it's simply blank. However, if I place <%=zoho.loginuserid%> on an html page, the email is displayed to the portal user. Something must be broken with the customer portal? I submitted a support ticket and shared the app with zoho. Cheers, John Whitney
Populate data field
Hi, How can you do that when you select a dropdown and a number is typed into a text field will auto fill other field and the final amount has to be half the user write. Dropdown field name: Tipo_de_Prestamo Data field with the amount : Prima Data field to populate: Comision
custom action to edit record
Is there a way to use a custom action to open the edit record dialogue? I want to avoid passing data back and forth between a stateless form and also do not want users using the standard edit record method. I want a custom action that opens the record for editing. Is this possible? Does the edit record popup have a url i can pass to the OpenUrl() function? Is there another way? thanks
I want to add a value to specific decimal field in one record, with the value in a decimal field in another record based on what is selected in another field.
I want to add a value to specific decimal field in one record, with the value in a decimal field in another record based on what is selected in another field. example,... project db, has the following fields, project number elec design hours mech design hours technician hours assembly hours time entry table has the following fields Project number job function (drop down with selection of elec design, mech design, technician design, assembly) Total hours I would like to update the proper field in
Zoho Creator REST API
I'm trying to extract some data from a Zoho Creator App using perl as follows: #!/usr/bin/perl use HTTP::Request::Common; use LWP::UserAgent; $ua = LWP::UserAgent->new; my $req = GET 'https://creator.zoho.com/api/slowclay/xml/copy-of-slow-clay-registration/view/student_view', [ authtoken=> 'bd73c9ac318d2fab9f8d89fce9509c29', scope=>'creatorapi', submit=>'View Records', ]; $content = $ua->request($req)->as_string; print "Content-type: text/html\n\n"; print $content; But I just get the response
Need help creating a simple search interface PLEASE!
I've created a form that organizes job, job id and location in a form, but I need help creating a simple search interface that makes those three things searchable, and brings up all the information about a particular item searched. (For example, when i search LPN, I want it to show me "LPN", the job id AND the location. How can I do this? Please help!! I've tried for hours to figure out this coding ,but it just isn't working for me! Thank you in advance to anyone who's willing to help!!!!!
Set default value in lookup field after submission
If I have a lookup field (dropdown) with countries, is there any way when I select a country and click submit then automatically set this country as default? . Can you please send me an example of this? I tried (in On Load) to fetch records like value = Country [Name_of_Country = "Germany"].ID; Lookupfield.select(value); With a country like Germany it works but I do not want this.
HTML in a formula field being displayed in a view as text
Hello, I have been using HTML in formula fields for some time and no problem at all. Today I was developing an application where the HTML code in the field resulted in plain text shown in the view. Is there anything I am missing? I am talking about a code of this sort: (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_View?MOB_idstr=") + MOBID) + "\">View Details</a>" below you can see what I am talking about, the field Titulo is a formula
HTML Page - iterate rows for each record
Hi everyone, I logged a call with support a few days ago, but have had no response and need to get a report finished for tomorrow, so am struggling. Herb has been fantastic assisting me with resolving some other issues but I hope someone on here might be able to help on this point. I have a database of student data. I have created an html page to display the data held on 15 tables, all of which are linked to the student personal information through a FullName lookup. Some of the tables contain multiple
Create HTML+Deluge Script button in a Formula field???
A Zoho Creator developer recommended that I add a Formula field to my form that contains the following HTML+Deluge script in order to create a 'View Details' button. (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_View?MOB_idstr=") + MOBID) + "\">View Details</a>"What the code produces is seen below. Since this is put in a formula field it is displayed on any of the views in which I choose to view this field. The Deluge script pulls
Return the last two digits of the current year. For example return "14" in 2014
I wish to have it returned as a string value that i can concatenate into a file name. I guess that it is an index value truncation but I cannot remember.....
custom action html view
Can I build a custom action button and open in a pop up an html view? When I try this i get a popup that just says "loading view" and after awhile it closes but the html view never actually opens or shows. Is this a bug? I found another post from years ago talking about this problem. Has this still not been fixed? Please help I would prefer not to screw around on this for hours if its just plan old broken. My custom action forumla button has the following code: "<a class='zc-formbutton' href=#View:RFQ_Send_Production_Order?zc_LoadIn=dialog&Request_ID="
Refresh the Captcha
Is there any way that a user can refresh the Captcha? I have a couple of forms that require the user to correctly fill in the captcha before submitting data. During testing, I've on occasion had to either guess 4-5 times, substituting 0 for O, I for l, Z for 2 (you know what I mean), and have a few times had to resort to resetting the entire form and adding all the information in a second time, hoping the new captcha will be more obvious. Am I missing the tool that ZOHO provides to accomplish this?
Error inserting value to linked field
Hello, I have a stateless form that is uses "insert into" command to populate two tables, "Contacts" and "Contact_History" in the "On Click" script of the "Submit" button. First I insert data into the "Contacts" table. The "Contacts" table automatically adds a 'Contact_ID' value via an auto-numbering field. Next I fetch that Contact_ID value (assigned to 'r') and use it to add linked data into the "Contact_History" table, attempting to populate the 'Contact_ID' field which is a look-up to the Contacts
input. removed from formula fields
I have a custom action in a formula field using the following code: "<a class='zc-formbutton' href='#Form:Approve?zc_LoadIn=dialog &Vendor_ID=" + Vendor_ID + "&Request_ID=" + Request_ID + "&RFQ_Response=" + input.RFQ_Response + "' >Select as Winner</a>" Immediately after saving this code the input value of RFQ_Response is working and the form that opens up has the proper value in the RFQ_Response field. Trouble is, if i edit the button or save the form later the code on the custom action seems to
When creating a form is their a way to duplicate fields?
I am building a Materials Tracking application which has both shipping and receiving forms. On those forms we have 24 pallet and weight fields. Each Pallet field would be a drop-down to select the type of commodity being shipped or received. I would like to add them without having to manually input all options for each field. Also, as an add on question, is there a way to show the next pallet and weight fields only if the previous have been filled out? Thanks, Chris
You have reached maximum number of rows. You can not add further
When I try to use a subform and add an entry I am getting the following pop up message that prevents me from adding new items in any of my sub forms across all creator applications: "You have reached maximum number of rows. You can not add further" Seems pretty self explanatory except we are no where near our record limit so this doesn't make sense. Is there a way to increase the number of rows allowed? Clearly either i do not understand what this message means or there is something wrong with
Update formula field with schedule
Is there any way to update a formula field that calculates the number of days between the current date and a future date using a daily schedule? I know you can't get a formula field to automatically recalculate (totally ridiculous but let's ignore that now). Is there a way to use schedules to update the formula field or another field that contains a number? I'm thinking pass the difference between the current date and a future date to a numeric field. Then on a daily basis use a schedule to subtract
Anyone else having issues posting a requirement on Marketplace?
I have reached the limit of my capabilities and was looking to post a requirement for developer assistance having a new html page populated with fields from my database, but every time I attempt to post, I just get a posting error. Anyone else having trouble with this?
Setting criteria for execute script with .getDayOfWeek()
Good Morning, I'd like to create criteria for execute a schedule. My intention is to have an alert with differencial text based on the days missing for the event and also according to the day of week in which the event will be occured. The first step is done, how you can see from the image. I used DATE.FIELD= zoho.currentdate.addDay(2), in this way the mail will be sent when missing two days, but I had problem with second criteria. When I try to differentiate the days of week to have a different
Linking a subform after data import
Hi, Im trying to import my data and structure from an access database into Creator. While the import works, after I have edited the forms i want to add subforms based on their relationship. I can set this up but there is no way I can see that links the 2 records. Please can you show me how to link a subform to its parent after data import? Thanks Amy
Currency field not formatted in HTML View
I don't know if this is a bug or expected. A currency field that is appropriately formatted for a normal view, is not formatted when using the <%=field%> tag in an HTML View. I am having to hard code format it. Please advise if this behavior is expected (and why)...or is it a bug? Thanks! Robert P.S. By formatted, I mean it is not rounded to two decimals, there is no currency sign, and there is no comma insertion.
Double floating header in custom action button glitch
I have a custom action button that seems to have a strange glitch attached to it. The custom action button opens up a view and the header seems to be duplicated. I cant get rid of it with out navigating to another page and back again. This is very frustrating. What is going on and why is this happening. Someone started to look into this but I have not got any response yet and its been a while. THis happens in the following view: https://creator.zoho.com/precisionsailloft/prod/#View:Sent_for_RFQ
Switch Display Type for embedded view
Is there a way to display the cogwheel to change the display type when a view is embedded in a website? When the view is seen in the Zoho Application the cogwheel gives choices for View As List, Summary, Grid, Spreadsheet. When embedded this option is gone.
Creator not getting CRM data using Zoho CRM field
I am new to Zoho Creator and have searched the help, support, this forum, and the web for a solution. I am having a problem getting the Zoho CRM field to work. I upgraded my CRM account to Enterprise to get the Creator integration and am paying for the Standard version of Creator to get CRM sync. (I'm still not sure if I needed to upgrade from CRM Proffessional to Enterprise to get Creator to pull data from CRM. But, because I'm having this issue, I upgraded to see if it would solve the problem.)
Possible bug
Hi All, Apologies if someone else has spotted this but when duplicating a form by copying the With Action definition from the original and pasting it into the new form, if the word "unique" is in the script, an "null" error message will be shown. If you remove the existence of the word "unique" from the xml, the script will then save correctly. Perversely, once the script has been saved, you can put the "unique" word back and the script will still save ok.
Connect applications in the sections of a main application
My company needs a huge application with a combination of subapplications. So I would like your opinions for the structure of the application. Let's say that I have a main application (Extranet) with sections Inventory, Managing, Trading. It's section is a separately application. For example Inventory has forms for hotel details, type of rooms, room prices etc, Managing has another 4-5 forms etc. The same with Trading. My question is how can I connect these 3 subapplications in the main Extranet
And If
Is there a way to perform an "And If" I have work orders being sent to my office when they are completed by the tech. I also want to be able to send some of my customers a copy of the completed order when complete. But not all of them, just certain ones. Example; Work Order If input.Billable = yes then email else If input.Billable = No then email and if Customer = Joe send email to Joe's boss "I only want to send email if the customer is listed"
Create HTML view of records
Hello I would like to know if its possible to create a HTML view which shows a summary of two forms that are related. My situation is as thus: I have two forms Clients and Commissions. In the Clients form I have an agent and client. In the Commissions form I input the commission for each client. [This is the related link]. I would like to know if its possible to have a HTML view which allows me to show the total received by each agent, and I can also choose the month. The HTML view should show all
Cancel button not working when I open record in a new window for editing
I've created a field that displays a link in my view allowing users to open the form in a new window for editing (to avoid the popup/floating window, which creates problems for us in certain situations). The problem is, the "Cancel" button no longer works in this window. "Update" works fine, and the user can close the window to avoid updating, but I'm afraid that if the cancel button doesn't work, they will feel forced to click "update", which could lead to data loss or input errors. Is this a bug
Function tolong()
What's wrong with the following that I keep getting the error message below? temp_list=List(); for each selection in Team_Members { e = Team_Members[ID == selection.tolong()].Email_ID; temp_list.add(e); } Team_Members_Text_List=temp_list.tostring(); Error at line number : 4 Not able to find 'tolong' function
function page error
Hi, When I'm trying to click on define a function in Custom Actions it gives the following error
Android native app for Zoho Creator
Team, What is the latest update on the availability of a Zoho Creator native app for Android & iOS? Thanks
IOS App Suggestions for Offline Front-end Using ZC as Back-end
I need to be able to collect data offline. Does anyone have experience with or a suggested app that is available on the market? I don't want to waste my time with junk as there are many apps out there. Thanks for any suggestions!
Expanding field in zoho creator
I'm working on a project which includes showing created leads from zoho crm into zoho creator form. i.e if there are 2 leads, 2 lead names should be visible on the form . Which field can we use for this purpose in "form builder" to build this application in zoho creator which gets expanded in accordance no. of leads names available to be shown ?
Next Page