How Can I iterate through Radio Buttons
I have a Form with a number of Radio Buttons. I want to create a drop down list in a second Form based on the values of all the Radio Buttons (their names, I guess) whether or not they are selected. Bruce "Speedy G" Peaslee The World's Fastest Programmer
Fetch records
Hello, I need to set a report criteria based on a form from a different application, Is this possible? And also, how can I fetch a lookup field by its ID? Thanks.
HTML View help
Hello all In my application I am trying to create a HTML view that allows me to capture details for my workers. The code is attached below: htmlpage Tankkarte_Details(ID) displayname = "Tankkarte Details" print = true pdf = true content <%{ Mitarbeiter = Personalien [ID == input.ID.toLong()];%> <strong> Mitarbeiter</strong>: <u><%=Mitarbeiter.Name%> <%=Mitarbeiter.Vorname%></u><%if (Mitarbeiter.ID == input.ID.toLong()) {%>
Issue in Script Builder Updating a Long-List
I made a function to clear a long-list field type from my database, but it was reporting this error: The only way I could get it to work was build the code in free-flow script mode: void DELETE_MEMBERSHIP() { for each row in parent_database { row.Schools = List:Int(); } } Clearly a bug! Cheers, John Whitney
Can I import data to CRM field?
I have a form in my application into which I am wanting to import data from a CSV. The form contains a CRM field. I have tried importing using the Lead_ID from CRM as the value for this field, however this does not work. I have tried importing using the Lead_Name from CRM as the value for this field, however this does not work either. Can anybody tell me what value can I use on import to link to the correct record in CRM? Cheers, Bianca.
Import new data plus associated sub-form data
For importing data there is a checkbox - "Do you want to import subform data". It appears that this option does not allow for sub-form records to be imported against a single parent record, instead the import routine imports the sub-form record data against new parents. Can someone confirm this?? If so it is not worth having this subform import checkbox unless there is only one sub-record associated with each parent which really defeats the purpose of having subforms..?
On Load, On Success: Add Record
How do I add multiple records to FormB in one fell swoop? Form A has fields for StartDate and EndDate, and Duration (a calculated field) Let's say July 1, July 6, and 6 I want to insert 6 rows into FormB (one for July 1, July 2, July 3, July 4, July 5 and July 6) thanks
Published App can Add, but can't Edit records. Why?
Hello, I published the below app forms to the public so that a customer can see the forms I created for him. He can add records with the Add Invoice link below, but he can't edit records in the Edit records link below. How can i change the form so that he can edit records? Add Invoice https://creator.zohopublic.com/iramalvarez1/published-qcr/form-perma/Invoicing/A6UKh9uAMga1eg9YCguh3xVN0pgySddyXpkF34UaUzPSsE2dOADC525pKBwBUAODBBCpfrFK0Ka4vNFn6j0DyjnJqabSOMwtxnf1 Edit Records https://creator.zohopublic.com/iramalvarez1/published-qcr/view-perma/All_Invoices/dHH2skxRqbbN6eMjyZDyp7RhbO82h8d9pG22jVeEqA1NxK7aObumW3DSQVP9GyByTqy6Q5q1muEKECMnRvv52UKTHsfFOABMseS7
Can I access a Pivot Table via a Custom Action?
I know how to write a function, so I can access a form or view via a custom action. What is the syntax for opening a pivot table?
Can I extract the link name from Url datatype?
So, is this possible? I have Url datafield; the url goes to a map. The Linkname has the mileage. But I would love to access the mileage for calculations; is there a way to extract that tidbit of info to another field?
Where do we report Creator "Reports" issues?
I am currently beta testing the "Reports" interface in Creator. It has a lot of potential and also a few bugs. Is there a system for bug reporting already set up for those testing this functionality. I have a number of small issues already and can't move forward until they get fixed.
Open Report filtering by multiselect field.
I want to open a report using the following link "<a href='https://creator.zoho.com/" + zoho.appuri + "/#View:Task_Report?Staff=" + input.Staff + "'target='_blank'> View Tasks</a> "; The report opens but shows no data available. I think the problem is that Task_Report.Staff is a multiselect field. The following code is almost identical but uses State which is a single select field. It works as expected. "<a href='https://creator.zoho.com/" + zoho.appuri + "/#View:Task_Report?State=" + input.State
Set values to null if fields are hidden and not relevant
Hi all, Let's take a radio button R1 with options Yes and No. If you click on Yes, another radio button R2 appears with options A and B. Then you click A. But then you realize that you made a mistake and you wanted to click No on R1. You click on No, R2 disappears because it is relevant only if R1 is Yes and you submit your form. The problem is that R2 still has the value A, which is wrong because A is only valid if R1 is Yes. How would you do to set it to null if this case happens ? I did resolve
Calculating Differences between Records - Limitations?
Hi, I'm trying to understand if ZOHO can handle this. Tanks have daily gauges - in Feet, Inches and Quarter Inches. I'm wanting to calculate the differences between records to report on daily production. I have created a formula field that takes (feet *12) + inches + quarter inches. I'm not seeing a way to use pivot charts (or any other report) to calculate and graph these changes. Am I am missing something simple? Thanks,
Dashboard Templates for Zoho Creator
Do you have to propose me or are there some ready dashboard templates for zoho creator applications? I know that there are some templates when I create a new page but my question is if there are somewhere more creative templates for zoho creator (paid or free).
Sendmail Limit approaching 500, do I get a warning email?
I have multiple forms which trigger sendmail actions and I am concerned that as my volume of subcribers increases, I will approach my limit of 500 emails per day. Will I get a warning email saying "You have reached your limit of 500 emails per day. Please log on to Zoho Creator to review your Usage Log Details and optionally add a $10 for +500 emails per day to your account."? I would rather not have to script this to count every sendmail action and then email zoho.adminuserid when limit is reached,
Email Orders
I presently have a view to show me Orders. I would like to know if there is an easy way to add an Email function to the left drop-down lists (Edit, Print,View). If not is there a custom email app all ready that I can you on selected orders? Sample to mail; WO Number 7134 Status After Service Call Complete Customer Name wtfcu Date Jun 16,2014 Terminal ID Model 5890E CPM/BNA Reported Problem Other Error Details they are having problems with the bottom part of ATM that is opened using a key - they cannot
How do I add multiple keys fields to a single form?
Sorry for such a basic question, but how do I specify multiple key fields for a single form? E.g., an apartment is uniquely identified by the combination of (1) the building number, and (2) the unit number.
auto-filling form field from url
hi, guys! how can i make creator's form so that 1) there will be a number of hidden fields and a number of seen fields? as seen - phone field, for example 2) hidden fields auto-filled from url string url example - Google Adwords URL http://www.okdekor.ru/?url={lpurl}&adwnetwork={network}&adwplacement={placement}&adwadposition={adposition}&adwcreative={creative}&adwmatchtype={matchtype}&adwkeyword={keyword}&adwdevice={device} hidden field with name "adwnetwork" - auto-filled with content of "{network}"
Can a Form in Application A be referenced in a Zoho Page in Application B
I have a set of forms (tables) that are common and needed in a number of applications within a Zoho account. I would like to avoid duplicating the forms and its data in every application. These tables reside in Application A. Now when I am creating forms in Application B, I can reference these tables of Application A in Look ups without any issue. However, if I try to write Deluge code in HTML pages in Application B, it does now seem to work. Here is how I am referencing form of Application A in
How to set default values of multi-check field?
so, a form has a multi-check field, with n items. What code do I put in the on load, so that some of the items are checked by default when the form loads?
For Each Builder is Broken
Cheers, John Whitney
Null Check in FX
Hi, Just created an overtime form for staff, but my Zoho is somewhat rusty after several years. Hours are calculated between a start date:time and end date:time: "Minutes" <((End_Time - Start_Time) / (1000 * 60)).round(2)> "Hours" <(((End_Time1 - Start_Time) / (1000 * 60)).round(2) / 60).round(2)> From these Minutes, I calculate how many hours were worked and if the person is eligible for 1.5xpayment or 2xpayment. "Overtime 1.5" <((Minutes - 450) / 60).round(2)> "Overtime 2" <((Minutes
Image note displaying when creating PDF from url
I created an HTML view with our Logo Image in the header. It appears when viewing the report, but not when directly creating a PDF from a zoho creator url. The source of the image is from a Zoho creator view <td width="60%"><img src="https://creator.zoho.com/ghsagjv/projects/Genre_LogoView/Image/image-download/1400541422986_GHSAGLogo.png" alt="" /></td> Screen shots are attached, that shows the same HTML page being opened in print view, and coverted directly to pdf. The pdf is created with a small
Deluge Field name moved
I love it! Thanks for moving the deluge field name closer to the display field name!
From Free-Flow Scripting, see: View names and Functions
When I'm in Free Flow scripting, I can use the Refer Fields link to reference forms and fields. That's great but I'd also like to reference: Functions with their parameters View/report names (which I need to reference using share/unshare)
Permalink (Publish) form - unable to customize
First off it's been about four months since I setup a permalink to any form for public access so I realise the interface for this specific instruction set has changed in that time. OK so from my form I select Permalink and in the dialogue I select Publish, to make it public then hit Customize. I'm dropped back to the editor window and am shown a preview which updates as I change fonts, fields sizes, etc within the customization pane on the right side of the browser. The problem is the Publish URL
Functional-based URL strings with lists
In regard to functional-based URL strings at https://help.creator.zoho.com/Functionality-based-URLs.html I have a question about calling a view based on a list, generated from check-boxes on a form. Let's say the criteria is PET and the user can select any of Cat, Dog, Bird, Cow, Snake. How do we call a view based on PET={Cat, Snake} for example? Something like http://creator.zoho.com/admin/users/#View:User_View?PET={Cat, Snake} ?? John M. Whitney
Function Script Disappearing
I have a script to create a concatenated string (thanks Cyril). It works great in workflow under On Add/On Success and On Edit/On Success. What I would like to do is to put this script into a function and just call it in the workflow that way. I tried creating a new function and added the script. I saved it and called it in the workflow. No go when run. Blank. I go back to the script editor and the script is gone except for the bit on top for the string. Tried it a few more times, same result. Also
iPhone App won't display reports in calendar view
I cannot get the Creator iPhone App to display a report that is calendar view. It closes the App when you try to open it. I have tried several reports. Works on Android App. Is this an issue?
On insert access
Hi, I have created a custom action on the form A, that execute a custom function that insert a new record in a form B: void richiestaApi(string dominio, int registrarID, int operazioneID) { insert into B [ Added_User = zoho.loginuser Dominio = input.dominio Operazioni_disponibili = input.operazioneID Registrar = input.registrarID ] } I have also created a script On insert On access on form B, but it is not executed, even if the new record has been correctly created. If i
View an uploaded file without downloading?
So, once a user uploads a pdf, is it possible for a user to click and view the pdf in a new window, rather than downloading it and then opening?
is it possible to insert a data field into an alert?
I would like to reference a field in an alert box, how do i do that, is it possible?
Subform Fetch/Lookup
I am having a problem setting up a fetch lookup to a form that uses a subform. I have attached some screenshots to help me explain. Here is my main form. The BOM subform section is added as I create the MMR(master mfg record) Once my MMR is setup I will need to create a BPR(batch production record) for each production run that will include everything from the MMR. Here's what I have so far on the BPR form I have the lookup MMR set up & it works to bring in the Product_Name But I get an error when
Function definition
The zc help shows this example for a function. What should the code look like if I'm adding in a 2nd argument? openUrl(“#Form:Add_Meeting_Attendance?meetingid=” + input.id + “”, “popup window”, “height=400,width=550″);
can subform include loginuser and dated posted?
Can either type of subform (the one that is embedded into a field, or the one that connects to a separate form), include columns showing the logged in user and the date?
Combining Multiple Related Data On One View In Creator
I need to combine data from multiple forms on one view, similar to your CRM Accounts view. I need to have a main organization record with sections for contacts, etc. under it. I searched the forums and knowledge base, but cannot find the answer.
FieldType: Multiselect vs Checkbox
What is the difference between these 2 fieldtypes: 1. Multiselect - and then I can choose dropdown or checkbox 2. Checkbox
Scanner Interface
Is there a way to scan a document directly to ZOHO and add user defined terms?
view only field
I have a parts_Used form that I want to show the current on hand quantity of a part. I only want to show the user the current on hand and not allow any changes to the field. Is this possible? The field I'm currently using is a numeric type.
Next Page